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.