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 19, 2023

Applies to:

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.

Solution

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