Skip to content
Home » Oracle » How Oracle Disable Restricted Mode

How Oracle Disable Restricted Mode

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 off the limitation, we can disable it.

SQL> alter system disable restricted session;

Then we check the LOGINS status.

SQL> select logins from v$instance;


The status is back, we removed the restricted mode.

Leave a Reply

Your email address will not be published. Required fields are marked *