Home » RDBMS Server » Server Administration » Shutdown Immediate Timeout
Shutdown Immediate Timeout [message #245903] Tue, 19 June 2007 03:45 Go to next message
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member

We have one production machine here ( Oracle / AIX 5.3 ) where we make an automated OS level flashcopy onto a test machine regularly. ( Not only the DB needs to be a 1:1 copy of production, but other files and programs on the machine, too, so that's the easiest way to enshure that )

For that we shut down the database with "shutdown immediate".

Every now and then the shutdown fails with a "ORA-01013: user requested cancel of current operation" after one hour (normally it's down in a few seconds) because of some sessions seem to be hung and can't be disconnected.

According to this http://docs.huihoo.com/oracle/docs/B19306_01/server.102/b14231/start.htm#CIHDAGBD it seems to be a one-hour hardcoded timeout. Does anyone know a way to shorten that timeout? We would like to get on with the rest of the nightly jobs if the shutdown fails, and skip the copy onto test in that case.

Re: Shutdown Immediate Timeout [message #245912 is a reply to message #245903] Tue, 19 June 2007 04:14 Go to previous message
Michel Cadot
Messages: 63937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you said it is hard-coded and so I don't think there is any way to change it.

Previous Topic: Do not answer my question as it is NOT urgent at all - How to kill a SYS session
Next Topic: Dropping empty Tablespace
Goto Forum:

Current Time: Thu Oct 27 17:39:21 CDT 2016

Total time taken to generate the page: 0.11205 seconds