RE: SYSTEM tablespace full after upgrade
Date: Mon, 9 Mar 2009 10:48:13 -0400
If you were able to add a datafile, then you have space. I suspect the old oracle 8 Data Dictionary is still allocating space.
The table could be at the max number of extents. If you could try and change it to max extents unlimited, the only caveat I have with that is that you shouldn't have to play with sys owned objects. Others can weigh in on that.
You have upgrade instructions and met all the pre upgrade requirements? Your going from 18.104.22.168 directly to 10.2.0.3... is this a multi step. (rhetorical question, not related to issue).
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Toth, Istvan 5 (GE Money)
Sent: Monday, March 09, 2009 8:42 AM
Subject: SYSTEM tablespace full after upgrade
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
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.
Thanks in advance.
IstvanReceived on Mon Mar 09 2009 - 09:48:13 CDT