-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|