# TNSNAMES.ORA Network Configuration File: OracleHOME\NETWORK\ADMIN\tnsnames.ora #*************************************************************** # Templates: # RAC with failover # tns_alias = # (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP)(HOST = server1-vip)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = server2-vip)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = server3-vip)(PORT = 1521)) # (LOAD_BALANCE = YES) # (CONNECT_DATA = # (SERVER = DEDICATED) # (SERVICE_NAME = serv_name) # (FAILOVER_MODE = # (TYPE = SELECT) # (METHOD = BASIC) # (RETRIES = 180) # (DELAY = 5) # ) # ) # ) # # RAC with no failover specified # tns_alias = # (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP)(HOST = server1-vip)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = server2-vip)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = server3-vip)(PORT = 1521)) # (LOAD_BALANCE = yes) # (CONNECT_DATA = # (SERVER = DEDICATED) # (SERVICE_NAME = serv_name) # ) # ) # # Non-RAC # tns_alias = # (DESCRIPTION = # (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521)) # ) # (CONNECT_DATA = # (SERVER = DEDICATED) # (SERVICE_NAME = serv_name) # ) # ) # #***************************************************************