|
1. First take a backup of your database
2. Check the alert log.
You can find alert log at C:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG
if you dont find it use this command
SQL> SHOW PARAMETERS background_dump_dest
That will give you exact location of alert log.
3. Try to analyse alert log and find the possible cause of your error, If you cant makeout anything from alert log Try this
Start SQLPlus and logon as SYSDBA
SQL> SHUTDOWN ABORT
SQL> STARTUP NOMOUNT
SQL> ALTER DATABASE MOUNT
SQL> ALTER DATABASE OPEN
|