RE: Shutdown immediate hangs

Marco,

        I don't know if it is the best solution, but it works for us :

        We've had similar problems, mostly caused by Stored Procedures that had been started, but hadn't finished by the time the backup-script kicked in. Shutdown immediate apparantly waited for a PL/SQL-block to finish. Starting any new block would fail ...

        So now we do a shutdown abort - startup - shutdown immediate

        The shutdown abort makes sure every process that would prevent de DB from shutting

	Startup
	Shutdown immediate for thread recovery etc. ...

	Hope this helps.

	Greets,

   Kirsten

> -----Original Message-----
> From: Rooy van, Marco [SMTP:Rooy_M_at_sfs.nl]
> Sent: Thursday, October 19, 2000 8:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Shutdown immediate hangs
>
> Hi,
>
> Our environment is Alpha OpenVMS, Oracle 7.3.4 and we don't have
> Intelligent
> Agent running.
> One of the first things we do in our backup-job is a shutdown immediate.
> When I arrived in the office this morning it was still doing an shutdown
> immediate, normally it would finish this action 8 hours earlier.
> Has any of you have had this problem before and is shutdown abort the best
> action ?
>
> Best regards,
>
> Marco
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rooy van, Marco
> INET: Rooy_M_at_sfs.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Oct 19 2000 - 03:51:44 CDT