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: 3202
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: 65144
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: Oracle 10g R2 for Redhat AS 4
Next Topic: Configure shmmax on solaris
Goto Forum:
  


Current Time: Sat Aug 19 13:54:49 CDT 2017

Total time taken to generate the page: 0.07706 seconds