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
