ORA-1654 during alter database open
Posted on 2009-05-20
I have the RMAN backup of a 220.127.116.11 database, from a remote server.
I restored it. Applied archive logs.Then there was "alter database open resetlogs" which forced disconnection because the dbms on my solaris server is 10g.
Now I understand I need to upgrade my DB, and for that I need a STARTUP UPGRADE.
But my DB wont open - in any mode.
The error I get on my prompt is:
ORA-01092: ORACLE instance terminated. Disconnection forced
And my alert log and trc file say:
ORA-00604: error occurred at recursive SQL level 1
ORA-01654: unable to extend index SYS.I_FIXED_OBJ$_OBJ# by 2 in tablespace SYSTEM
Now I can see that I need to add space to SYSTEM tablespace, but how do I do that if my DB wont open :(
Any inputs are appreciated.