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: 10615
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: 10615
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: 58643
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 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
Previous Topic: ORA-12154 Error
Next Topic: ORA-12569: TNS:packet checksum failure
Goto Forum:
  


Current Time: Fri Aug 01 11:15:36 CDT 2014

Total time taken to generate the page: 0.14461 seconds