can't run catalog.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: can't run catalog.sql

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well well, isnt the error quite descriptive?

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

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    pando,

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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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?

  5. #5
    Join Date
    Sep 2002
    Posts
    411
    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
  •  


Click Here to Expand Forum to Full Width