Error trying to get text for error ORA-01019

Question

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

Now I recently installed Oracle 11g DB on the same computer. Now I have one client and Oracle 11g DB installed. But some, like I can no longer connect to oracle servers. This seems a bit of a problem because I get two oracle houses and stuff in transit and registry entries.

The error I get when connecting, [Microsoft] [ODBC driver for Oracle] [Oracle] Error while trying to get text for error ORA-01019

Note. I had a similar problem, but once I uninstalled the Oracle oracle server and the deleted ORACLE_HOME records started to work fine.

Could you help me solve this problem. Let me know if you need more information.

Answer 1

Well,

Just worked. Having both installations, we have two ORACLE_HOME directories, and both have SQAORA32.dll files. When searching for ORACLE_HOMe, my application got confused. I just deleted the client oracle home entry, since the oracle client is present in oracle DB by default. Now it works ... Thanks.

Answer 2

Correct the path ORACLE_HOME.

There can be two oracle clients in a system. A.

I had the same problem, so my ORACLE_HOME was pointed to an oracle installation that didn't have a tns.ora file.

Change ORACLE_HOME in the Oracle directory where tns.ora solved it.

tns.ora is located in client2 \ network \ admin \

Answer 3

I have the same problem. My solution was to remove one of the oracle path in the environment variable. I also changed inventory.xml and pointed to the home version of oracle, which is in my environment path variable.

Answer 4

You can link to the link.

Install the 64-bit ODAC driver using CMD after installing the 32-bit ODAC:

• Go to the ODAC bit folder, where the install.bat file is located using CMD.

• Type install.bat all c:/oracle odac and press Enter .

  The installation file will be located in the c: / oracle folder.

When installing the Oracle client 11g 32 and 64 bit, you need to change the oracle base path: "c: / oracle"