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 first published in March 2007

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close