the below command was working without any problem :-
SQL > shutdown abort
to solve this issue & trace the error since the alertlog not indicating to anything interesting i have to dump systemstate every 5 minutes to know what going on :-
connect / as sysdba
alter session set events ‘10400 trace name context forever, level 1’;
After this you can kill the session that preventing shutdown.
The hangs usually happened for two reasons :-
- Query running on Database.
- Transaction happened while you are trying to shutdown database.
use v$session_longops Read more here.
Run the below query to check the query.
select count(*) from v$session_longops where time_remaining>0;
Second reason you can use
v$transaction Read from here.
Useful Document :-
Alert Log: Shutdown Waiting for Active Calls to Complete (Doc ID 1039389.6)