Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have installed Oracle Client 11g R2 Win64 on Windows 7 x64. However, running tnsping (without parameters) yields the following output:

C:\Users\stefan.moebius>tnsping

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-APR-2011 17:06:17

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility=TNS

What's wrong?

I tried settings ORACLE_HOME, as that's mentioned around the net, but that didn't help. Looking at what tnsping is doing using ProcMon shows that it actually does find the file

C:\develop\oracle\product\11.2.0\client_1\network\mesg\nlus.msb
share|improve this question

3 Answers 3

up vote 2 down vote accepted

I had a similar issue, although nlus.msb did exist under %ORACLE_HOME%\network\mesg\, there were seven more msg files missing. Apparently this was due to an incomplete client installation, and I had copied these file across from another machine with the same version/configuration and got rid of the issue.

TNSPING

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-FEB-2
012 10:00:23

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
 3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 n
ot found; No message file for product=NETWORK, facility=TNSMessage 3509 not found; No message file for product=NETWORK, facility=TNS
share|improve this answer

I do know the TNS-03502 message is telling you that tnsping without arguments is not legal. Do you get the same message ("message nnnn not found...") if you supply a valid TNS alias to the command?

As for the message error, the only thing I can think of is a permission issue with the user running the tnsping command and the Oracle message files. Setting ORACLE_HOME on windows boxes is unnecessary and often causes problems - that value should be set up in the registry when you installed it.

share|improve this answer
    
Yes, the same bogus thing happens with a complete tnsping command. –  stmoebius Apr 26 '11 at 17:48

Find ORACLE_HOME in your windows registry. Looks like below: HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDb11g_home1

make sure the ORACLE_HOME is pointing to the correct home. Especially when you have installed Oracle Client/Servers more than 1x.

Works for me.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.