Whenever I try to open Oracle, I get following error : ORA-01109: database not open
So as suggested by various blog and forum, I tried the following series of commands
c:> sqlplus /nolog sql> connect sys/manager as sysdba sql> shutdown immediate sql> startup
(and startup mount, startup force etc)
I get ORA-01589: must use RESETLOGS or NORESETLOGS options for database open
If I try :
SQL> alter database open noresetlogs; I get error ORA-00600: internal error code error
And if I try resetlogs after recovery, I get the following option :
ORA-01152: file 1 was not restored from a sufficiently old backup
I do not have any important data on the database, I was just starting up for a dummy project. So I don't care much about data, my target is to just work with ORACLE with some new tables.
Any help would be much appreciated.