Home » RDBMS Server » Server Administration » SHUTDOWN: Active sessions prevent database close operation
SHUTDOWN: Active sessions prevent database close operation [message #208135] Fri, 08 December 2006 05:12 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
It is taking a lot of time for the database to shutdown. Here I am doing a shutdown immediate,Doing a cold backup and again starting the database.

Whats the time at which the complete shutdown takes place.. Is it 4:38:28 or is it 5:40:09 ?
In this case the sequential command in my shell script to copy the db files starts immediately after 04:38:28. Is this correct?

Is the database shuting down completely at all? because the error " SHUTDOWN: Active sessions prevent database close operation "
is shown.


The following is the snippet from the database alert log.

Fri Dec 8 03:37:10 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 266
Fri Dec 8 03:42:19 2006
Active call for process 24754 user 'oraprod' program 'oracle@proddb (TNS V1-V3)'
SHUTDOWN: waiting for active calls to complete.
Fri Dec 8 04:38:28 2006
SHUTDOWN: Active sessions prevent database close operation
Fri Dec 8 05:40:09 2006
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
Fri Dec 8 05:42:13 2006
Starting ORACLE instance (normal)
Re: SHUTDOWN: Active sessions prevent database close operation [message #208140 is a reply to message #208135] Fri, 08 December 2006 05:20 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You don't mention what version of Oracle you are on, but for 9.2 and above the timeout is 60 minutes. After 60 minutes, the shutdown will be canceled. You should investigate what 'oraprod' is doing to prevent shutdown.
Re: SHUTDOWN: Active sessions prevent database close operation [message #208145 is a reply to message #208140] Fri, 08 December 2006 05:39 Go to previous messageGo to next message
laksha
Messages: 42
Registered: June 2006
Member
The database version is 9.2.0.5 . But if it cancelles the shutdown, which state is it in after that.
Thanks for the response.

Please answer my other queries in the post.
Re: SHUTDOWN: Active sessions prevent database close operation [message #208148 is a reply to message #208145] Fri, 08 December 2006 05:58 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What more is there to answer? You start the shutdown at 3:37 and as indicated in the alert log an hour later (4:38) the shutdown cancels (ie. the database is NOT shutdown).
Previous Topic: ORA-00600: internal error code, arguments:[6002],[0],[0],[2],[0],[],[],[]
Next Topic: obsolete and/or deprecated parameter(s)
Goto Forum:
  


Current Time: Fri Dec 02 23:12:06 CST 2016

Total time taken to generate the page: 0.13319 seconds