Re: Using Oracle Internet Directory (OID) instead of TNS Names
Loo, Peter # PHX wrote: Jeffrey, The problem is that I need to know the version of the INSTANCE before logging on to it. No. There is no need to use the same version of Oracle on the client as is being used on the server. (Unless you are using the bequeather, which you are not.) What is necessary is to set ORACLE_HOME to point as the same installation of Oracle as was used to compile and link DBD::Oracle. -- Charles Jardine - Computing Service, University of Cambridge [EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Jeffrey, The problem is that I need to know the version of the INSTANCE before logging on to it. Peter -Original Message- From: Jeffrey Seger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 3:19 PM To: Loo, Peter # PHX Cc: John D Groenveld; DBI-Users Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names On 8/16/06, Loo, Peter # PHX <[EMAIL PROTECTED]> wrote: > Hi John, > > It turns out that the INSTANCE that I am trying to connect to is a > 32-bit 9.2 Oracle database while my profile is pointing to Oracle 10.2 > path. Once I changed the ORACLE_HOME to /opt/app/oracle/product/9.2, > the connection worked. > > Now I just have to remember that when I connect to an INSTANCE that is > lower in version than my local INSTANCE, I will need to first set my > ORACLE_HOME to the version I am connecting to. So the question now > is, is there a way to check dynamically what version the remote > INSTANCE is running? Is there a tool out there that would give me > this information or will I have to create one of my own? Trying not > to re-invent the wheel. :D > > Peter select version from v$instance But you should always be able to connect to older versions from a newer version $ORACLE_HOME. I suspect that the earlier suggestion of a possible 32BIT OCI bug may be the real issue. -- -- The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis. Dante Alighieri (1265 - 1321) They who would give up an essential liberty for temporary security, deserve neither liberty or security. Benjamin Franklin Our lives begin to end the day we become silent about things that matter. Martin Luther King The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment IV to the Constitution of the United States -- 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: Using Oracle Internet Directory (OID) instead of TNS Names
On 8/16/06, Loo, Peter # PHX <[EMAIL PROTECTED]> wrote: Hi John, It turns out that the INSTANCE that I am trying to connect to is a 32-bit 9.2 Oracle database while my profile is pointing to Oracle 10.2 path. Once I changed the ORACLE_HOME to /opt/app/oracle/product/9.2, the connection worked. Now I just have to remember that when I connect to an INSTANCE that is lower in version than my local INSTANCE, I will need to first set my ORACLE_HOME to the version I am connecting to. So the question now is, is there a way to check dynamically what version the remote INSTANCE is running? Is there a tool out there that would give me this information or will I have to create one of my own? Trying not to re-invent the wheel. :D Peter select version from v$instance But you should always be able to connect to older versions from a newer version $ORACLE_HOME. I suspect that the earlier suggestion of a possible 32BIT OCI bug may be the real issue. -- -- The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis. Dante Alighieri (1265 - 1321) They who would give up an essential liberty for temporary security, deserve neither liberty or security. Benjamin Franklin Our lives begin to end the day we become silent about things that matter. Martin Luther King The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment IV to the Constitution of the United States --
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi, It appears that OID configuration is working properly. I had used tnsping command to see what method it was using to resolve the INSTANCE. $ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 16-AUG-2006 13:44:46 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /opt/app/oracle/product/10.2/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCPCOM.OUT_DOMAIN.com)(PR OTOCOL=TCP)(Host=host_name)(Port=1521)))(SDU=32768)(TDU=32768)(CONNECT_D ATA=(SID=INSTANCE_NOT_IN_TNSNAMES_FILE))) OK (10 msec) Peter -Original Message- From: John D Groenveld [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 12:57 PM To: Loo, Peter # PHX Cc: DBI-Users Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: > >$ pstack core >core 'core' of 13643: /usr/bin/perl ./testCon.pl > fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 I'd wager that if you build the OCI demo, cdemo1, you'll core in the same place, which will be what your DBA will need to file a TAR. By default, the demo's build 64-bit, if you're using the 32-bit client libraries with a 32-bit Perl, then you'll need to adjust the Makefile. John [EMAIL PROTECTED] 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: Using Oracle Internet Directory (OID) instead of TNS Names
Hi John, It turns out that the INSTANCE that I am trying to connect to is a 32-bit 9.2 Oracle database while my profile is pointing to Oracle 10.2 path. Once I changed the ORACLE_HOME to /opt/app/oracle/product/9.2, the connection worked. Now I just have to remember that when I connect to an INSTANCE that is lower in version than my local INSTANCE, I will need to first set my ORACLE_HOME to the version I am connecting to. So the question now is, is there a way to check dynamically what version the remote INSTANCE is running? Is there a tool out there that would give me this information or will I have to create one of my own? Trying not to re-invent the wheel. :D Peter -Original Message- From: John D Groenveld [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 1:52 PM To: Loo, Peter # PHX Cc: DBI-Users Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: >It appears that OID configuration is working properly. I had used >tnsping command to see what method it was using to resolve the INSTANCE. > >$ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE tnsping and sqlplus are 64-bit in 10.2 for Solaris. I suspect you've stumbled upon a bug in Oracle's 32-bit libraries. John [EMAIL PROTECTED] 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: Using Oracle Internet Directory (OID) instead of TNS Names
In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: >It appears that OID configuration is working properly. I had used >tnsping command to see what method it was using to resolve the INSTANCE. > >$ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE tnsping and sqlplus are 64-bit in 10.2 for Solaris. I suspect you've stumbled upon a bug in Oracle's 32-bit libraries. John [EMAIL PROTECTED]
Re: Using Oracle Internet Directory (OID) instead of TNS Names
In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: >If appears that Perl was built with 32-bit. I don't understand what you >mean by OCI demo. Oracle ships a bunch of OCI demos for training. $ORACLE_HOME/rdbms/demo/ cdemo1 is very simple and if you can replicate the core dump with it, Oracle Support will be able to as well. John [EMAIL PROTECTED]
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi John, If appears that Perl was built with 32-bit. I don't understand what you mean by OCI demo. $ file /usr/bin/perl /usr/bin/perl: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped Peter -Original Message- From: John D Groenveld [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 12:57 PM To: Loo, Peter # PHX Cc: DBI-Users Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: > >$ pstack core >core 'core' of 13643: /usr/bin/perl ./testCon.pl > fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 I'd wager that if you build the OCI demo, cdemo1, you'll core in the same place, which will be what your DBA will need to file a TAR. By default, the demo's build 64-bit, if you're using the 32-bit client libraries with a 32-bit Perl, then you'll need to adjust the Makefile. John [EMAIL PROTECTED] 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: Using Oracle Internet Directory (OID) instead of TNS Names
In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: > >$ pstack core >core 'core' of 13643: /usr/bin/perl ./testCon.pl > fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 I'd wager that if you build the OCI demo, cdemo1, you'll core in the same place, which will be what your DBA will need to file a TAR. By default, the demo's build 64-bit, if you're using the 32-bit client libraries with a 32-bit Perl, then you'll need to adjust the Makefile. John [EMAIL PROTECTED]
RE: Using Oracle Internet Directory (OID) instead of TNS Names
$ pstack core core 'core' of 13643: /usr/bin/perl ./testCon.pl fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 fe6eb0ac ldap_open (ffbfa96c, 185, ffbfa96c, 0, 1, 0) + 24 fe70f634 nnflilc (0, 0, 38daf0, 0, ffbfab34, ffbfab28) + e68 fe70e000 nnflrlc (0, 2000, 1be, fee0aa50, 1, 0) + 1e4 fe71034c nnflobc (0, 1000, ffbfaaa8, feda3f2c, 0, 0) + 81c fe70d8b8 nnflcgc (0, fee0aa50, ffbfadfc, 303948, fee6fc64, 2) + 134 fe711c20 nnflrne (fee6fc64, ffbfd9b8, fee3b2bc, 0, 0, ffbface4) + 548 fe7c9904 nnfgrne (4, 1, 0, ffbfb588, 0, ffbfb58c) + 8e8 fe84c7a0 nlolgobj (0, ffbfd9b8, 16, ffbfb614, 16, 78fcd0) + 700 fe7c6ab0 nnfun2a (0, 38d688, 0, ffbfb814, ffbfb818, 1000) + 29c fe7c6614 nnfsn2a (fee6fc64, ffbfd9b8, ff, ffbfc888, ffbfb818, 1000) + 38 fe768438 niqname (0, 1, 0, fee0aa50, 1000, ffbfeaa0) + 76c fe6bd3dc kwfnran (2b4560, 4, ffbfeaa4, 1, 2fe1f8, 2fe1fc) + 13c fe63b52c kwfcinit (5000, fed95d88, 4, ffbfeaa4, ffbfeaa0, 2f4ff4) + c4 fe57ca20 kpuatch (0, 2e4c20, 2f568c, 0, 2f557c, 0) + 344 fe569310 OCIServerAttach (2f553c, 2f4ff4, 2b4560, 4, 0, ff) + 7c ff0cc6e8 ora_db_login6 (1dddcc, 2bb9e8, 2b4560, ff0ef1d8, 0, 1f7034) + cd4 ff0c5aa4 XS_DBD__Oracle__db__login (294a40, 1de1d0, 80803, 150400, 1556dc, 1f7034) + 21c 0008d090 Perl_pp_entersub (14c400, 150400, 0, 1de1bc, 1de1c8, 0) + 55c 00084f54 Perl_runops_standard (14e000, 15, 14d000, 188040, e4, 3a) + 30 0002c8a8 S_call_body (ffbfee70, 0, 7, 0, 0, ffbff220) + 5c 0002c310 Perl_call_sv (1f70c4, 1de1cc, 0, 1de1b8, 18eca0, 0) + 258 ff20d6b8 XS_DBI_dispatch (28b080, 200e60, 80803, 20cd14, 0, 2440a0) + 1810 0008d090 Perl_pp_entersub (14c400, 150400, 0, 1de1bc, 1de1c8, 0) + 55c 00084f54 Perl_runops_standard (14e000, 0, ffbff224, ffbff1a0, 14e000, 282308) + 30 0002bdbc S_run_body (1, 0, 14d8d8, 5b, ffbfffb8, 14dbcc) + 144 0002b9d8 perl_run (1504b8, fffc, 2, ffbff35c, 1, 2) + 8c 000285f0 main (2, ffbff35c, ffbff368, 14d464, 0, 0) + 98 000283f0 _start (0, 0, 0, 0, 0, 0) + 5c Peter -Original Message- From: John D Groenveld [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 12:39 PM To: Loo, Peter # PHX Cc: DBI-Users Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: >$ ./testCon.pl >Segmentation Fault(coredump) Lets see the output of pstack(1) for that core. You may have stumbled upon an Oracle bug in the client libraries. John [EMAIL PROTECTED] 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: Using Oracle Internet Directory (OID) instead of TNS Names
In message <[EMAIL PROTECTED] m>, "Loo, Peter # PHX" writes: >$ ./testCon.pl >Segmentation Fault(coredump) Lets see the output of pstack(1) for that core. You may have stumbled upon an Oracle bug in the client libraries. John [EMAIL PROTECTED]
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron,
Here is the sqlplus connection:
$ sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 16 10:58:23 2006
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
SQL>
Here is the debug output of the test connection program using Perl DBI.
$ cat testCon.pl
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect("dbi:Oracle:SID_NOT_IN_TNSNAMES", "MY_ID",
"MY_PASSWORD", { RaiseError => 1 });
$dbh->disconnect();
exit;
$ ./testCon.pl
Loading DB routines from perl5db.pl version 1.23
Editor support available.
Enter h or `h h' for help, or `man perldebug' for more help.
main::(./testCon.pl:5): my $dbh =
DBI->connect("dbi:Oracle:SID_NOT_IN_TNSNAMES", "MY_ID", "MY_PASSWORD", {
RaiseError => 1 });
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.pm:51
0):
510:my $class = shift;
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.pm:51
1):
511:my ($dsn, $user, $pass, $attr, $old_driver) = my @orig_args
= @_;
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.pm:51
2):
512:my $driver;
.
.
.
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.p
m:1162):
1162: $h = bless \%hash, $class; # ref to outer hash (for
application)
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.p
m:1165):
1165: DBI::_setup_handle($h, $imp_class, $parent, $imp_data);
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.p
m:1167):
1167: return $h unless wantarray;
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.p
m:1168):
1168: ($h, $i);
DB<1> s
DBD::Oracle::dr::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solar
is/DBD/Oracle.pm:216):
216:DBD::Oracle::db::_login($dbh, $dbname, $user, $auth,
$attr)
217:or return undef;
DB<1> s
s
s
s
THE PROGRAM JUST HANGS HERE, BUT IF I RUN IT WITHOUT DEBUG, I GET THE
FOLLOWING ERROR MESSAGE:
$ ./testCon.pl
Segmentation Fault(coredump)
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 5:34 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names
Does SQL*Plus do this correctly from the same machine you are running
the Perl scripts? It should work the same because DBD::Oracle uses the
OCI to perform it's actions. This means it still uses the O3LOGON
functionality.
Can you write a simple Perl script that will just connect and disconnect
from the database and then perform an strace on it and a SQL*Plus
session to that same database instance? This might tell you where
things are going wrong.
Also, what happens if you reverse the order of lookup(ldap then
tnsnames)? Does it work then? If so, I would post a SR with Oracle
support to clarify this issue. When/if you get this information, would
you mind posting it back to this group?
rr
-----Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 6:18 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron,
According to our *.ora files, everything appears to be set up correctly.
However, whenever Perl DBI attempts to connect to an INSTANCE that is
not defined in tnsnames.ora file, the Perl program is unable to
continue.
What we are hoping that Perl DBI would do for us is to perform somewhat
like sqlplus. When we issue the following command at shell prompt, even
if the INSTANCE name is not listed in tnsnames.ora file, sqlplus would
find the instance.
$ sqlplus [EMAIL PROTECTED]
someInstance does not exist in the tnsnames.ora file, but somehow
sqlplus still finds it.
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 2:27 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names
No. The list is a search order - tnsnames will be checked first, then
OID.
-----Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 3:06 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron,
We currently have the following configuration. I am assuming that in
order for Perl DBI to use OID, LDAP has to be the first in the list?
NAMES.DIRECTORY_PATH= (tnsnames, ldap)
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 1:28 PM
To: Loo, Peter #
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Does SQL*Plus do this correctly from the same machine you are running the Perl scripts? It should work the same because DBD::Oracle uses the OCI to perform it's actions. This means it still uses the O3LOGON functionality. Can you write a simple Perl script that will just connect and disconnect from the database and then perform an strace on it and a SQL*Plus session to that same database instance? This might tell you where things are going wrong. Also, what happens if you reverse the order of lookup(ldap then tnsnames)? Does it work then? If so, I would post a SR with Oracle support to clarify this issue. When/if you get this information, would you mind posting it back to this group? rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 6:18 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, According to our *.ora files, everything appears to be set up correctly. However, whenever Perl DBI attempts to connect to an INSTANCE that is not defined in tnsnames.ora file, the Perl program is unable to continue. What we are hoping that Perl DBI would do for us is to perform somewhat like sqlplus. When we issue the following command at shell prompt, even if the INSTANCE name is not listed in tnsnames.ora file, sqlplus would find the instance. $ sqlplus [EMAIL PROTECTED] someInstance does not exist in the tnsnames.ora file, but somehow sqlplus still finds it. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 2:27 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names No. The list is a search order - tnsnames will be checked first, then OID. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 3:06 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, We currently have the following configuration. I am assuming that in order for Perl DBI to use OID, LDAP has to be the first in the list? NAMES.DIRECTORY_PATH= (tnsnames, ldap) Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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, disc
RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron, According to our *.ora files, everything appears to be set up correctly. However, whenever Perl DBI attempts to connect to an INSTANCE that is not defined in tnsnames.ora file, the Perl program is unable to continue. What we are hoping that Perl DBI would do for us is to perform somewhat like sqlplus. When we issue the following command at shell prompt, even if the INSTANCE name is not listed in tnsnames.ora file, sqlplus would find the instance. $ sqlplus [EMAIL PROTECTED] someInstance does not exist in the tnsnames.ora file, but somehow sqlplus still finds it. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 2:27 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names No. The list is a search order - tnsnames will be checked first, then OID. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 3:06 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, We currently have the following configuration. I am assuming that in order for Perl DBI to use OID, LDAP has to be the first in the list? NAMES.DIRECTORY_PATH= (tnsnames, ldap) Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
No. The list is a search order - tnsnames will be checked first, then OID. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 3:06 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, We currently have the following configuration. I am assuming that in order for Perl DBI to use OID, LDAP has to be the first in the list? NAMES.DIRECTORY_PATH= (tnsnames, ldap) Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron, We currently have the following configuration. I am assuming that in order for Perl DBI to use OID, LDAP has to be the first in the list? NAMES.DIRECTORY_PATH= (tnsnames, ldap) Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
Peter, You're welcome. Not planning a trip to Phoenix soon, but I'll keep that in mind. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 2:32 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Thanks Ron. You have been most helpful. Look me up when you are in Phoenix. I will buy you lunch. :D Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
Thanks Ron. You have been most helpful. Look me up when you are in Phoenix. I will buy you lunch. :D Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = "dc=xx,dc=yy,dc=com" Directory_server=(server.domain.com:non-ssl_port:ssl_port) Directory_server_type=oid You can read about this in the OID/LDAP Oracle manuals. Giddy up. rr -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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. 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: Using Oracle Internet Directory (OID) instead of TNS Names
If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:40 AM To: DBI-Users Subject: Using Oracle Internet Directory (OID) instead of TNS Names Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter 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.
