echo $ORACLE_SID
YBRD
conn sys/hello as sysdba
SQL>shutdown immediate
Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window.
Then I again logged in and it displayed:
ORACLE IMMEDIATE SHUTDOWN IN PROGRESS
Will it shutdown automatically by itself after a while?
Yes, it will -- of course if it persistently refuses to you might have to kill the processes, and face instance recovery on restart.
Normally it should happen quickly. There could be large transactions that take a while to rollback, or a long running transaction that takes ages to end.
If the time is spent for the rollback, you could crash the instance with a good and solid kill -9 on the server procs and use parallel instance recovery. Normally this should not happen but parallel instance recovery can be quicker than a recovery by 1 process.
According to "Shutdown Timeout" section in Database Administrator's Guide, shutting down the database in any of the following modes may take up to one hour:
Normal Mode
Immediate Mode
Transactional Mode
Shutdown in Abort Mode will bring your instance down in a short amount of time not allowing it to checkpoint (see "Overview of Checkpoints" in Database Concepts), and the next time it's started the crash recovery will be automatically performed which may take some amount of time.
Sometimes Transactional Mode shutdown may be faster than the shutdown with Immediate Mode since Immediate Mode shutdown rolls back all transactions that were running when the shutdown was initiated, and if some DML had already updated millions of rows, committing it would be faster than rolling it back, because most of the changes are already in the redo log and in data files.
