Error while trying to retrieve text for error ORA-01019

Question

I have a question related to oracle. I have a machine which earlier had Oracle client installed on it. I was able to connect to my oracle server using the client.

Now I recently installed oracle 11g DB on the same machine. Now I have one client and Oracle 11g DB installed. But some how I am not able to connect to oracle servers anymore. This seems a bit problem because I am getting two oracle homes and stuff in path and registry entry.

The error that I am getting while connecting is [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019

Note: I had a similar problem once but once I uninstalled the oracle DB server and removed the ORACLE_HOME entries things started working fine.

Could you please help me fix this problem. Do let me know if you need more information

Answer 1

WHEN ORA-01019 ERROR OCCURS

1. Check with TNSPING , if not responding then add Service Name entry in tns.ora file.
2. Check firewall, if enabled then disable it.
3. Add Env. variable ORACLE_HOME to the Path of oracle client directory up to 'c:\oracle...\client1', this solution will definitely work.

Answer 2

Well,

Just worked it out. While having both installations we have two ORACLE_HOME directories and both have SQAORA32.dll files. While looking up for ORACLE_HOMe my app was getting confused..I just removed the Client oracle home entry as oracle client is by default present in oracle DB Now its working...Thanks!!