How To Change Your OBIEE Connections When You Have Moved Your RCU Database To A New Host
(Doc ID 2177562.1)
Last updated on DECEMBER 12, 2022
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 12g]
Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 12g]
Information in this document applies to any platform.
These steps have not been confirmed with Oracle Analytics Server (OAS); therefore, they are not supported at this time.
For OAS, see: How To Change Your Oracle Analytics Connections When You Have Moved Your RCU Database To A New Host (Doc ID 2802991.1)
You have installed OBIEE 12c.
The RCU database is required to move from one host to another and the hostname of the database has changed.
This document describes the steps to reconfigure your OBIEE-to-RCU database connections in this situation.
The examples provided are for an Oracle database.
The document details two possible alternative ways to accomplish the task:
- New RCU schemas are installed in the new target Oracle database.
In this case, the security store needs to be migrated or re-associated from the source Oracle database to the new target Oracle database where the RCU schemas are to be installed. This is needed because the newly created OPSS schema contains no security store.
- The database where the RCU schemas are hold is moved or "cloned" using some cloning Oracle DBA utility and imported into the new target Oracle database.
In this case, the security store residing in the source Oracle database within the OPSS RCU schema is moved as result of the database cloning process. No additional steps are required regarding the security store beyond what is done by the Oracle database cloning utility.
Ensure you have a cold backup of your entire installation.
Ensure you backup any file before modifying.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Installing New RCU Schemas In The New Oracle Database|
Cloning The Database Where The Original RCU Schemas Are Held To Move Them To A New Oracle Database