Home » RDBMS Server » Networking and Gateways » TNSPING - Message 3509 not found; No message file for product=network, facility=
TNSPING - Message 3509 not found; No message file for product=network, facility= [message #67595] Sun, 07 November 2004 23:10 Go to next message
Shankar Lakkaraju
Messages: 7
Registered: May 2002
Junior Member
Hi Experts,

    I'm not able to connect to my Oracle database! Getting the following error, while using TNSPING utility ...

bash-2.05$ tnsping bnsnqa04_ITL5146.world

TNS Ping Utility for Solaris: Version 9.2.0.5.0 - Production on 08-NOV-2004 14:2
7:17

Copyright (c) 1997 Oracle Corporation.  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=TNSAttempting to
contact (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= bnsnqa04.i2.com)(Port= 1
521)) (CONNECT_DATA = (SID = ITL5146)))
Message 3509 not found; No message file for product=network, facility=TNS
bash-2.05$

What could be problem ? I have properly populated the tnsnames.ora file.  With the same tnsnames.ora file, on a different PC, I'm able to connect to the DB.

Thanks in Advance,

Best Rgds,

Shankar Lakkaraju

 
Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #67599 is a reply to message #67595] Tue, 09 November 2004 07:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10670
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set your environment.
set your ORACLE_HOME,ORACLE_SID and add those to PATH
Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #67600 is a reply to message #67599] Tue, 09 November 2004 18:53 Go to previous messageGo to next message
Shankar Lakkaraju
Messages: 7
Registered: May 2002
Junior Member
Mahesh,

Thanks for your reply. I have set ORACLE_HOME
and added to PATH. I have also made TNS_ADMIN
pointing to directory, where my tnsnames.ora
file is residing.

I would have to access multiple DBs from the
same Solaris box. Also, I have only the Oracle client
installed on my Solaris box. In that case, would setting ORACLE_SID to a particular be of any help ?

Once again thanks for your reply.

Diwali Greetings!

Thanks,

Shankar Lakkaraju
Shankar.Lakkaraju@tcs.com
Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #67601 is a reply to message #67600] Wed, 10 November 2004 02:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10670
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> ORACLE_SID to a particular be of any help ?
No.
ORACLE_SID is something to be set in SERVER side to access individiual the particular instance( without using a connect string).
for the client sites, You no need to set them.
Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #437802 is a reply to message #67601] Wed, 06 January 2010 01:53 Go to previous messageGo to next message
sachinonnet
Messages: 2
Registered: June 2008
Location: INDIA
Junior Member

Hi ,

Getting similar error message on oracle client machine.
after setting ORACLE_HOME and SID still getting error.

client was missing tnsping.exe i copied it from server.

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
3512 not found; No message file for product=NETWORK, facility=TNSAttempting to
contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = lime1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = sdb)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS

regards,
Sachin

[Updated on: Wed, 06 January 2010 01:54]

Report message to a moderator

Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #437804 is a reply to message #437802] Wed, 06 January 2010 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 63516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
client was missing tnsping.exe i copied it from server.

Very bad idea, install it correctly, the program is not self-contain it requires libraries.
Also are you sure you have the exact same version number?

Regards
Michel
Re: TNSPING - Message 3509 not found; No message file for product=network, facil [message #437805 is a reply to message #437804] Wed, 06 January 2010 02:05 Go to previous messageGo to next message
sachinonnet
Messages: 2
Registered: June 2008
Location: INDIA
Junior Member

Hi,

yes, it was bad to copy tnsping.

i guess it was oracle lite 10.2.2, it was installed by admin, let me confirm with him


thanks
Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653875 is a reply to message #67595] Thu, 21 July 2016 02:09 Go to previous messageGo to next message
Harmit.Jikadra
Messages: 2
Registered: July 2016
Junior Member
when try to TNSPing i got this error.

try to connect ORCL11G Database in LAN.
in which PC-A contain Database and PC-B(IN LAN) Try to TNS PING
i had set All of Above setp properly.

i had only install ORCL Client in PC-B

Please Help me.
Re: Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653879 is a reply to message #653875] Thu, 21 July 2016 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 63516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you try what has been posted above:
* ORACLE_HOME set?
* ORACLE_HOME and tnsping exact same version, this is not a copy of a tnsping from an other place?
Copy and paste the command and return you have like:
C:\>tnsping mikb2

TNS Ping Utility for 32-bit Windows: Version 11.2.0.4.0 - Production on 21-JUIL.-2016 09:40:42

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

Used parameter files:
E:\oracle\ora11204\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = ...
OK (80 msec)
You can also try, if you are on Windows, to ping using McTnsping which requires no Oracle client.

[Updated on: Thu, 21 July 2016 02:43]

Report message to a moderator

Re: Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653893 is a reply to message #653875] Thu, 21 July 2016 07:38 Go to previous messageGo to next message
EdStevens
Messages: 647
Registered: September 2013
Senior Member
Harmit.Jikadra wrote on Thu, 21 July 2016 02:09
when try to TNSPing i got this error.

try to connect ORCL11G Database in LAN.
in which PC-A contain Database and PC-B(IN LAN) Try to TNS PING
i had set All of Above setp properly.

i had only install ORCL Client in PC-B

Please Help me.


Which error? You just responded to a thread that was over 6 years old, and presented no diagnostics, no evidence from your own issue. You should start your own thread and present all the facts specific to your own issue.

"3512 not found" inevitably means that ORACLE_HOME was not properly set, so the process was unable to find the file that provides actual message text in the appropriate language.
Re: Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653927 is a reply to message #653893] Fri, 22 July 2016 04:16 Go to previous messageGo to next message
Harmit.Jikadra
Messages: 2
Registered: July 2016
Junior Member
ok Thanks.

How can i set ORACLE_HOME ?
Please give me proper setup.
Re: Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653930 is a reply to message #653927] Fri, 22 July 2016 06:31 Go to previous messageGo to next message
EdStevens
Messages: 647
Registered: September 2013
Senior Member
Harmit.Jikadra wrote on Fri, 22 July 2016 04:16
ok Thanks.

How can i set ORACLE_HOME ?
Please give me proper setup.


Can you give the information that has been requested of you? Information specific to YOUR error and YOUR setup?
What OS is you Oracle client software installed on?
What is location of the file 'tnsnames.ora'?
What is the content of the file 'tnsnames.ora'?
What is the full, complete, and exact command that produces the error?
What is the full, complete, and exact error returned by that command?

Do not tell us your interpretation of the answers to the above questions. SHOW us the results by the use of copy and paste. And yes, you can copy text out of a Windows command prompt. That will be much easier to read here than a screen shot. Especially if you enclose it in the code tags.
Re: Message 3511 not found; No message file for product=network, facility=TNSMessage [message #653937 is a reply to message #653930] Fri, 22 July 2016 09:43 Go to previous message
Michel Cadot
Messages: 63516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
And yes, you can copy text out of a Windows command prompt. That will be much easier to read here than a screen shot. Especially if you enclose it in the code tags.


As I showed it above. Wink

Previous Topic: Need help regarding oracle database gateway for ODBC
Next Topic: SCAN Listener issue while connecting to two node RAC
Goto Forum:
  


Current Time: Sat Jul 30 00:33:50 CDT 2016

Total time taken to generate the page: 0.08686 seconds