Monday, June 4, 2012

TNS-03505: Failed to resolve name

Tnsentry was something like below.

TXCOM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = TEST11v)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = TEST12v)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TXCOM.world)
    )
  )
  

it gave error TNS-03505: Failed to resolve name , which mostly happen due to bad syntax.

TEST11 | DUMMY1 | /u00/app/oracle/product/10.2.0/DB/network/admin
> tnsping TXCOM

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 04-JUN-2012 09:55:54

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

Used parameter files:

TNS-03505: Failed to resolve name

This need to check why its not able to find TNSnames. before that make sure you corrected syntax of tnsentry in tnsnames.ora

lets check what is $TNS_ADMIN set to.

TEST11 | DUMMY1 | /u00/app/oracle/product/10.2.0/DB/network/admin
> echo $TNS_ADMIN
/u00/app/oracle/product/10.2.0/ASM/network/admin
TEST11 | DUMMY1 | /u00/app/oracle/product/10.2.0/DB/network/admin
> export TNS_ADMIN=/u00/app/oracle/product/10.2.0/DB/network/admin
TEST11 | DUMMY1 | /u00/app/oracle/product/10.2.0/DB/network/admin
> tnsping TXCOM

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 04-JUN-2012 09:58:00

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = TEST11v)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = dukegotd99v)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TXCOM.world)))
OK (0 msec)
TEST11 | DUMMY1 | /u00/app/oracle/product/10.2.0/DB/network/admin