DBI->data_sources("Oracle")

------_=_NextPart_001_01C66E14.5EEAA2C2
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi All,
=20
Will someone please tell me where this module is getting the information
from? One of my severs that I am trying to connect to is NOT listed in
the output of:
=20
@databases =3D $dbh->data_sources('Oracle');
=20
Thanks.
=20
Peter
=20


This E-mail message is for the sole use of the intended recipient(s) and =
may contain confidential and privileged information. Any unauthorized =
review, use, disclosure or distribution is prohibited. If you are not =
the intended recipient, please contact the sender by reply E-mail, and =
destroy all copies of the original message.

------_=_NextPart_001_01C66E14.5EEAA2C2--

Re: DBI->data_sources("Oracle")

First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or
$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.

Alexander
On 02.05.2006 20:15, Loo, Peter # PHX wrote:

>Hi All,
>
>Will someone please tell me where this module is getting the information
>from? One of my severs that I am trying to connect to is NOT listed in
>the output of:
>
>@databases = $dbh->data_sources('Oracle');
>
>Thanks.
>
>Peter
>
>
>
>This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

RE: DBI->data_sources("Oracle")

> -----Original Message-----
> From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]=20
> Sent: Tuesday, May 02, 2006 2:15 PM
> To: DBI users
> Subject: DBI->data_sources('Oracle')
>=20
> Hi All,
> =20
> Will someone please tell me where this module is getting the
> information from? One of my severs that I am trying to connect to is
> NOT listed in the output of:
> =20
> @databases =3D $dbh->data_sources('Oracle');
> =20
> Thanks.
> =20
> Peter

This will tell you for sure:

export DBI_TRACE=3D1
perl -MDBI -le 'print foreach DBI->data_sources("Oracle")'

Philip

RE: DBI->data_sources("Oracle")

Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and
instead use Oracle Internet Directory?

-----Original Message-----
From: Alexander Foken [mailto:alexander@foken.de]=20
Sent: Tuesday, May 02, 2006 11:29 AM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: Re: DBI->data_sources('Oracle')

First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or
$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.

Alexander
On 02.05.2006 20:15, Loo, Peter # PHX wrote:

>Hi All,
>=20
>Will someone please tell me where this module is getting the=20
>information from? One of my severs that I am trying to connect to is=20
>NOT listed in the output of:
>=20
>@databases =3D $dbh->data_sources('Oracle');
>=20
>Thanks.
>=20
>Peter
>=20
>
>
>This E-mail message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the sender by reply
E-mail, and destroy all copies of the original message.
>
> =20
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and =
may contain confidential and privileged information. Any unauthorized =
review, use, disclosure or distribution is prohibited. If you are not =
the intended recipient, please contact the sender by reply E-mail, and =
destroy all copies of the original message.

Re: DBI->data_sources("Oracle")

As far as I understand DBD::Oracle (the driver DBI uses for Oracle), it
is "just" a translator for the Oracle Call Interface (OCI), and to my
knowledge, OCI uses TNSNAMES.ORA. If you use a recent Oracle client
software, the OCI may perhaps emulate a TNSNAMES.ORA based on the Oracle
Internet Directory. *If* that works, it is documented (or should I say
burried alive?) somewhere in the Oracle documentation. My guess is that
you would add some special entry to TNSNAMES.ORA to make the OCI lookup
databases in the Oracle Internet Directory.

Alexander

On 02.05.2006 21:09, Loo, Peter # PHX wrote:

>Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and
>instead use Oracle Internet Directory?
>
>-----Original Message-----
>From: Alexander Foken [mailto:alexander@foken.de]
>Sent: Tuesday, May 02, 2006 11:29 AM
>To: Loo, Peter # PHX
>Cc: dbi-users@perl.org
>Subject: Re: DBI->data_sources('Oracle')
>
>First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or
>$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.
>
>Alexander
>On 02.05.2006 20:15, Loo, Peter # PHX wrote:
>
>
>
>>Hi All,
>>
>>Will someone please tell me where this module is getting the
>>information from? One of my severs that I am trying to connect to is
>>NOT listed in the output of:
>>
>>@databases = $dbh->data_sources('Oracle');
>>
>>Thanks.
>>
>>Peter
>>
>>
>>
>>This E-mail message is for the sole use of the intended recipient(s)
>>
>>
>and may contain confidential and privileged information. Any
>unauthorized review, use, disclosure or distribution is prohibited. If
>you are not the intended recipient, please contact the sender by reply
>E-mail, and destroy all copies of the original message.
>
>
>>
>>
>>
>>
>
>
>--
>Alexander Foken
>mailto:alexander@foken.de http://www.foken.de/alexander/
>
>
>
>This E-mail message is for the sole use of the intended recipient(s) and
>may contain confidential and privileged information. Any unauthorized
>review, use, disclosure or distribution is prohibited. If you are not
>the intended recipient, please contact the sender by reply E-mail, and
>destroy all copies of the original message.
>
>
>This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

RE: DBI->data_sources("Oracle")

Change your sqlnet.ora to read:

Names.directory_path =3D (LDAP)

This assumes you have a proper ldap.ora file in the same location as
your sqlnet.ora.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Alexander Foken [mailto:alexander@foken.de]=20
Sent: Tuesday, May 02, 2006 1:55 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: Re: DBI->data_sources('Oracle')

As far as I understand DBD::Oracle (the driver DBI uses for Oracle), it=20
is "just" a translator for the Oracle Call Interface (OCI), and to my=20
knowledge, OCI uses TNSNAMES.ORA. If you use a recent Oracle client=20
software, the OCI may perhaps emulate a TNSNAMES.ORA based on the Oracle

Internet Directory. *If* that works, it is documented (or should I say=20
burried alive?) somewhere in the Oracle documentation. My guess is that=20
you would add some special entry to TNSNAMES.ORA to make the OCI lookup=20
databases in the Oracle Internet Directory.

Alexander

On 02.05.2006 21:09, Loo, Peter # PHX wrote:

>Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and
>instead use Oracle Internet Directory?
>
>-----Original Message-----
>From: Alexander Foken [mailto:alexander@foken.de]=20
>Sent: Tuesday, May 02, 2006 11:29 AM
>To: Loo, Peter # PHX
>Cc: dbi-users@perl.org
>Subject: Re: DBI->data_sources('Oracle')
>
>First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA or
>$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.
>
>Alexander
>On 02.05.2006 20:15, Loo, Peter # PHX wrote:
>
> =20
>
>>Hi All,
>>
>>Will someone please tell me where this module is getting the=20
>>information from? One of my severs that I am trying to connect to is=20
>>NOT listed in the output of:
>>
>>@databases =3D $dbh->data_sources('Oracle');
>>
>>Thanks.
>>
>>Peter
>>
>>
>>
>>This E-mail message is for the sole use of the intended recipient(s)
>> =20
>>
>and may contain confidential and privileged information. Any
>unauthorized review, use, disclosure or distribution is prohibited. If
>you are not the intended recipient, please contact the sender by reply
>E-mail, and destroy all copies of the original message.
> =20
>
>>=20
>>
>> =20
>>
>
>
>--
>Alexander Foken
>mailto:alexander@foken.de http://www.foken.de/alexander/
>
>
>
>This E-mail message is for the sole use of the intended recipient(s)
and
>may contain confidential and privileged information. Any unauthorized
>review, use, disclosure or distribution is prohibited. If you are not
>the intended recipient, please contact the sender by reply E-mail, and
>destroy all copies of the original message.
>
>
>This E-mail message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the sender by reply
E-mail, and destroy all copies of the original message.
>
> =20
>


--=20
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.