can't run catalog.sql

[mike2000]

Jeff,

I got this error on the trace file



Redo thread mounted by this instance: 1

Oracle process number: 10

Windows thread id: 3552, image: ORACLE.EXE


*** 2003-03-29 11:45:57.453
*** SESSION ID:(9.3) 2003-03-29 11:45:57.171
error 1089 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_DDL", line 179
ORA-06512: at "SYS.DBMS_UTILITY", line 331
ORA-06512: at line 5


and I can't run catalog.sql in my database

please help

[pando]

well well, isnt the error quite descriptive?

ORA-01089: immediate shutdown in progress - no operations are permitted

[mike2000]

pando,

thanks for your responce, and it's very descriptive, but this trace was created when I shutdown the instanceusing shutdown immediate

[pando]

well, the topic says "cant run catalog.sql"

what that means to me is you are trying to run catalog.sql when instances is being bring down but now you say something else?

[mike2000]

sorry for the confusing!!!!

this is what happened,

I upgrade the server from 8.1.7.3 to 8.1.7.4 on nt this morning, I have 5 instance on this server. three of them ran great and everything is working fine except for this isntance. when I tried to run catalog.sql it's hang there and not doing anything so I shutdown the database and look into the log file I found

Beginning crash recovery of 1 threads
Sat Mar 29 11:44:59 2003
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2918 Reading mem 0
Mem# 0 errs 0: F:\ORADATA\PROD\LOG2PROD_A.RDO
Mem# 1 errs 0: F:\ORADATA\PROD\LOG2PROD_B.RDO
Sat Mar 29 11:45:00 2003
Thread recovery: finish rolling forward thread 1
Thread recovery: 36 data blocks read, 31 data blocks written, 800 redo blocks read
Crash recovery completed successfully
Sat Mar 29 11:45:02 2003
Thread 1 advanced to log sequence 2919
Thread 1 opened at log sequence 2919
Current log# 3 seq# 2919 mem# 0: F:\ORADATA\PROD\LOG3PROD_A.RDO
Current log# 3 seq# 2919 mem# 1: F:\ORADATA\PROD\LOG3PROD_B.RDO
Successful open of redo thread 1.
Sat Mar 29 11:45:03 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Mar 29 11:45:05 2003
Completed: ALTER DATABASE OPEN
Sat Mar 29 11:45:30 2003
Thread 1 advanced to log sequence 2920
Current log# 1 seq# 2920 mem# 0: F:\ORADATA\PROD\LOG1PROD_A.RDO
Current log# 1 seq# 2920 mem# 1: F:\ORADATA\PROD\LOG1PROD_B.RDO
Thread 1 advanced to log sequence 2921
Current log# 2 seq# 2921 mem# 0: F:\ORADATA\PROD\LOG2PROD_A.RDO
Current log# 2 seq# 2921 mem# 1: F:\ORADATA\PROD\LOG2PROD_B.RDO
Sat Mar 29 11:45:57 2003



AND THE ERROR ON THE TRACE AS EARLIER POST,

CAN YOU GIVE ME SOME ADVISE???

THANKS