Re: Dealing with "orphaned" sessions

From: Paul Drake <paled_at_home.com>
Date: Sun, 03 Jun 2001 18:45:26 GMT
Message-ID: <3B1A8565.DC9D95D8@home.com>

Ed Stevens wrote:
>
> Subject: Dealing with "orphaned" sessions
>
> Platform: Oracle 8.0.5, Std. Ed.; Windows NT 4.0, sp6
>

Ed,

Have you checked for SNPn processes running? Both DBA_JOBS and Oracle Agent processs could keep a SHUTDOWN IMMEDIATE from closing the database.

Provided that you haven't left any tablespaces in backup mode, the SHUTDOWN ABORT/STARTUP RESTRICT/SHUTDOWN NORMAL should work - but you may be better off to startup mount, alter system set job_queue_processes=0, alter database open and then shutdown. (or open with a pfile that has job_queue_processes=0)

this may not be your problem - but could be.

Paul Received on Sun Jun 03 2001 - 13:45:26 CDT