I was creating Data Servers in Oracle Data Integrator and was wondering how fail over should be done. Don't be fooled by Oracle Data Integrator's Oracle JDBC thin driver connect URL example:
Of course you can specify more advanced connect strings like for example jdbc:oracle:thin:@
(DESCRIPTION= (ADDRESS_LIST= (FAILOVER=on) (ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521)) ) (CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME=a_service) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=20) (DELAY=15) ) ) )
Classic case of RTFM (which -of course- stands for Read The Friendly Manual).
No comments:
Post a Comment