How to Resolve Message 3511 not found

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\bin

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.

Solution

That’s correct, we shall set ORACLE_HOME as a registry parameter or environment variable in Windows 7. For example,

ORACLE_HOME=C:\oracle

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

Leave a Reply

Your email address will not be published. Required fields are marked *