OraFAQ Forum: Server Administration » TNS-03502: Message 3502 not found

Home » RDBMS Server » Server Administration » TNS-03502: Message 3502 not found (11.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-03502: Message 3502 not found [message #644735]

Mon, 16 November 2015 06:29

pkirklewski
Messages: 5
Registered: November 2015
Location: London

Junior Member

Hi there,

How to get rid of this problem please ?

1. In the registry, I can see that there is several clients under HKEY_LOCALMACHINE/SOFTWARE/ORACLE/KEY_Oracle
...
SOFTWARE>
ORACLE >
KEY_OraClient11g_home1
KEY_OraClient11g_home2
KEY_OraClient11g_home3

2.Path points to: D:\Oracle\product\11.2.0\client_4\bin
3. In regedit KEY_OraClient11g_home3 OLEDB points to D:\Oracle\product\11.2.0\client_4\oledb\mesg
4. In regedit KEY_OraClient11g_home3 OLEDB points to D:\Oracle\product\11.2.0\client_4

When i open the CMD window and I run tnsping command, I get :

C:\Users\MyUser>tnsping
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 12:08:08
Copyright (c) 1997, 2010, Oracle. All rights reserved.
TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility=TNS

I need to ping a tns name which is stored in a file : D:\Oracle\product\11.2.0\client_4\network\admin\tnsnames.ora in order to make sure everything works fine and the system uses the correct file / client etc.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644736 is a reply to message #644735]

Mon, 16 November 2015 06:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

set your ORACLE_HOME=location of Oracle Binaries
set your TNS_ADMIN=location of tnsnames.ora file
set your PATH=ORACLE_HOME/bin;TNS_ADMIN

The syntax I have used to set environment variables could be wrong.
Just use the appropriate format.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644738 is a reply to message #644736]

Mon, 16 November 2015 06:36

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

It looks as though you have tried to install the 11.x client three times, and as a result you have messed up your default command shell environment. Did you try to delete anything? I hope not.

Try this

set ORACLE_HOME=D:\Oracle\product\11.2.0\client_4
set PATH=%ORACLE_HOME%\bin;%PATH%
where tnsping
tnsping

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644740 is a reply to message #644738]

Mon, 16 November 2015 07:42

pkirklewski
Messages: 5
Registered: November 2015
Location: London

Junior Member

This was actually already setup, I've just forgot to mention it.
But please take a look and let me know, maybe I've missed smething ?

C:\Users\MyUser>echo %PATH%
C:\Program Files (x86)\Common Files\Microsoft BizTalk Adapters for Enterprise  Applications\Bin\;D:\Oracle\product\11.2.0\client_4\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\W indowsPowerShell\v1.0\;D:\Program Files (x86)\Microsoft BizTalk Server 2013 R2\;D:\Progra
m Files (x86)\Microsoft BizTalk Server 2013 R2\Bins32;D:\Program Files (x86)\Microsoft BizTalk Server 2013 R2\Bins64;D:\Program Files\Microsoft SQL Server\110\DTS\Binn\;D:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;D:\Program Files\Microsoft SQL Server\110\Tools\Binn\;D:\Program Files
(x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;D:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;D:\UnxUtils\usr\local\wbin;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86
)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\

C:\Users\MyUser>echo %ORACLE_HOME%
D:\Oracle\product\11.2.0\client_4

C:\Users\MyUser>where tnsping
D:\Oracle\product\11.2.0\client_4\bin\tnsping.exe

C:\Users\MyUser>echo %TNS_ADMIN%
D:\Oracle\product\11.2.0\client_4\network\admin

C:\Users\MyUser>echo %ORACLE_BASE%
D:\Oracle\

C:\Users\MyUser>

[Updated on: Mon, 16 November 2015 07:53] by Moderator

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644741 is a reply to message #644740]

Mon, 16 November 2015 08:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I would explicitly call ORACLE_HOME, TNS_ADMIN variables in PATH.
Just like John has mentioned.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644742 is a reply to message #644741]

Mon, 16 November 2015 08:12

pkirklewski
Messages: 5
Registered: November 2015
Location: London

Junior Member

C:\Users\MyUser>set ORACLE_HOME=D:\Oracle\product\11.2.0\client_4

C:\Users\MyUser>set PATH=%ORACLE_HOME%\bin;%PATH%

C:\Users\MyUser>where tnsping
D:\Oracle\product\11.2.0\client_4\bin\tnsping.exe

C:\Users\MyUser>tnsping

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 14:10:05

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

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

C:\Users\MyUser>

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644744 is a reply to message #644742]

Mon, 16 November 2015 08:24

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Please use [code] tags in future. Also you might want to consider saying "thankyou for your time" Smile

It looks as though you have damaged your installation. The fact that the registry sees three Oracle homes but only one appears to exist is not good. Perhaps someone tried to remove the homes manually, rather than using the appropriate tools, and messed up. I would remove all three homes, tidy up the registry, tidy up your environment, and install again. That will take only half an hour max, and probably be much quicker than trying to sort out what you have now.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644746 is a reply to message #644744]

Mon, 16 November 2015 08:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

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

above occurs when ORACLE_HOME is incorrect.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644749 is a reply to message #644744]

Mon, 16 November 2015 08:51

pkirklewski
Messages: 5
Registered: November 2015
Location: London

Junior Member

Thank you for your time mate.

I've discovered something by using process monitor:

tnsping.exe is trying to CreateFile in D:\Oracle\product\11.2.0\client_4\network\mesg\tnsus.msb and Result says: NAME NOT FOUND

The location (D:\Oracle\product\11.2.0\client_4\network\mesg\) contains only one file nlus.msb

There is however another location that contains the tnsus.msb

Should I copy the file manually ?

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644750 is a reply to message #644749]

Mon, 16 November 2015 08:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>There is however another location that contains the tnsus.msb
>Should I copy the file manually ?
Or change ORACLE_HOME to point to "another location"
I have no idea where on your PC a valid Oracle installation exists & I suspect that neither do you.

Report message to a moderator

Re: TNS-03502: Message 3502 not found [message #644751 is a reply to message #644750]

Mon, 16 November 2015 09:01

pkirklewski
Messages: 5
Registered: November 2015
Location: London

Junior Member

Correct.
I inherited the server and it looks like whoever installed the product didn't know what are they doing.

I copied the file and now tnsping gives me:

C:\Users\MyUser>tnsping MyDATABASE 1

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 14:55:59

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.15.32.6(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MyDATABASE)(UR=A)))
OK (70 msec)

Report message to a moderator