Oracle-L: RE: dbshut script - shutdown or shutdown immediate

From: Stephen Murphy <SMurphy_at_uamail.albany.edu>
Date: Wed, 02 Apr 2003 09:48:51 -0800
Message-ID: <F001.00578504.20030402094851@fatcity.com>

We replace the simple shutdown command with:

	shutdown immediate
	startup restrict
	alter system switch logfile;
	host sleep 10
	shutdown immediate

We recently installed 9.2.0.2-64bit on AIX. As of that release, Oracle is still shipping dbshut with simply shutdown normal.

*---------------------------------------------------------------------------

*
  Stephen T. Murphy
  Manager, Database and Technical Support   ITS - University Applications Development   MSC-100
  The University at Albany, S.U.N.Y

  Albany,  New York    12222            
  Phone: (518) 437-4523     Fax: (518) 437-4540   
  MailTo: SMurphy_at_UAMail.Albany.EDU     AIM: SMurphy199

-----Original Message-----

Sent: Wednesday, April 02, 2003 11:19 AM To: Multiple recipients of list ORACLE-L

Yes, that should be a standard practice any time you perform an new Oracle install.
Otherwise, that database will problably always hang waiting for all sessions to
disconnect before completing the shutdown.

I believe the latest versions of Oracle have corrected that issue in the dbshut
script.

-----Original Message-----

Peter
Sent: Wednesday, April 02, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L

I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly.

Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is

	connect internal
	shutdown

Should I modify the script to "shutdown immediate" so that it kills any connections?

Environment is Oracle 8.1.7 /AIX 4.3.3.

Thanks,
Peter Schauss
Northrop Grumman Corporation
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Schauss, Peter
INET: pschauss_at_northropgrumman.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gary W. Parker
INET: garywp_at_ev1.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephen Murphy
INET: SMurphy_at_uamail.albany.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message