tnsping error

[khayr]

Can someone explain why this TNS-03505 error is occuring and steps to resolve it? Thanks.

# TNSNAMES.ORA Network Configuration File: /opt/oracle/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.5.161)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCH.WORLD)
)
)


bash-2.03$ /usr/sbin/ping 10.13.5.161
10.13.5.161 is alive

bash-2.03$ ./tnsping ORCH

TNS Ping Utility for Solaris: Version 8.1.7.0.0 - Production on 22-MAY-2003 14:38:56

(c) Copyright 1997 Oracle Corporation. All rights reserved.

TNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
bash-2.03$


*** ON Host 10.13.5.161 where Oracle DB is located ***

bash-2.03$ ps -aef | grep ora
oracle 304 303 0 12:24:26 pts/2 0:00 -sh
oracle 310 304 0 12:24:28 pts/2 0:00 bash
oracle 341 1 0 12:54:52 ? 0:06 oracleORCH (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 339 1 0 12:54:52 ? 0:00 oracleORCH (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 330 1 0 12:25:30 ? 0:00 /opt/oracle/bin/tnslsnr LISTENER -inherit
oracle 316 1 0 12:25:00 ? 0:00 ora_pmon_ORCH
oracle 318 1 0 12:25:00 ? 0:00 ora_dbw0_ORCH
oracle 320 1 0 12:25:00 ? 0:00 ora_lgwr_ORCH
oracle 322 1 0 12:25:00 ? 0:01 ora_ckpt_ORCH
oracle 324 1 0 12:25:00 ? 0:00 ora_smon_ORCH
oracle 326 1 0 12:25:00 ? 0:00 ora_recRCH
oracle 361 310 0 14:43:31 pts/2 0:00 grep ora

 

[Turkbear]

HI,
The main problem is that your environment does not have ORACLE_HOME set ( That is why the message file coiuld not be found) - The message it is trying to show you is ( From Metalink):

Problem Description:  ====================    You receive the following error message when using TNSPing  TNS-03505: "Failed to resolve name"    Cause: The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service. 
Action: Verify that you entered the service name correctly.  You may need to ensure that the name was entered correctly into the network configuration using Oracle Network Manager.  
Solution Description:  ===================== 
If are using the TNSPing to connect and receiving the TNS-03505 error, connecting with another tool such as SQL*Plus will give you an error message that will help narrow down the exact connection problem.
For example connecting with SQL*Plus may return the following error  message which is more specific to your problem:  ORA-12203: "TNS:unable to connect to destination" 
    Cause: Invalid TNS address supplied or destination  
    is not listening. This error can also occur because    
    of underlying network transport problems.
    Action: Verify that the service name you entered on  
    the command line was correct.
    Ensure that the listener is running at the remote
    node and that the ADDRESS parameters specified in   
    TNSNAMES.ORA are correct. Finally, check that all
    Interchanges needed to make the connection are up  
    and running.   

-----------------------------------------------------------

If your other tools ( Like SqlPLus) can connect but tnsping gives that error, on unix you need to also from Metalink)

---------------------------------------------------
Solution Description:  =====================
You need to relink TNSPing using the TNSPing that is shipped with SQL*Net 2.2.
  Follow the steps below to relink:
    1)  Goto the $ORACLE_HOME/network/lib directory.
    2)  Do:  make -f network.mk tnsping  
    3)  Copy the tnsping executable to the
        $ORACLE_HOME/bin directory. 

  To relink TNSPing that is shipped with SQLNet 2.3: 
    1)  Go to the $ORACLE_HOME/network/lib directory.
    2)  Do:  make -f ins_network.mk tnsping 
    3) Do:  make -f ins_network.mk install 
---------------------------------------------------------

That relinking part will depend on your version of SqlPlus...
hth,

 

[Turkbear]

HI,
One problem is that your environment does not have ORACLE_HOME set ( That is why the message file coiuld not be found) and it may prevent tnsping from finding your tnsnames.ora file
- The message it is trying to show you is ( From Metalink):

Problem Description:  ====================    You receive the following error message when using TNSPing  TNS-03505: "Failed to resolve name"    Cause: The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service. 
Action: Verify that you entered the service name correctly.  You may need to ensure that the name was entered correctly into the network configuration using Oracle Network Manager.  
Solution Description:  ===================== 
If are using the TNSPing to connect and receiving the TNS-03505 error, connecting with another tool such as SQL*Plus will give you an error message that will help narrow down the exact connection problem.
For example connecting with SQL*Plus may return the following error  message which is more specific to your problem:  ORA-12203: "TNS:unable to connect to destination" 
    Cause: Invalid TNS address supplied or destination  
    is not listening. This error can also occur because    
    of underlying network transport problems.
    Action: Verify that the service name you entered on  
    the command line was correct.
    Ensure that the listener is running at the remote
    node and that the ADDRESS parameters specified in   
    TNSNAMES.ORA are correct. Finally, check that all
    Interchanges needed to make the connection are up  
    and running.   

-----------------------------------------------------------

If your other tools ( Like SqlPLus) can connect but tnsping gives that error, on unix you need to also from Metalink)

---------------------------------------------------
Solution Description:  =====================
You need to relink TNSPing using the TNSPing that is shipped with SQL*Net 2.2.
  Follow the steps below to relink:
    1)  Goto the $ORACLE_HOME/network/lib directory.
    2)  Do:  make -f network.mk tnsping  
    3)  Copy the tnsping executable to the
        $ORACLE_HOME/bin directory. 

  To relink TNSPing that is shipped with SQLNet 2.3: 
    1)  Go to the $ORACLE_HOME/network/lib directory.
    2)  Do:  make -f ins_network.mk tnsping 
    3) Do:  make -f ins_network.mk install 
---------------------------------------------------------

That relinking part will depend on your version of SqlPlus...
hth,

 

[cliousa]

tnsping Oracle binary cannot find the message files from the proper ORACLE_HOME. Make sure the ORACLE_SID, oRACLE_HOME and LD_LIBRARY_PATH are setup in the bash shell environment.




Hope that helps,
clio_usa - OCP DBA
------------------

http://www.dbaclick.com

 

[khayr]

Thanks for the responses. It turned out to be the ORACLE_HOME environment variable not being properly set.
Best regards.