Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown hangon.
shutdown immediate rolls back user transactions, but it didn't kill user
sessions.
so it waits still so long, if all user are disconnected. Try this if you can:
startup the database;
login in sqlplus as any user on another task;
login as internal on another task and shutdown immediate;
-> the task of internal will wait for the user in sqlplus. it waits for the time when
the user querie a question. if the user did nothing, and stand only in the shell of
sqlplus, the shutdown process will wait.
have fun in this adventure !!
joerg
David Wang schrieb:
> Dear all,
>
> Yesterday, When I use the command -- shutdown immediate, the database is
> hangon for more than one hour. The database is very small even 100MB.
> Although I stop it by manually stop the basic service using the service icon
> in the control pane, I would like to know what is the reason and whether it
> will be damaged to my database, the following content is abstract from the
> trace file. Thanks for any responce to help me understand this trace file
> and the question I metioned,
>
> "
> Dump file D:\orant\RDBMS80\trace\ORA01844.TRC
> Thu Oct 26 08:27:59 2000
> ORACLE V8.0.5.0.0 - Production vsnsta=0
> vsnsql=c vsnxtr=3
> Windows NT V5.0, OS V8.147, CPU type 586
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> Windows NT V5.0, OS V8.147, CPU type 586
> Instance name: orcl
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 17
>
> pid: 734
>
> *** SESSION ID:(15.13) 2000.10.26.08.27.58.997
> SHUTDOWN: waiting for active calls to complete.
> *** 2000.10.26.08.33.02.954
> SHUTDOWN: waiting for active calls to complete.
> "
Received on Fri Oct 27 2000 - 02:00:05 CDT