OraFAQ Forum: Networking and Gateways » TNSPING - Message 3509 not found; No message file for product=network, facility=

Home » RDBMS Server » Networking and Gateways » TNSPING - Message 3509 not found; No message file for product=network, facility=

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

TNSPING - Message 3509 not found; No message file for product=network, facility= [message #67595]

Sun, 07 November 2004 23:10

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

�

Report message to a moderator

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

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

Senior Member
Account Moderator

set your environment.
set your ORACLE_HOME,ORACLE_SID and add those to PATH

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

sachinonnet
Messages: 5
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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

sachinonnet
Messages: 5
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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

EdStevens
Messages: 1376
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.

Report message to a moderator

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

Harmit.Jikadra
Messages: 2
Registered: July 2016

Junior Member

ok Thanks.

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

Report message to a moderator

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

EdStevens
Messages: 1376
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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Need help regarding oracle database gateway for ODBC
Next Topic:	TNS-12541 TNS no listener issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:11:57 CST 2024