RE: DBI->data_sources('Oracle')

Change your sqlnet.ora to read:

Names.directory_path = (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@xxxxxxxx]
Sent: Tuesday, May 02, 2006 1:55 PM
To: Loo, Peter # PHX
Cc: dbi-users@xxxxxxxx
Subject: 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@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,

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@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/


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
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.

.

Relevant Pages

  • RE: sth->do()
    ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ... review, use, disclosure or distribution is prohibited. ...
    (perl.dbi.users)
  • RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve : Out of memory
    ... large result set into memory? ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)
  • RE: sth->do()
    ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)
  • RE: Using Oracle Internet Directory (OID) instead of TNS Names
    ... Using Oracle Internet Directory instead of TNS Names ... They who would give up an essential liberty for temporary security, ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)
  • RE: sth->do()
    ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)