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.
Path=C:\oracle\binThen, 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=TNSIt 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.
Solution
That's correct, we shall set ORACLE_HOME as a registry parameter or environment variable in Windows 7. For example,
ORACLE_HOME=C:\oracleNow, my Oracle Client is working fine.
For more troubleshooting about tinsping Message 3511 not found, you may refer to my post:
TNSPING Errors Collections
Some of my files went ming from the mesg folder under network folder within oracle. Restored those and the issue was resolved
Setting oracle_home at first didnt help
That’s great.