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

User · Answer

In my case  I just needed to install oracle 10g client on the server  becase there there was the 11g version   Ps  I don t needed unistall nothing  I just install the 10g version and updated the tnsnames file  C  oracle product 10 2 0 client 1 NETWORK ADMIN

User · Answer

You can refer to this link   Install ODAC 64 bit driver using CMD after install ODAC 32 bit    Go to ODAC  bit folder where install bat file is located using CMD  Type install bat all c  oracle odac command and press Enter   Installation file will be located at    c  oracle    folder    When installing Oracle 11g client 32 and 64 bit  you must change oracle base path     c  oracle

User · Answer

I have the same issue  My solution was delete one of the oracle path in environment variable  I also changed the inventory xml and point to the oracle home version which is in my environment path variable

User · Answer

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

User · Answer

Correct the ORACLE HOME path    There could be two oracle clients in the system   I had the same issue  the reason being my ORACLE HOME was pointed to the oracle installation which was not having the tns ora file   Changing the ORACLE HOME to the Oracle directory which is having the tns ora solved it   tns ora lies in client2 network admin

[oracle11g] Error while trying to retrieve text for error ORA-01019

Examples related to oracle11g