[ORACLE] 오라클 tns설정하는 방법

/ORACLE/../../network/admin/tnsnames.ora 파일을 열어서 연결하고자 하는 오라클 host를입력.

NEWIAE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NEWIAE)
)
)

2대의 오라클 서버로 failover기능 설정
NEWIAEDB =
(DESCRIPTION =
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =NEWIAEDB )
(failover_mode=(type=none)(method=basic))
)
)