Error while trying to retrieve text for error ORA-01019
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\
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!!
WHEN ORA-01019 ERROR OCCURS
- Check with TNSPING , if not responding then add Service Name entry in tns.ora file.
- Check firewall, if enabled then disable it.
- Add Env. variable ORACLE_HOME to the Path of oracle client directory up to 'c:\oracle...\client1', this solution will definitely work.