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

We have one production machine here ( Oracle 9.2.0.8 / 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.

Thomas
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: 64102
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.

Regards
Michel
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: Fri Dec 02 14:27:26 CST 2016

Total time taken to generate the page: 0.19099 seconds