Home » RDBMS Server » Server Administration » TNS-03502: Message 3502 not found (11.2.0)
TNS-03502: Message 3502 not found [message #644735] Mon, 16 November 2015 06:29 Go to next message
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.
Re: TNS-03502: Message 3502 not found [message #644736 is a reply to message #644735] Mon, 16 November 2015 06:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10680
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.


Re: TNS-03502: Message 3502 not found [message #644738 is a reply to message #644736] Mon, 16 November 2015 06:36 Go to previous messageGo to next message
John Watson
Messages: 7219
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
Re: TNS-03502: Message 3502 not found [message #644740 is a reply to message #644738] Mon, 16 November 2015 07:42 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10680
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.
Re: TNS-03502: Message 3502 not found [message #644742 is a reply to message #644741] Mon, 16 November 2015 08:12 Go to previous messageGo to next message
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>
Re: TNS-03502: Message 3502 not found [message #644744 is a reply to message #644742] Mon, 16 November 2015 08:24 Go to previous messageGo to next message
John Watson
Messages: 7219
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.

Re: TNS-03502: Message 3502 not found [message #644746 is a reply to message #644744] Mon, 16 November 2015 08:50 Go to previous messageGo to next message
BlackSwan
Messages: 25796
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.
Re: TNS-03502: Message 3502 not found [message #644749 is a reply to message #644744] Mon, 16 November 2015 08:51 Go to previous messageGo to next message
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 ?
Re: TNS-03502: Message 3502 not found [message #644750 is a reply to message #644749] Mon, 16 November 2015 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 25796
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.
Re: TNS-03502: Message 3502 not found [message #644751 is a reply to message #644750] Mon, 16 November 2015 09:01 Go to previous messageGo to next message
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)
Re: TNS-03502: Message 3502 not found [message #644752 is a reply to message #644751] Mon, 16 November 2015 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
so, is your problem solved now?
Re: TNS-03502: Message 3502 not found [message #644753 is a reply to message #644752] Mon, 16 November 2015 09:08 Go to previous message
John Watson
Messages: 7219
Registered: January 2010
Location: Global Village
Senior Member
and have you read the instructions I pointed you towards for using [code] tags?
Previous Topic: Privileges issue while create database through oracle user
Next Topic: Oracle 10g upgrade to 11g with asm non rac
Goto Forum:
  


Current Time: Fri Jan 19 18:15:52 CST 2018

Total time taken to generate the page: 0.02022 seconds