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:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 11:29 AM
To: Loo, Peter # PHX
Cc: [email protected]
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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] http://www.foken.de/alexander/
