------_=_NextPart_001_01C6C091.D5C9A75F
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hi All,
=20
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?
=20
Thanks.
=20
Peter
------_=_NextPart_001_01C6C091.D5C9A75F--
That's right. You will need:
1. A sqlnet.ora file which designates the search method:
names.directory_path=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]=20
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
Thanks Ron. You have been most helpful. Look me up when you are in
Phoenix. I will buy you lunch. :D=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
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:Peter.Loo@source.wolterskluwer.com]=20
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=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
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=3D (tnsnames, ldap)=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
No. The list is a search order - tnsnames will be checked first, then
OID.
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]=20
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=3D (tnsnames, ldap)=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
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. =20
$ sqlplus userid@someInstance
someInstance does not exist in the tnsnames.ora file, but somehow
sqlplus still finds it.
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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:Peter.Loo@source.wolterskluwer.com]
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=3D (tnsnames, ldap)=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
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:Peter.Loo@source.wolterskluwer.com]=20
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. =20
$ sqlplus userid@someInstance
someInstance does not exist in the tnsnames.ora file, but somehow
sqlplus still finds it.
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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:Peter.Loo@source.wolterskluwer.com]
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=3D (tnsnames, ldap)=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
Hi Ron,
Here is the sqlplus connection:
$ sqlplus MY_ID@SID_NOT_IN_TNSNAMES
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:=20
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
SQL>=20
Here is the debug output of the test connection program using Perl DBI.
$ cat testCon.pl
#!/usr/bin/perl -w
use DBI;
my $dbh =3D DBI->connect("dbi:Oracle:SID_NOT_IN_TNSNAMES", "MY_ID",
"MY_PASSWORD", { RaiseError =3D> 1 });
$dbh->disconnect();
exit;
$ ./testCon.pl =20
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 =3D
DBI->connect("dbi:Oracle:SID_NOT_IN_TNSNAMES", "MY_ID", "MY_PASSWORD", {
RaiseError =3D> 1 });
=20
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solar is/DBI.pm:51
0):
510: my $class =3D shift;
=20
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solar is/DBI.pm:51
1):
511: my ($dsn, $user, $pass, $attr, $old_driver) =3D my =
@orig_args
=3D @_;
=20
DB<1> s
DBI::connect(/usr/local/lib/perl5/site_perl/5.8.3/sun4-solar is/DBI.pm:51
2):
512: my $driver;
..
..
..
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-s olaris/DBI.p
m:1162):
1162: $h =3D bless \%hash, $class; # ref to outer hash =
(for
application)
=20
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-s olaris/DBI.p
m:1165):
1165: DBI::_setup_handle($h, $imp_class, $parent, $imp_data);
=20
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-s olaris/DBI.p
m:1167):
1167: return $h unless wantarray;
=20
DB<1> s
DBI::_new_handle(/usr/local/lib/perl5/site_perl/5.8.3/sun4-s olaris/DBI.p
m:1168):
1168: ($h, $i);
=20
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;
=20
DB<1> s
s
s
s=20
THE PROGRAM JUST HANGS HERE, BUT IF I RUN IT WITHOUT DEBUG, I GET THE
FOLLOWING ERROR MESSAGE:
$ ./testCon.pl =20
Segmentation Fault(coredump)
Peter =20
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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:Peter.Loo@source.wolterskluwer.com]
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. =20
$ sqlplus userid@someInstance
someInstance does not exist in the tnsnames.ora file, but somehow
sqlplus still finds it.
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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:Peter.Loo@source.wolterskluwer.com]
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=3D (tnsnames, ldap)=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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=3D(LDAP)
2. A ldap.ora file that describes the location of your OID instance:
Default_admin_context =3D "dc=3Dxx,dc=3Dyy,dc=3Dcom"
Directory_server=3D(server.domain.com:non-ssl_port:ssl_port)
Directory_server_type=3Doid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]
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.=20
=20
Peter
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
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:Peter.Loo@source.wolterskluwer.com]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names
Hi All,
=20
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?
=20
Thanks.
=20
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.
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.
In message <8E3D502A002DA04FADBDED4CB4D94D3A01CEC8A3@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
$ 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, ff0000) + 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, 150000, 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, fffffffc, 2, ffbff35c, 1, 2) + 8c
000285f0 main (2, ffbff35c, ffbff368, 14d464, 0, 0) + 98
000283f0 _start (0, 0, 0, 0, 0, 0) + 5c
=20
Peter
-----Original Message-----
From: John D Groenveld [mailto:jdg117@stevens.arl.psu.edu]=20
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=20
In message
<8E3D502A002DA04FADBDED4CB4D94D3A01CEC8A3@phxmail02.phx.ndchealth.co
m>, "Loo, Peter # PHX" writes:
>$ ./testCon.pl =20
>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
groenveld@acm.org
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.
In message <8E3D502A002DA04FADBDED4CB4D94D3A01CEC9C7@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
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=20
=20
Peter
-----Original Message-----
From: John D Groenveld [mailto:jdg117@stevens.arl.psu.edu]=20
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=20
In message
<8E3D502A002DA04FADBDED4CB4D94D3A01CEC9C7@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
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.
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=3D(ADDRESS_LIST=3D(ADDRESS=3D(COMMUNITY=3DTCPCO M.OUT_DOMAIN.=
com)(PR
OTOCOL=3DTCP)(Host=3Dhost_name)(Port=3D1521)))(SDU=3D32768)( TDU=3D32768)(=
CONNECT_D
ATA=3D(SID=3DINSTANCE_NOT_IN_TNSNAMES_FILE)))
OK (10 msec)
=20
Peter
-----Original Message-----
From: John D Groenveld [mailto:jdg117@stevens.arl.psu.edu]=20
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=20
In message
<8E3D502A002DA04FADBDED4CB4D94D3A01CEC9C7@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
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.
In message <8E3D502A002DA04FADBDED4CB4D94D3A01CECA3F@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
In message <8E3D502A002DA04FADBDED4CB4D94D3A01CECA4E@phxmail02.phx.ndchealth.co
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
groenveld@acm.org
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
=20
Peter
-----Original Message-----
From: John D Groenveld [mailto:jdg117@stevens.arl.psu.edu]=20
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=20
In message
<8E3D502A002DA04FADBDED4CB4D94D3A01CECA4E@phxmail02.phx.ndchealth.co
m>, "Loo, Peter # PHX" writes:
>It appears that OID configuration is working properly. I had used=20
>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.=20
I suspect you've stumbled upon a bug in Oracle's 32-bit libraries.
John
groenveld@acm.org
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.
On 8/16/06, Loo, Peter # PHX
> 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
------------------------------------------------------------ --------------------------------------------------
Jeffrey,
The problem is that I need to know the version of the INSTANCE before
logging on to it.
=20
Peter
-----Original Message-----
From: Jeffrey Seger [mailto:jseger@gmail.com]=20
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
> Hi John,
>
> It turns out that the INSTANCE that I am trying to connect to is a=20
> 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,=20
> 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=20
> ORACLE_HOME to the version I am connecting to. So the question now=20
> is, is there a way to check dynamically what version the remote=20
> INSTANCE is running? Is there a tool out there that would give me=20
> this information or will I have to create one of my own? Trying not=20
> 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.
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
cj10@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679