It's all about the answers!

Ask a question

How to specify 2 servers in jdbc string for Oracle data guard


Kim Soederhamn (1.5k24247) | asked Jul 01 '21, 3:22 a.m.

 If you are using Oracle Data guard you would have 2 potential server addresses. Normally users would use the oracle ldap to get the address of the current one but with jdbc this is not possible

One answer



permanent link
Kim Soederhamn (1.5k24247) | answered Jul 01 '21, 3:25 a.m.

 the format for the jdbc string should be like(all chars included):


thin:YOURJAZZDBSCHEMA/{password}@(description=(load_balance=on)(failover=on)(connect_timeout=10)(retry_count=9)(retry_delay=2)(address=(protocol=tcp)(host=someprimaryhost.company.com)(port=1531))(address=(protocol=tcp)(host=comsecondhost.company.com)(port=1531))(connect_data=(service_name=databaseservice.company.com)))

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.