ORA-65144
Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE YES
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> alter system disable restricted session;
alter system disable restricted session
*
ERROR at line 1:
ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
ORA-65144 means that the PDB you cloned has errors in PDB_PLUG_IN_VIOLATIONS after opening it, which inevitably bring the PDB in restricted mode. You should solve errors in PDB_PLUG_IN_VIOLATIONS before normally opening it.
Actually, when you tried to remove the restricted mode by restarting the PDB, error "Warning: PDB altered with errors" prevents you to do so.
Errors in Alert Log
Let's see what we found in alert log.
[oracle@primary01 ~]$ vi $ORACLE_BASE/diag/rdbms/<db_unique_name_in_lower_case>/$ORACLE_SID/trace/alert_$ORACLE_SID.log
...
ORCLPDB(3):***************************************************************
ORCLPDB(3):WARNING: Pluggable Database ORCLPDB with pdb id - 3 is
ORCLPDB(3): altered with errors or warnings. Please look into
ORCLPDB(3): PDB_PLUG_IN_VIOLATIONS view for more details.
ORCLPDB(3):***************************************************************
Want to know where Oracle alert log is? You may take a look.
Solution
The solution is exactly the same as we resolved "Warning: PDB altered with errors.".