How To Set Up Database Failover using DataGuard for FMW Infrastructure 12c RCU Created Metadata Repository Schemas (Doc ID 2142417.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Fusion Middleware - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Goal

How do we configure the Oracle Fusion Middleware RCU created schemas to failover to a backup Oracle Database where Dataguard was used?

Detailed explanation:

Oracle Fusion Middleware 12c Infrastructure installs following schemas in the database:

<prefix>_IAU_APPEND
<prefix>_OPSS
<prefix>_WLS_RUNTIME
<prefix>_IAU
<prefix>_WLS
<prefix>_STB
<prefix>_IAU_VIEWER

If the database is configured for failover using DataGuard, the failover entries in the tnsnames.ora may look like following:

(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=XXXX))
(ADDRESS=(PROTOCOL=TCP)(HOST=backuphost.domain.com))(PORT=XXXX)))
(load_balance=no)(failover=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=my_db.doman.com)))

 
When the primary db goes down service switches to the backuphost server, so there is a tolerated delay in this case.  Once the switch is made, data access resumes.

FMW connections do not use tnsnames.ora, connections are made through JDBC datasource configurations, following configuration will allow FMW RCU created schema to switch over.

Note: This is not a documented explanation, but this document provides the interim answer while it is being followed up with an internal <Bug 23472317>.

 


 

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