Re: force clean database shutdown

maxim2k wrote:
Hi,

I'm running Oracle Database 10g R2 on Red Hat Enterprise Linux 4.

I've configured the server to use the dbstart/dbshut scripts, provided by Oracle, to automatically startup/shutdown the database at when starting/shutting down the server.

I've noticed that the dbshut script will sometime take forever to bring down the db when shutting down the server, it will just hang there ...

It looks like the database is waiting for its clients to close their connections, before going down, or something like that.

How can I force a clean shutdown for the database when the server needs to be rebooted (e.g. for a kernel update)?

I have no control over the db clients, I have full control on the server.

Thanks.

Does your dbshut script perform a simple SHUTDOWN or SHUTDOWN NORMAL? If so, then this will wait for all active connections to disconnect. If you do not want to wait this long, you can change your dbshut to use SHUTDOWN IMMEDIATE. The SHUTDOWN IMMEDIATE command will terminate all active session, roll back any work that was in progress, and leave the database in a consistent state at shutdown. Depending on the current transactions, rolling back their work can still take some time to complete. But this is better (IMO) than SHUTDOWN NORMAL.

HTH,
Brian

--
===================================================================

Brian Peasland
oracle_dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
.

Relevant Pages

  • Exchange 2003 Ops...
    ... Then went and shut down the exchange information store and all ... database was not shutdown cleanly ... MicrosoftExchange Server Database Utilities ...
    (microsoft.public.exchange.admin)
  • Re: db repair
    ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
    (microsoft.public.access.setupconfig)
  • Re: VB Script to dismount stores
    ... I have the exact script you are looking for in fact, ... I had to force my exchange hard drives back on so ... ' This code will dismount the selected mailbox database. ... I changed the server and store names but when I run the script I get ...
    (microsoft.public.exchange.admin)
  • RE: Cant call method "prepare" on an undefined value
    ... The error happen on the line to connect to that database: ... This script is working fine I located the script in same server as the ... I have one oracle database located at server A and setup the Oracle ... When I run the perl script, ...
    (perl.dbi.users)
  • Re: sanitizing uploaded data with a form
    ... i'm escaping quotes for the database, but i wasn't sure what other ... If the script is to display them, ... especially someone else on the server, if you use a shared server and ... Shared Hosting, Reseller Hosting, Dedicated & Semi-Dedicated servers ...
    (alt.php)
Loading