How To Change The JDBC Connecting String For The OBIEE 11g Metadata Repository "RCU" Database Without Starting WebLogic / AdminServer

(Doc ID 1424665.1)

Last updated on MAY 02, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.9.161018 [Release 11g]
Information in this document applies to any platform.

Goal

This document explains how to modify the JDBC connections to the metadata repository database where the OBIEE 11g schemas are stored as installed via the Repository Creation Utility (RCU).

Note: !!!! Moving schemas, post-install is explicitly un-supported except through the documented test-to-production (T2P) movement and cloning scripts as described in the Fusion Midddleware Administration documentation !!!
There are internal dependancies you may mis with an ad-hoc export/import



This document pertains to changes to the underlying database that contains the schemas, not moving the schemas.

For Disaster Recovery see:

Oracle Fusion Middleware Disaster Recovery Guide11g Release 1 (11.1.1) -- Part Number E15250-03
3.3 Database Considerations


Sample scenario or business use case:

The OBIEE MDS and BIPLATFORM Schemas were created via the Repository Creation Utility (RCU) on an Oracle RAC database with 3 instances / nodes.

When OBIEE was installed, the Database Connect String specified for the BIPLATFORM and MDS schemas was in the Oracle Database / RAC €œformat for example:

host1.domain:1521:node1.domain:1521:node2.domain:1521:node3.domain@dwh

The requirement now is for OBIEE to access the BIPLATFORM and MDS schemas only via instance / node 3 of the Oracle RAC database/

The original installation connection screen is configured as Node 1, Node 2, Node 3.

The failover for the RAC nodes is configured on the server-side.

Note: This could also apply if your JDBC connection is hard-coded with an IP address and the underlying IP address or hostname to the database changed.




Solution

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 hundreds of Community platforms