OS: Windows Server 2012 R2 Standard
DB: Oracle Database 12.1.0.5 Enterprise Edition
SQL> ALTER SESSION SET CONTAINER = cdb$root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE pmpdb CLOSE IMMEDIATE;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE pmpdb OPEN READ ONLY;
Pluggable database altered.
SQL> CREATE PLUGGABLE DATABASE pm2pdb FROM pmpdb;
Pluggable database created.
SQL> ALTER PLUGGABLE DATABASE pm2pdb OPEN;
Warning: PDB altered with errors.
SQL> SELECT name, open_mode, restricted FROM v$pdbs ORDER BY name;
NAME OPEN_MODE RES
------------------------------ ---------- ---
PDB$SEED READ ONLY NO
PLPDB READ WRITE NO
PM2PDB READ WRITE YES
PMPDB READ ONLY NO
REVPDB READ WRITE NO
WMXPDB READ WRITE NO
6 rows selected.
SQL> ALTER PLUGGABLE DATABASE pm2pdb CLOSE IMMEDIATE;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE pm2pdb OPEN;
Warning: PDB altered with errors.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> ALTER SESSION SET CONTAINER = pmpdb;
Session altered.
SQL> SELECT KEY_ID,KEYSTORE_TYPE,CREATOR,CREATOR_INSTANCE_NAME,CREATOR_PDBNAME FROM V$ENCRYPTION_KEYS;
KEY_ID
------------------------------------------------------------------------------
KEYSTORE_TYPE CREATOR CREATOR_INSTANCE_NAME
----------------- ------------------------------ ------------------------------
CREATOR_PDBNAME
------------------------------
AW8mqVJU90/kv8tLJWR0ySYAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
SOFTWARE KEYSTORE SYS mcs
PMPDB
SQL> ALTER SESSION SET CONTAINER = pm2pdb;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PM2PDB
SQL> SELECT KEY_ID,KEYSTORE_TYPE,CREATOR,CREATOR_INSTANCE_NAME,CREATOR_PDBNAME FROM V$ENCRYPTION_KEYS;
no rows selected
SQL> SELECT name,status from v$tempfile where status != 'ONLINE' order by name;
no rows selected
SQL> SELECT name,status from v$datafile where status NOT IN ('ONLINE','SYSTEM') order by name;
no rows selected
SQL> ALTER SESSION SET CONTAINER = cdb$root;
Session altered.
SQL> SELECT WRL_PARAMETER,STATUS,WALLET_TYPE FROM V$ENCRYPTION_WALLET;
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE
------------------------------ --------------------
C:\ORACLE\ADMIN\MCS\WALLET
OPEN AUTOLOGIN
SQL>
-------------------------------------------------------------------------------------------------------------------------------------------------
alert_mcs.log
-------------------------------------------------------------------------------------------------------------------------------------------------
....
Tue Apr 29 16:32:43 2014
ALTER PLUGGABLE DATABASE pmpdb CLOSE IMMEDIATE
Tue Apr 29 16:32:44 2014
ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local
Pluggable database PMPDB closed
Completed: ALTER PLUGGABLE DATABASE pmpdb CLOSE IMMEDIATE
ALTER PLUGGABLE DATABASE pmpdb OPEN READ ONLY
Tue Apr 29 16:33:20 2014
Opening pdb PMPDB (3) with no Resource Manager plan active
Pluggable database PMPDB opened read only
Completed: ALTER PLUGGABLE DATABASE pmpdb OPEN READ ONLY
CREATE PLUGGABLE DATABASE pm2pdb FROM pmpdb
Tue Apr 29 16:34:41 2014
****************************************************************
Pluggable Database PM2PDB with pdb id - 7 is created as UNUSABLE.
If any errors are encountered before the pdb is marked as NEW,
then the pdb must be dropped
****************************************************************
....
Successfully created internal service pm2pdb.esri.com at open
WARNING: Detected that PDB needs to import keys from source. PDB can only open in restricted mode until import.
ALTER SYSTEM: Flushing buffer cache inst=0 container=7 local
Tue Apr 29 16:34:52 2014
****************************************************************
Post plug operations are now complete.
Pluggable database PM2PDB with pdb id - 7 is now marked as NEW.
****************************************************************
Completed: CREATE PLUGGABLE DATABASE pm2pdb FROM pmpdb
ALTER PLUGGABLE DATABASE pm2pdb OPEN
Tue Apr 29 16:36:05 2014
Pluggable database PM2PDB dictionary check beginning
Pluggable Database PM2PDB Dictionary check complete
Tue Apr 29 16:36:16 2014
Opening pdb PM2PDB (7) with no Resource Manager plan active
XDB installed.
XDB initialized.
Tue Apr 29 16:36:31 2014
Warning: Pluggable database PM2PDB altered with errors
Pluggable database PM2PDB opened read write
Completed: ALTER PLUGGABLE DATABASE pm2pdb OPEN
ALTER PLUGGABLE DATABASE pm2pdb CLOSE IMMEDIATE
Tue Apr 29 16:37:10 2014
ALTER SYSTEM: Flushing buffer cache inst=0 container=7 local
Pluggable database PM2PDB closed
Completed: ALTER PLUGGABLE DATABASE pm2pdb CLOSE IMMEDIATE
ALTER PLUGGABLE DATABASE pm2pdb OPEN
Tue Apr 29 16:37:39 2014
Opening pdb PM2PDB (7) with no Resource Manager plan active
Warning: Pluggable database PM2PDB altered with errors
Pluggable database PM2PDB opened read write
Completed: ALTER PLUGGABLE DATABASE pm2pdb OPEN
Have you seen this before? Any idea how to fix?
Thanks,
Marcelo Marques
Esri Technical Manager, OCP