RCU 11.1.1.8+ Against an Oracle 12.1.0.1+ Database Fails with "ORA-01219: database or pluggable database not open"

(Doc ID 1942275.1)

Last updated on OCTOBER 05, 2017

Applies to:

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

Symptoms

When running the RCU 11.1.1.8 or 11.1.1.9 against an Oracle 12.1.0.1+ database, it fails with the following errors:

The version 12.1.0.x.0 of the database that you are using is not supported version or
The specificed user may not have sufficient privileges to perform this operation. User should have sysdba or dba privileges.

The rcu.log file shows:

ERROR rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::executeQuery: SQLException: ORA-01219: database or pluggable database not open

 

The RCU Database Connection Details screen using the PDB database looks like the following:

It returns "Operation failed. Click OK to return to the wizard to see the error".   Your only option is to click OK; it does not let you proceed.  The screen looks like the following:

The rcu.log file full error stack:

  

 

Changes

The 12.1.0.1+ Oracle Database is certified with the RCU 11.1.1.7 and higher; reference the System Requirements and Supported Platforms for Oracle Fusion Middleware 11gR1 ( xls)

Cause

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