Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01089: immediate shutdown in progress.............

R. RoyalApr 17 2008 — edited Apr 17 2008
Hi,
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2008
Added on Apr 17 2008
2 comments
3,123 views