We are running the same database version and OS version. This same=0D=0Apr=
oblem just recently started happening on one of our databases.=20=0D=0AWe d=
o the folowing=0D=0A=0D=0AShutdown immediate;=0D=0AStartup restrict;=0D=0AS=
hutdown;=0D=0A=0D=0AThe shutdown immediate was fine. However, the normal s=
hutdown was=0D=0Agenerating the 1013 error. From what I could tell, a user=
with dba=0D=0Arights was connecting while the database was in restrict mod=
e. I=0D=0Amodified the script so that it locks that user's account prior t=
o the=0D=0Afirst shutdown. This seems to have fixed my problem.=0D=0A=0D=0A=
However, I'm not answering your question. I'm not sure what timeout=0D=0Av=
alue is used. Are these sessions executing some long running SQL=0D=0Acomm=
ands=3F Can they be rescheduled to run at another time=3F Years ago, I=0D=
=0Ahad an instructer tell me that for backups, just do the following:=0D=0A=0D=
=0Aalter system checkpoint;=0D=0Ashutdown abort;=0D=0AStartup restrict;=0D=0A=
Shutdown;=0D=0A=0D=0AWhile this definitely brings the database down, I neve=
r really felt=0D=0Acomfortable doing this. You might just want to kill act=
ive processes=0D=0Abefore you start your backup.=0D=0A=0D=0AJay=0D=0A=0D=0A=
-----Original Message-----=0D=0AFrom: oracle-l-bounce_at_freelists.org=0D=0A[m=
ailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vitalis=0D=0ASent: Thursd=
ay, April 14, 2005 9:45 AM=0D=0ATo: Oracle-L=0D=0ASubject: sqlplus shutdown=
"time-out"=0D=0A=0D=0AHi all,=0D=0A=0D=0A9.2.0.5.0 on Aix 5L.=0D=0ABefore =
our cold RMAN backups, we shutdown and startup the instances as=0D=0Afoll=3D=0D=
=0Aows:=0D=0A=0D=0Asqlplus '/ as sysdba' <<EOD=0D=0Ashutdown immediate=0D=0A=
startup=0D=0Ashutdown immediate=0D=0Astartup mount=0D=0AEOD=0D=0A=0D=0ASome=
times both shutdowns seem to time-out automatically (certainly while=0D=0AO=
racle is busy rolling back some huge transactions):=0D=0A=0D=0A=3D3D=3D3D> =
Beginning consistent instance shutdown and mount: Thu Apr 14=0D=0A01:35:02 =
DFT 2005=0D=0A=0D=0ASQL*Plus: Release 9.2.0.5.0 - Production on Thu Apr 14 =
01:35:02 2005=0D=0A=0D=0ACopyright (c) 1982, 2002, Oracle Corporation. All=
rights reserved.=0D=0A=0D=0A=0D=0AConnected to:=0D=0AOracle9i Enterprise E=
dition Release 9.2.0.5.0 - 64bit Production With=0D=0Athe Partitioning, OLA=
P and Oracle Data Mining options JServer Release=0D=0A9.2.0.5.0 - Productio=
n=0D=0A=0D=0ASQL> ORA-01013: user requested cancel of current operation=0D=0A=
SQL> ORA-01081: cannot start already-running ORACLE - shut it down first=0D=
=0ASQL> ORA-01013: user requested cancel of current operation=0D=0ASQL> ORA=
-01081: cannot start already-running ORACLE - shut it down first=0D=0A=0D=0A=
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 -=0D=0A=
64bit Production=0D=0AWith the Partitioning, OLAP and Oracle Data Mining op=
tions JServer=0D=0ARelease 9.2.0.5.0 - Production =3D3D=3D3D> Ended consist=
ent instance=0D=0Ashutdown and mount: Thu Apr 14 03:37:55 D=3D FT 2005=0D=0A=0D=
=0ABoth "user requested cancel" aren't human actions and it seems that both=0D=
=0Ashutdowns time-out after 1 hour.=0D=0A=0D=0AWhat might be the cause of t=
hes time-outs giving that sql*net is not=0D=0Ainvolved and that sys's profi=
le is "default" (idle_time=3D3Dunlimited). I=0D=0Acan't find any relevant t=
ime-out parameter for sqlplus (only for=0D=0Aisqlplus).=0D=0A=0D=0ATIA,=0D=0A=
Jerome=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A**DISCLAIMER=0D=0AThis e-mail message a=
nd any files transmitted with it are intended for the use of the individual=
or entity to which they are addressed and may contain information that is =
privileged, proprietary and confidential. If you are not the intended recip=
ient, you may not use, copy or disclose to anyone the message or any inform=
ation contained in the message. If you have received this communication in =
error, please notify the sender and delete this e-mail message. The content=
s do not represent the opinion of D&E except to the extent that it relates =
to their official business.=0D=0A
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 19 2005 - 11:13:46 CDT
