How to redirect Webcenter Content Server or UCM to Remote Database

Inorder to redirect the Webcenter Content Server or UCM to Remote Database, both Remote Database & RCU should be compatible versions and remote DB machine should be reachable from Content Server (CS) machine.

Pointing can be changed from Weblogic Server (WLS) console:

1) Please take backup of config.xml & cs-ds-jdbc.xml

•  Oracle\Middleware\user_projects\domains\base_domain\config
•  Oracle\Middleware\user_projects\domains\base_domain\config\jdbc

2) Login to WLS console as admin user (weblogic) and browse through (  Home >Summary of JDBC Data Sources >CSDS >Summary of JDBC Data Sources >CSDS )

3) Click on Connection Pool tab

4) Change hostname, service id, port, user & passwords.

5) Just restart the managed servers first & monitor logs for errors if any.

6) Shutdown managed & admin server & start.

Now the WebCenter Content server or UCM will use the schema available in the remote database.