Oracle 사용을 위한 팁 (4)

Oracle에 연결하기 위해 사용하는 Oracle Client 8.1.7 버전용 tnsnames.ora파일의 내용

Oracle TNSNAMES.ORA for K**사 Magic*서비스용

mickey_ctf =

(DESCRIPTION =

(ADDRESS_LIST =

(LOAD_BALANCE = OFF)

(FAILOVER = on)

(ADDRESS = (PROTOCOL = TCP)(Host= ***.***.**.**)(Port= ****))

(ADDRESS = (PROTOCOL= TCP)(Host= ***.***.**.**)(Port= ****))

)

(CONNECT_DATA =

(SERVICE_NAME = ORAJUDB)

)

)

mini_ctf =

(DESCRIPTION =

(ADDRESS_LIST =

(LOAD_BALANCE = OFF)

(FAILOVER = on)

(ADDRESS = (PROTOCOL = TCP)(Host= ***.***.**.**)(Port= ****))

(ADDRESS = (PROTOCOL= TCP)(Host= ***.***.**.**)(Port= ****))

)

(CONNECT_DATA =

(SERVICE_NAME = ORAJUDB)

)

)

mickey_taf =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(Host= ***.***.**.**)(Port= ****))

)

(CONNECT_DATA =

(SERVICE_NAME = ORAJUDB)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(BACKUP = mini_taf))

)

)

mini_taf =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(Host= ***.***.**.**)(Port= ****))

)

(CONNECT_DATA =

(SERVICE_NAME = ORAJUDB)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(BACKUP = mickey_taf))

)

)