SHUTDOWN: waiting for active calls to complete.

Issue:

Active call for process 1993 user ‘oraprod’ program ‘oracleprod@prod’

Active call for process 18672 user ‘oraprod’ program ‘oracleprod@prod’

Active call for process 19304 user ‘oraprod’ program ‘oracleprod@prod’

SHUTDOWN: waiting for active calls to complete.

Problem: When SHUTDOWN IMMEDIATE HUNG with above message means PMON process is unable to clear any uncommitted transaction and oracle hung for long time.

Solution:

1. Connect to SYS user with new terminal window

SQL> conn / sysdba
Connected to idle instance.

2. Shutdown database with ABORT option

SQL> shutdown abort;
ORACLE instance shut down.

3. Open database for normal shutdown with RESTRICT option

SQL> startup restrict
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 788496 bytes
Variable Size 149682160 bytes
Database Buffers 16777216 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.

4. Now shutdown database with NORMAL option

SQL> shutdown normal;
Database closed.
Database dismounted.
ORACLE instance shut down.

I hope this article helped you. Your suggestions/feedback are most welcome.

Keep learning... Have a great day!!!