Re: Cold backup blues (UNIX)...

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1996/08/29
Message-ID: <502rmt$hqb_at_wabbit.its.uow.edu.au>#1/1

In article <4vvefp$snu_at_news.missouri.edu> James P. Cooper, pixel_at_yoda.coe.missouri.edu writes:
>This script has been working for a couple of months. But sometimes
>Oracle just doesn't shut down.

dbshut won't shut the RDBMS down if there are connections open; it only does a 'shutdown', not a 'shutdown immediate'.

You can either edit dbshut so that it does a 'shutdown immediate', or you can precede your call to dbshut with a script that closes any open database connections. (How you do the latter depends on whether you're using SQL*Net V1 or V2, and whether database clients are running on the server.)

I'm not sure that one approach has any advantages over the other, although changing dbshut is simplest, provided that you remember to do it again whenever you upgrade the RDBMS.

---

Copyright 1996 Phil Herring. This article may not be reproduced for profit.

---

Received on Thu Aug 29 1996 - 00:00:00 CEST