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: Oracle 7.3.3/Solaris Shutdown problem

Re: Oracle 7.3.3/Solaris Shutdown problem

From: Andrew Williamson <andrewweb_at_my-deja.com>
Date: Fri, 26 Nov 1999 17:03:16 -0000
Message-ID: <943635808.22694.0.nnrp-04.c30bdde2@news.demon.co.uk>


First try:

select osuser,username from v$session;

Anything other than oracle in there is a user (by and large). This way you can see exactly who's logged in.... and then 'shutdown immediate' to annoy them. It's not a bug in oracle code.

Dave <none_at_nowhere.nothere.oops> wrote in message news:81mc77$p88$1_at_lure.pipex.net...
> I have Oracle server running and I have shut down the database
> but it is just sitting there waiting and not shutting down.
> I assume it will not shut down until all user disconect.
> As far as I'm aware every user is disconected.
> Does anyone know what processes I can kill to get back
> control of the Server manager. Will it damage the database
> if I kill processes while it's trying to shut down.
> What will the name of the processes be.
>
>
>
> Any help appreciated.
> Dave
>
>
>
Received on Fri Nov 26 1999 - 11:03:16 CST

Original text of this message

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