Hello everyone,
We have a requirement to create another database on different server so that in case of any issue on primary database, we can switch to secondary database without loss of data.
Primary Server: frhdstdrpov05.main.glb.corp.local
Secondary Server: frhdclyrpov04.main.glb.corp.local
Database Service Name: HRM800P_DG
For this, DB team has created the database on another server and synced it with the primary database. They have also created a database service on each database(say HRM800P_DG) and shared the configuration string with us to configure it at our end. Below is the configuration string-
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=frhdstdrpov05.main.glb.corp.local)(PORT=1524))(ADDRESS=(PROTOCOL=TCP)(HOST=FRHDCLYRPOV04.main.glb.corp.local)(PORT=1524))(LOAD_BALANCE=yes)(FAILOVER=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=HRM800P_DG)))
Only one server will be active at one time, and when required, DB team will do the switching at their end.
Could anyone please help me what all places I have to update this string. Few places that I have identified are-
- All the JDBC adapters connection strings
- MWS config file (mws.db.xml)
- All the Pool alias definitions which are connnecting to this database
Any other files/setting i need to modify?
Thanks in advance,
Prateek