Message 3511 not found
Recently, I upgraded my PC from Windows XP to Windows 7 at my working place. For reusing installed Oracle Client 9.2.0, a pretty old Java application, I took several steps to recover it, but I got Message 3511 not found eventually.
First, I set an environment variable Path for Oracle Client software in regedit.
Then, I tried to test the response of databases by tnsping.
C:\Users\Ed> tnsping orcl
Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS
It seemed that it did find the right path to use tnsping, but it failed to locate the message file which is tnsnames.ora in this case.
If this error happened on the database server, I think the first hint in every DBA's mind would be:
ORACLE_HOME might point to a wrong path.
That's correct, we shall set ORACLE_HOME as a registry parameter or environment variable in Windows 7. For example,
Now, my Oracle Client is working fine.
For more troubleshooting about tinsping Message 3511 not found, you may refer to my post:
TNSPING Errors Collections