I've encountered an issue while installing OEM 13c (13.1.0.0) against a 12.1.0.2.0 pluggable database.
I have a 12.1.0.2.5 RAC DB with a PDB named 'emrep_pdb'.
select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
BWPDB MOUNTED
EMREP_PDB READ WRITE <-- I want to use this PDB as my OMR
On step #7 of the OEM Enterprise Manager Cloud Control 13c Installation Process I enter the following database connection details:
Database Host Name: <SCAN hostname for DB>
Port: 1521
Service/SID: emrep_pdb
SYS Password: <password for SYS account>
I receive error:
ORA-01219: database or pluggable database not open; queries allowed on fixed tables or views only
However, the PDB is open as shown in the query above. Any ideas why I can't connect to the PDB from the OEM 13c installer in step #7?