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
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
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]
: 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
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
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
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,
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
=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
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.
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
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
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
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
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
, 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
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
-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
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
19 matches
Mail list logo