Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Kim Soederhamn
(1.5k●3●43●48) 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

0 votes

1 answer
1,267 views
0 votes

One answer

Permanent link
Kim Soederhamn
(1.5k●3●43●48) 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)))

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,487
× 1,316
× 456
× 85
× 42

Question asked: Jul 01 '21, 3:22 a.m.

Question was seen: 1,267 times

Last updated: Jul 01 '21, 3:25 a.m.

Confirmation Cancel Confirm