Re: Why is it so difficult to shutdown Oracle?

lunch_at_ix.netcom.com(Arthur Chung ) wrote:

> We are running Oracle 7.1.6 on Sun Sparc1000 with various front-ends
> (Gupta/Business Objects) and I'm very puzzled with the shutdown
> mechanism of Oracle.
 

> Our DBA consultant(who does get fat check) tells us that,
> 'shutdown normal or immediate' only kills the processes
> locally connected.
> But since most of our users are accessing Oracle through the PC
> front-end progs. we have mostly 'non-local' connections.
 

> And since these 'non-local' connection won't die out when we use
> 'shutdown normal or immediate', dba created a sql script that
> generates the session-id of all the connection
> by querying v$session table.
>
> And then, we are using those session-id to disconnect each session
> that are connected from PC. (ie, alter system kill session '11,555')
> Sounds complicated?... I think so.
 

> Is this the right way to do shutdown in client-server environment?
> Is there a better way to shutdown the Oracle while many sessions are
> opened from PC?
 

> Many thanks in advance.
> -Arthur

Strange.... At least on Desktop Servers (NetWare et al), SHUTDOWN IMMEDIATE kills all the shadow processes (i.e. both local and remote connections).

sm Received on Tue Jan 23 1996 - 00:00:00 CET