Description:-
Resolving Oracle PDB Database Opened Restricted mode using below demo.
We need to check the below queries to find the problem:-
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE YES
col name for a10
col restricted for a20
select name,open_mode,restricted from v$pdbs where name = ‘ORCLPDB’;
NAME OPEN_MODE RESTRICTED
———- ———- ——————–
ORCLPDB READ WRITE YES
col message for a40
select name,cause,type,message,status from pdb_plug_in_violations order by name;
NAME CAUSE TYPE MESSAGE STATUS
———- ——————– ——— —————————————- ———
ORCLPDB Sync Failure ERROR Sync PDB failed with ORA-959 during ‘alt PENDING
er user C##TEST default tablespace data
QUOTA 3m ON data’
Problem is tablespace is dropped and quota is missing on users.
Solution:-
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> create tablespace data datafile ‘/u01/app/oracle/oradata/ORCL/orclpdb/data.dbf’ size 50m;
Tablespace created.
alter user C##TEST quota 3m on data;
SQL> alter pluggable database ORCLPDB close immediate;
Pluggable database altered.
SQL> alter pluggable database ORCLPDB open;
Pluggable database altered.
SQL> alter pluggable database ORCLPDB save state;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
3 ORCLPDB READ WRITE NO
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr
