Search This Blog

Saturday, July 21, 2007

SHUTDOWN: waiting for active calls to complete


Below message found in "alert.log" file when shutdown immediate hung for long time

Thu Jul 19 21:08:00 2007
Active call for process 4448 user 'SYSTEM' program 'ORACLE.EXE (J001)'
SHUTDOWN: waiting for active calls to complete.





Oracle Database : 10.1.0.2.0
OS : Windows XP sp2


when SHUTDOWN IMMEDIATE HUNG with above message means PMON process is unable to clear any uncommited transaction and oracle hung for long time.


Suggestion :

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.

5 comments:

Babu B said...

Dear Taj...

Good concept.. Now i know new things.. keep it up your post..

Babu B

Mohammad Taj said...

Hi,

Thank You!!!

Regards
Taj

Anonymous said...

thank you . It works

Anonymous said...

Great! Thank you.

Anonymous said...

It works! Many thanks!