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-1092 signalled during: alter database open

GKJoeNov 16 2009 — edited Nov 17 2009

Hi All,
I am actually trying to figure out the root cause of an issue with oracle 10g which was resolved already.

Oracle 10.2.0.2 on Solaris 10 SPARC

Oracle was running for a long time without any issues and recently instance aborted due server power failure . After that while trying to open the database, instance is getting terminated and below entries are left in alert log file.

ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Mon Nov 16 01:12:30 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 1066
ORA-1092 signalled during: alter database open...

Also found that many data dictionary views - all_objects, user_objects etc do not exist. Issue was resolved by starting in upgrade mode and ran catalog.sql and catporc.sql and database is opened..

Anyone faced this before? Just curios to know what might have caused this issue..

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2009

Added on Nov 16 2009

#general-database-discussions

2 comments

1,603 views