Tuesday, December 27, 2016

SHUTDOWN: waiting for active calls to complete

Solution 

1. Shutdown database with ABORT option

SQL> shutdown abort;


2. Open database with RESTRICT option

SQL> startup restrict


3. Shutdown database with NORMAL option

SQL> shutdown normal;


Implementation