SYSTEM tablespace full after upgrade
- From: "Toth, Istvan 5 (GE Money)" <istvan5.toth@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Mar 2009 13:41:43 +0100
Hello list,
After upgraded 81740 to 102030 the SYSTEM tablespace get full, and after
the first restart i cannot start database with this error message.
Errors in file /mis/bbmis/admin/udump/tkarora_ora_7155.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.FIXED_OBJ$ by 2 in tablespace
SYSTEM
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 7155
ORA-1092 signalled during: alter database open...
I tried resize, add datafile and set up autoextend in mount state, but
doesn't work. I made a backup before the upgrade, but i try to avoid the
long tape recovery process.
Any idea?
Thanks in advance.
Regards
Istvan
Other related posts:
