Q

ORA-01092 error at startup

I'm getting the error "ORA-01092. Oracle instance terminated. Disconnection forced."

I have Oracle 10g installed on RHEL4. I've given the commands as follows:
sqlplus /NOLOG
>conn sys / as sysdba
sql> startup
I get "ORA-01092. Oracle instance terminated. Disconnection forced." But if I give startup mount then the database is being mounted.
The STARTUP MOUNT option does not access the database datafiles. It is when the database moves from the MOUNT stage to the OPEN stage that the datafiles are accessed for the first time. Something is happening in the move from MOUNT to OPEN to cause your Oracle instance to crash. Unfortunately, I can only guess what that problem would be. To know for sure, you would have to consult your Alert Log. When in MOUNT mode, issue the following command:
SHOW PARAMETER background_dump_dest
This will return a directory. Look in that directory for a file titled alert_sid.log (where sid is your ORACLE_SID). The Alert Log will contain error messages indicating the exact reason why your instance won't open.
This was last published in March 2007

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close