In this Document
APPLIES TO:
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
On : 12.1.0.2 version, Oracle Multitenant
It is not possible to change PDB from restricted mode after using:
SQL> alter pluggable database < Name of the PDB > open;
Example:
alter pluggable database IVIEWDEV open;
SQL> select name,open_mode,restricted from V$pdbs;
NAME OPEN_MODE RESTRICTED
---------- ------------------------------ ---------
IVIEWDEV READ WRITE YES
CHANGES
Create New PDB
CAUSE
The PDB is in open read/write
The reason it shows that it is restricted is that PDB is not compatible with CDB which can be seen from the PDB_PLUG_IN_VIOLATIONS which displays information about incompatibilities between a PDB and the CDB to which it belongs.
From the below query, we can notice that there is no TEMP tablespace which is also confirmed by querying dba_temp_files and dba_tablespaces
SQL> Select * from PDB_PLUG_IN_VIOLATIONS;
TIME NAME CAUSE TYPE ERROR_NUMBER LINE MESSAGE STATUS ACTION
30-SEP-14 01.46.51.369356 PM IVIEWDEV Sync Failure ERROR 0 1 Sync PDB failed with ORA-959 during 'CREATE USER C##TADDM_RO IDENTIFIED BY * DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUN T UNLOCK container = all' PENDING
DEFAULT TABLESPACE ===========USERS
TEMPORARY TABLESPACE ========TEMP
Checking
dba_temp_files and dba_tablespaces the temp tablesapacenames are
TEMP01
TEMP02
TEMP03
so Temp is not included
SOLUTION
Create tablespace
TEMPORARY TABLESPACE named TEMP
REFERENCES
To Bottom