How Oracle starts and shuts down-putting databases in restricted mode

Case 2: Putting the database into restricted mode

1. Open the database directly to restricted mode

Sql> startup Restrict
ORACLE instance started.

Total System Global area 608174080 bytes
Fixed Size 1268920 bytes
Variable Size 230687560 bytes
Database buffers 373293056 bytes
Redo buffers 2924544 bytes
Database mounted.
Database opened.

Restricted mode: Only the administrator user and the user with restricted session permission will be allowed access to the database, either remotely or locally, and the state of the database in the listener is restricted


2. Database in the open state when the database is placed in restricted mode

Sql> alter system enable restricted session;

System altered.

3. Release restriction mode

Sql> alter system disable restricted session;

System altered.

How Oracle starts and shuts down-put the database in restricted mode