Conversion of jdbc datasource connections from RAC DB to single instance DB
We have oim 11gR2PS3 2 node cluster environment with 2 node oracle rac database. Now we want to change the rac 2 node database to single instance DB.
As we currently have 2 node rac so we are using "Multi Source JDBC Datasource" and here are the DB connection entries we have in
datasource xml files.
a)- opss-rac0-jdbc.xml
<url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DB-scan-address)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oimdb)(INSTANCE_NAME=oimdb1)))</url>
b)- opss-rac1-jdbc.xml
<url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DB-scan-address)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oimdb)(INSTANCE_NAME=oimdb2)))<