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
This question is related to
oracle11g
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.
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)
You can refer to this link.
Install ODAC 64 bit driver using CMD after install ODAC 32 bit:
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”
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\
Source: Stackoverflow.com