ORA-01089: immediate shutdown in progress.............
R. RoyalApr 17 2008 — edited Apr 17 2008Hi,
I've tried to stop Oracle service On windows 2000 server from control panel --> administrative tools ---> Services, but I can't stopping and now status is "stopping".
If I try to connect with sqlplus /nolog and after startup I get this error:
ORA-12560: TNS:protocol adapter error
If I try to connect with sqlplus system/manager@mysid I get this error:
ORA-01089: immediate shutdown in progress - no operations are permitted
These are my log:
"alert.log":
Thu Apr 17 14:41:33 2008
Thread 1 advanced to log sequence 81174
Current log# 3 seq# 81174 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO03.LOG
Thu Apr 17 15:07:37 2008
Thread 1 advanced to log sequence 81175
Current log# 1 seq# 81175 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO01.LOG
Thread 1 advanced to log sequence 81176
Current log# 2 seq# 81176 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO02.LOG
Thread 1 advanced to log sequence 81177
Current log# 3 seq# 81177 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO03.LOG
Thread 1 advanced to log sequence 81178
Current log# 1 seq# 81178 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO01.LOG
Thread 1 advanced to log sequence 81179
Current log# 2 seq# 81179 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO02.LOG
Thu Apr 17 15:31:14 2008
Thread 1 advanced to log sequence 81180
Current log# 3 seq# 81180 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO03.LOG
Thread 1 advanced to log sequence 81181
Current log# 1 seq# 81181 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO01.LOG
Thu Apr 17 15:31:33 2008
Thread 1 advanced to log sequence 81182
Current log# 2 seq# 81182 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO02.LOG
Thread 1 advanced to log sequence 81183
Current log# 3 seq# 81183 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO03.LOG
Thu Apr 17 15:34:17 2008
Thread 1 advanced to log sequence 81184
Current log# 1 seq# 81184 mem# 0: C:\ORACLE\ORADATA\IMM1\REDO01.LOG
Thu Apr 17 15:44:45 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 18
Thu Apr 17 15:49:54 2008
Active call for process 7524 user 'SYSTEM' program 'ORACLE.EXE'
SHUTDOWN: waiting for active calls to complete.
trc file:
Dump file c:\oracle\admin\imm1\udump\imm1_ora_7524.trc
Thu Apr 17 15:24:36 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: imm1
Redo thread mounted by this instance: 1
Oracle process number: 20
Windows thread id: 7524, image: ORACLE.EXE
*** 2008-04-17 15:24:36.000
*** SESSION ID:(23.597) 2008-04-17 15:24:36.000
Probe:read_pipe: receive failed, status 1
Probe:S:debug_loop: timeout. Action 1
Dump file c:\oracle\admin\imm1\udump\imm1_ora_7520.trc
Thu Apr 17 15:49:55 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: imm1
Redo thread mounted by this instance: 1
Oracle process number: 13
Windows thread id: 7520, image: ORACLE.EXE
*** SESSION ID:(15.22094) 2008-04-17 15:49:54.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 15:55:05.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 16:00:14.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 16:05:23.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 16:10:33.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 16:15:43.000
SHUTDOWN: waiting for active calls to complete.
*** 2008-04-17 16:20:52.000
SHUTDOWN: waiting for active calls to complete.
How can I shutdown e startup my oracle service?
Have you any idea?
Thanks in advance!