My Oracle Support Banner

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

Last updated on MAY 15, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Goal



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.

OR

- 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.

 

Note:
Ensure you have a cold backup of your entire installation.
Ensure you backup any file before modifying.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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