Wednesday, 8 May 2019

Oracle DBA: To un-quiesce Oracle database

SQL> select active_state from v$instance;
 
ACTIVE_ST
---------
QUIESCED
 
SQL> alter system unquiesce;
 
System altered.
 
SQL> select active_state from v$instance;
 
ACTIVE_ST
---------
NORMAL

Number of Visitors