By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
sqlplus /NOLOG >conn sys / as sysdba sql> startupI get "ORA-01092. Oracle instance terminated. Disconnection forced." But if I give startup mount then the database is being mounted.
SHOW PARAMETER background_dump_destThis 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.
Dig Deeper on Oracle error messages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.