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
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 (cứ để tiến trình shutdown immediate đừng tắt nó)
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.