Re: DBI->data_sources('Oracle')
- From: alexander@xxxxxxxx (Alexander Foken)
- Date: Tue, 02 May 2006 21:54:53 +0200
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@xxxxxxxx] Sent: Tuesday, May 02, 2006 11:29 AM
To: Loo, Peter # PHX
Cc: dbi-users@xxxxxxxx
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,and may contain confidential and privileged information. Any
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)
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@xxxxxxxx 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@xxxxxxxx http://www.foken.de/alexander/
.
- References:
- RE: DBI->data_sources('Oracle')
- From: Peter # PHX Loo
- RE: DBI->data_sources('Oracle')
- Prev by Date: RE: DBI->data_sources('Oracle')
- Next by Date: Re: Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- Previous by thread: RE: DBI->data_sources('Oracle')
- Next by thread: RE: DBI->data_sources('Oracle')
- Index(es):
Relevant Pages
|
|
