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

Last updated on DECEMBER 06, 2023

Applies to:

Goal

It has already been determined that you wish to use Database Failover using DataGuard (or already have this setup and working at the Database level).

The question asked to prompt this document is: "How do we configure the Oracle Fusion Middleware RCU created schemas to failover to a backup Oracle Database where DataGuard is 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)(PORT=XXXX))
(ADDRESS=(PROTOCOL=TCP)(HOST=backuphost.domain))(PORT=XXXX)))
(load_balance=no)(failover=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=my_db.domain)))

Notes:

• When the primary DB goes down service switches to the backup host server,  there is a tolerated delay in this case.  Once the switch is made, data access resumes. This is the nature of the DataGuard Failover (as opposed to a RAC Database which would be more continually seamless by its nature).
  
  
• FMW connections do not use tnsnames.ora, such as used on other DataGuard use cases. For Fusion Middleware using WebLogic Server, connections are made through JDBC datasource configurations, following configuration will allow FMW RCU created schema to switch over.
  
  

 The question is if this DataGuard feature may be used for the FMW Metadata Repository schemas and if so, how?

Solution

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