Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g7N09fQ20393 for ; Thu, 22 Aug 2002 20:09:41 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id RAA59134; Thu, 22 Aug 2002 17:06:56 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004BDC7E; Thu, 22 Aug 2002 16:53:32 -0800 Message-ID: Date: Thu, 22 Aug 2002 16:53:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Steve Perry" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Steve Perry" Subject: Re: Shutdown Immediate Hanging Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0798_01C24A0D.A1FDCBB0" ------=_NextPart_000_0798_01C24A0D.A1FDCBB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Messagethanks.=20 I'll take a look at the notes. Steve ----- Original Message -----=20 From: Muqthar Ahmed=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, August 22, 2002 8:58 AM Subject: RE: Shutdown Immediate Hanging Steve, Recently I got same problem and I have resolved it. This will happen = if you setup INITIAL and NEXT extent size very small for TEMPORARY = tablespace. Look at the following information: http://metalink.oracle.com and look for the following DOC ID: DOC ID: 61997.1 DOC ID: 1076161.6 I created new LOCALLY MANAGED TEMPORARY tablespace which handles = better than DICTIONARY tablespace: CREATE TEMPORARY TABLESPACE temp TEMPFILE '/d05/oradata/prod/temp01.dbf' SIZE 2048M=20 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp; Muthar Ahmed DBA -----Original Message----- From: Steve Perry [mailto:sperry@sprynet.com] Sent: Wednesday, August 21, 2002 11:13 PM To: Multiple recipients of list ORACLE-L Subject: Shutdown Immediate Hanging I hope somebody can help me with this shutdown problem. There's 2 = questions unless: how to troubleshoot a stalled shutdown and the best = way to deal with it. #1 - Database hangs during shutdown We have several instances running 8.1.7.3 on Win2k and continue to = have intermittent shutdown problems. The shutdown never completes. Here's are the steps used to stop the database 1.) Stop the application servers 1.) run a kill session script to kill all remaining sessions except = the one running the script=20 2.) issue shutdown immediate and hope it shuts down. At this point, the database closes but it never dismounts. We never receive the "Completed: ALTER DATABASE DISMOUNT" Is there anything I can do to diagnose the problem at this point?=20 After 15 minutes, Arcserve backs up the files to tape (delay field = in arcserve job). After the backup is complete, the database startup script is run. The alert log says the startup is normal, but no connections are = allowed into the database. I either have to do a shutdown abort or stop the service and then I = can start the database. I wrote a script to detect the shutdown hangs that will page me, do = a shutdown abort, startup and then shutdown immediate (before the backup = job starts) There's not much I can do when it stalls and I don't mind running = the script if it won't corrupt my database. Is there a better way to handle this?=20 I checked metalink and opened a tar.=20 Oracle said it was a security dll issue with MS and that I should = change the scripts to shutdown the service instead of using svrmgrl or = sqlplus. That was fine until I realized that stopping the service will = do a shutdown immediate. If the database doesn't complete before the = ora__shutdown_timeout value, it does a shutdown abort (or = equivalent). Thanks, Steve ------=_NextPart_000_0798_01C24A0D.A1FDCBB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
thanks.
I'll take a look at the = notes.
 
Steve
----- Original Message -----
From:=20 Muqthar Ahmed =
Sent: Thursday, August 22, 2002 = 8:58=20 AM
Subject: RE: Shutdown Immediate = Hanging

Steve,
 
Recently I got same problem and I have resolved it.  = This will=20 happen if you setup INITIAL and NEXT extent size very small for = TEMPORARY=20 tablespace.  Look at the following = information:
     http://metalink.oracle.com and = look for=20 the following DOC ID:
     DOC ID: 61997.1
     DOC ID: = 1076161.6
 
I=20 created new LOCALLY MANAGED TEMPORARY tablespace which handles = better=20 than DICTIONARY tablespace:
 
     CREATE TEMPORARY TABLESPACE=20 temp
         TEMPFILE=20 '/d05/oradata/prod/temp01.dbf' SIZE 2048M 
         EXTENT = MANAGEMENT=20 LOCAL UNIFORM SIZE 1M;
    ALTER DATABASE DEFAULT TEMPORARY = TABLESPACE=20 temp;
 
Muthar Ahmed
DBA
-----Original Message-----
From: Steve Perry=20 [mailto:sperry@sprynet.com]
Sent: Wednesday, August 21, = 2002 11:13=20 PM
To: Multiple recipients of list = ORACLE-L
Subject:=20 Shutdown Immediate Hanging

I hope somebody can = help me with=20 this  shutdown problem. There's 2 questions unless: how to=20 troubleshoot a stalled shutdown and the best way to deal = with=20 it.
 
#1 - Database hangs = during=20 shutdown
We have several = instances running=20 8.1.7.3 on Win2k and continue to have intermittent shutdown=20 problems.
The shutdown never=20 completes.
Here's are the = steps used to stop=20 the database
1.) Stop the = application=20 servers
1.) run a kill = session script to=20 kill all remaining sessions except the one running the script =
2.) issue shutdown = immediate and=20 hope it shuts down.
 
At this point, the = database=20 closes but it never dismounts.
We never receive = the "Completed:=20 ALTER DATABASE DISMOUNT"
 
Is there anything I = can do to=20 diagnose the problem at this point?
 
After 15 minutes,=20 Arcserve backs up the files to tape (delay field in = arcserve=20 job).
After the backup is = complete, the=20 database startup script is run.
The alert log says = the startup is=20 normal, but no connections are allowed into the = database.
 
I either have to do = a shutdown=20 abort or stop the service and then I can start the = database.
I wrote a script to = detect the shutdown hangs that will page me, do a = shutdown=20 abort, startup and then shutdown immediate (before the backup = job=20 starts)
There's not much I = can do when it=20 stalls and I don't mind running the script if it won't corrupt my=20 database.
Is there a better = way to handle=20 this? 
 
I checked metalink = and opened a=20 tar.
Oracle said it was = a security dll=20 issue with MS and that I should change the scripts to shutdown the = service=20 instead of using svrmgrl or sqlplus. That was fine until I realized = that=20 stopping the service will do a shutdown immediate. If = the database=20 doesn't complete before the ora_<SID>_shutdown_timeout value, = it does=20 a shutdown abort (or equivalent).
 
Thanks,
Steve
------=_NextPart_000_0798_01C24A0D.A1FDCBB0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: sperry@sprynet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).