can't run catalog.sql

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

well well, isnt the error quite descriptive?

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

pando,

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

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?

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