Skip to content

How Oracle Disable Restricted Mode

  • by

Disable Restricted Mode

After you have done your jobs in restricted mode, you may consider to leave the mode. Disabling restricted mode means that we stop limiting user's access to the database, users can freely connect to the database as they want.

If this is a pluggable database, there're more options to remove the restricted mode from the PDB.

To lift the limitation by disabling it.

SQL> alter system disable restricted session;

Then we check the LOGINS status.

SQL> select logins from v$instance;

LOGINS
----------
ALLOWED

The status is back, we removed the restricted mode.

Leave a Reply

Your email address will not be published.