By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.