Tag Archives: Restricted mode Oracle Database

Startup database in Restrict Mode

Start the database in Restrict Mode

Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index, remove fragmentation etc. It is very use full for DBA for start database in restricted mode for planned maintenance activity. So, No other user such as application users are able to connect with database until they have special rights.
startup restrict command: will open database in restricted mode.

Start the database in restricted mode:

Shutdown the database:
SQL> Shutdown immediate;

Start the database in restricted mode,So, no other user able to connect:
SQL> startup restrict;

Check the database in restricted mode

SQL> Select logins from v$instance;
LOGINS
--------------
RESTRICTED

Disable the session restricted mode or you can normal start the database.

SQL> alter system disable restricted session;
 
Check the status that restricted mode is disable:

SQL> Select logins from v$instance;
LOGINS
--------------
ALLOWED

Without restart the database, we put it in restricted mode:

alter system enable restricted session;

Note: If restricted session is blocked by some session.May need to kill them if urgent. Check from v$session

Advertisements