Yes, sometimes some dbms_jobs, or cron jobs could be running... rebuilding indexes, gathering database statisitics or backups. (well maybe backups don't count), but some of these will cause you to wait.
-----Original Message-----
From: Shergill Gurmohan [mailto:oracledba-ezmlmshield-x76131991.[Email address protected]
Sent: Tuesday, June 28, 2005 10:19 AM
To: LazyDBA Discussion
Subject: RE: Shutdown immediate Problem
Mr. Schulz's suggestion is a very valid suggestion and you may want to consider if some huge transaction was being rolled back at the time shutdown immediate was issued, but if Mr. Schulz's suggestion is not the case then consider this.
'I recently ran into a similar issue and found that one of the oracle background process was not shutting down completely. When one of the oracle background process hangs oracle can't complete the shutdown process and stay confused with or without stating what is going on. Please check if this is not the case with you. Go to the operating system and check for remaining oracle background processes, if any. Alternately look for any special or related entries in alert log and trace files during this time.'
Gurmohan
www.onlymath.com
-------------------------------------------------------------------------------
-----Original Message-----
From: "Rüdiger J. Schulz"
[mailto:oracledba-ezmlmshield-x83404444.[Email address protected]
Sent: Tuesday, June 28, 2005 8:11 AM
To: LazyDBA Discussion
Subject: Re: Shutdown immediate Problem
it's possible, that the hanging session takes a long time rollback.
hth
Rüdiger J. Schulz
sosys-berlin.de
jayeshrshah schrieb:
>Dear Guru
>
>when i gave command "sql>shutdown immediate" the session has been in hang
>& not going proper.
>
>So i can not take cold backup
>
>Please reply soon why it happend?
>
>Thanks in advance
>regards,
>
>Jayesh shah
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page