When either installing PITSS.CON in a new installation or performing a DB repository move, if you receive the following database error at the beginning of the installation:
“ORA-01552: cannot use system rollback segment for non-system tablespac” (NOTE: The installer window has the rest of the message cut off, but the rest says “…tablespace ‘TEMP’”)
It is likely that the UNDO_MANAGEMENT parameter is set to MANUAL in the database. You can check by running “show parameter undo_management” to see if it is set to MANUAL or AUTO. Also, the rollback segments could all be offline too (run “select segment_name, status from dba_rollback_segs” to see if all segments (excluding SYSTEM) are all offline). If that is the case, the parameter will need to be changed to AUTO. To do this, you can perform the following steps:
- Open up sqlplus as the sys user
- Run in SQLPLUS: alter system set undo_management=auto scope=spfile;
- Shutdown the database: shutdown immediate;
- Startup the database (open state): startup;
NOTE: If for any reason you are using an external pfile instead of the spfile, you will need to manually update the .ORA file associated with your database (example is INIT<SID>.ORA) by changing the parameter UNDO_MANAGEMENT from MANUAL to AUTO. Otherwise, step 2 may not work.
To confirm that undo_management is set to auto, run show parameter undo_management; to confirm that the parameter is set to AUTO:
Also, make sure that some of the rollback segments are in ONLINE mode (run select segment_name, status from dba_rollback_segs; in SQLPLUS)
Restart the PITSS.CON installation and you should be able to install it without a problem.
Reference: Oracle Support Note 949948.1
