SHUTDOWN: waiting for active calls to complete

Symptom

Active call for process 16101 user 'araadm' program 'oracle@itsiti'
SHUTDOWN: waiting for active calls to complete.

Solution 1

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;

Solution 2

1. Check the process that are still active.

ps -ef | grep LOCAL

2. Kill the process manually at the OS level

kill <PROCESS-ID>

or you can kill all the process occupied by the SIDadm

killall -u <USER>

3. Execute shutdown again

SQL> shutdown immediate;