Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SHUTDOWN: waiting for logins to complete.

Re: SHUTDOWN: waiting for logins to complete.

From: Stuart Walker <swalker_at_westpac.com.au>
Date: Tue, 22 Sep 1998 13:16:49 +1000
Message-ID: <360716A0.128B@westpac.com.au>


No, this is another problem. There were no transactions taking place at the time. I believe the problem has to do with an Oracle client process being in an unstable state.

Stuart Walker
Westpac Banking Corp

John P. Higgins wrote:
>
> Shutdown immediate terminates all sessions and rolls back all current
> transactions. If a transaction had been updating for 30 minutes
> without a commit, it could take 30 minutes to roll back.
>
> Anyone have other ideas?
>
> Stuart Walker wrote:
>
> We're running Oracle 7.3.3.5.1, and got the above
> message(multiple
> times) when attempting to perform a shutdown immediate.
> This message
> appeared once in the alert log, and multiple times in a
> trace file for
> an Oracle client. Basically the shutdown took about 30
> minutes,
> eventhough there was no database activity. Any ideas?
>
> Regards,
>
> Stuart Walker
> Westpac Banking Corp
>
>
Received on Mon Sep 21 1998 - 22:16:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US