Re: Why is it so difficult to shutdown Oracle?

Arthur Chung (lunch_at_ix.netcom.com) 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

That is odd. We run IBM RS6000 servers under AIX, and the shutdown immediate does just fine terminating the remote connections. As an alternative (at least under UNIX, you could terminate the SQLNET daemons, then do your shutdown or you could do a shutdown abort (then an immediate recover and shutdown normal...) Received on Thu Jan 25 1996 - 00:00:00 CET