Skip to content

How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted

  • by

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.".

Leave a Reply

Your email address will not be published.