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.

Reply via email to