Кластерная база

Настройка строки коннекта кластерной базы


В общем виде (из Oracle® Fusion Middleware Service Registry
10g Release 3 (10.3)
E13665-01
Product Documentation, p. 37):

jdbc:oracle:thin:@
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP) (HOST=host1) (PORT=1521)
)
(ADDRESS= (PROTOCOL=TCP) (HOST=host2) (PORT=1521)
)
(LOAD_BALANCE=yes)
(CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=SID)
)
)

Работающая:

jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=xs1-vip) (PORT=1521))(ADDRESS= (PROTOCOL=TCP) (HOST=xs2-vip) (PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=DEMO)))

Расшифровка:

(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP) (HOST=xs1-vip) (PORT=1521)
)
(ADDRESS= (PROTOCOL=TCP) (HOST=xs2-vip) (PORT=1521)
)
(LOAD_BALANCE=yes)
(CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=DEMO)
)
)