Database - RAC/Scalability (MOSC)

MOSC Banner

Conversion of jdbc datasource connections from RAC DB to single instance DB

edited Apr 12, 2019 5:06AM in Database - RAC/Scalability (MOSC) 4 commentsAnswered

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)))&lt;/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)))&lt

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center