My Oracle Support Banner

How To Change Your OBIEE Connections When You Have Moved Your RCU Database To A New Host (Doc ID 2177562.1)

Last updated on JUNE 02, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 12g]
Business Intelligence Server Enterprise Edition - Version to [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.

Current supported methods for OAS are:

1. Clone database.
2. Install a new instance of OAS using the new RCU database. Export snapshot from source via the Analytics Console, then import snapshot to target.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.