ETL Tools/Oracle Data Integrator
RAC - JDBC URL 설정 하는 법
천정현
2010. 10. 28. 16:25
모든 IP를 기술하여 작성
예 : RAC로 8개 서버에서 바라 보는 구조일 때
jdbc:oracle:thin:@
(DESCRIPTION =
(LOAD_BALANCE = on)
(FAILOVER = on)
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = SID)))