-
Title
Capture and reader existed with "ORA-01552" -
Description
Capture and reader existed with the following error:
Notice: ORA-01552: cannot use system rollback segment for non-system tablespace 'SPLEX_DATA01'. [sp_ordr(osp)/25266]
Error: Unexpected Oracle error: ORA-01552: cannot use system rollback segment for non-system tablespace 'SPLEX_DATA01'. in ../src/ordr/sp_ordr.c:1320 [sp_ordr(osp)/25266]
Process exited sp_ordr (for o.TEST) [pid = 25266] - exit(1)
Notice: ORA-01552: cannot use system rollback segment for non-system tablespace 'SPLEX_DATA01'. [sp_ocap(osp)/25346]
Error: Unexpected Oracle error: ORA-01552: cannot use system rollback segment for non-system tablespace 'SPLEX_DATA01'. in ../src/ocap/sp_ocap.c:986 [sp_ocap(osp)/25346]
Process exited sp_ocap (for o.TEST) [pid = 25346] - exit(1) -
Cause
Only system tablespace is created and online.
-
Resolution
Make sure there is at least one other rollback segment online.
User can check to see which rollback segment is available and online by issue the following command:
SQL> select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs;