1 Reply Latest reply: May 13, 2013 2:48 AM by saurabh RSS

    Tnserror

    962407
      Hi All,

      I'm getting following error while pinging, Can anyone suggest.

      TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-APR-2013 08:21:59

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

      Used parameter files:
      /oraeng/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

      TNS-03505: Failed to resolve name

      Regards,
      TK
        • 1. Re: Tnserror
          saurabh
          the database you are trying to tnsping it's entery is not present in tnsnames.ora file or you are not using the correct entery. to check it go to tnsnames.ora file and check the aliase name for the particulary entery

          eg
          In tnsnames.ora file

          TEST =
          (DESCRIPTION =
          (ADDRESS_LIST =
          (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = x.x.x.x)
          (PORT = xxxx)
          )
          )
          (CONNECT_DATA =
          (SID = test)
          (SRVR = DEDICATED)
          )
          )


          cmd promt

          #tnsping TEST