We have a warehouse system in our site.I dont understand what si the situation which makes the database to hangs when i give shutdown immediate.Please respond fast its urgent.
may be your temporary tablespace extents are too small and it takes ages for SMON to dealocate them?
or may be you have intelligent agent installed?
You can try shutdown abort, startup and then shutdown immediate.
I've had this happen on occasions, but are you getting it all the time?
when it does occur, I have to start another server manager session and shutdown abort (then startup, shutdown etc.)
I haven't really looked into it, although I have a feeling it's linked to then intelligent agent too.
Try killing all the agents like listener, dbsnmp agent, data gatherer running on the instance if you have. If thats the problem.. work around is create a script that kills all your agents first and tehn use server manager to shutdown database.
Shutdown immediate should kill the agents and bring the database down. Sometimes no where abouts why it bahaves like that. If you can't that way then 'shutdown abort' is the only solution.
Depending on which version of Oracle you are running, there is also a bug with Dead Connection Detection that hangs on shutdown immediate.
sreddy is right..
login to server from other connection and stop
all the listeners.this should help
Has your server been up for about 248 days?? If so, there is a bug that causes shutdown immediate to hang. This is due to a corruption in the controlfile. Plz check for this bug on Metalink.
[Edited by Halo on 12-20-2000 at 12:16 PM]
If SGA is configured with large memory (> 2GB) , Oracle takes long time to shutdown the instance. The work around is:
1 Issue a check point ( or switch redo log)
2 ALTER SYSTEM FLUSH SHARED_POOL.
3 Ensure that no lock on any table (Query from V$LOCKED_OBJECT view) is held.
4 Kill INACTIVE sessions manually.
5 Issue SHUTDOWN IMMEDIATE or ABORT.
PS. If SHUTDOWN ABORT was used, then bring up instance and then shutdown normal.
Click Here to Expand Forum to Full Width