본문 바로가기

ETL Tools/Oracle Data Integrator

RAC - JDBC URL 설정 하는 법

모든 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)))