-
Title
Capture stopped due to ORA-01403 after Oracle upgrade -
Description
Capture is stopped due to error after Oracle upgrade (9i to 10g in this case) and the event log shows that it is stopped due to ORA-01403 as the following screen shots show:
sp_ctrl (wustd4107:2150)> show
Process Source Target State PID
---------- ------------------------ ------------ -------------------- ------
Capture o.w229u Stopped - due to error
Read o.w229u Running 27013
sp_ctrl (wustd4107:2150)> show log reverse
04/18/07 16:50 Process exited sp_ocap (for o.w229u) [pid = 27485] - exit(1)
04/18/07 16:50 Error: Unexpected Oracle error: ORA-01403: no data found. in sp_ocap.c:1758 [sp_ocap(osp)/27485]
04/18/07 16:50 Notice: ORA-01403: no data found. [sp_ocap(osp)/27485]
04/18/07 16:50 Notice: Oracle env - w229u:/opt/oracle/product/10.2.0.3 [sp_ocap(pdb)/27485]
04/18/07 16:50 Notice: FioSetEnsure: set redolog_ensure to 1 [sp_ocap/27485]
04/18/07 16:50 Notice: Capture log parser queue size is 100000 [sp_ocap/27485]
04/18/07 16:50 Process launched: sp_ocap (for o.w229u) [pid = 27485]
04/18/07 16:50 Logging user command: oracle start capture
04/18/07 16:43 Process exited sp_ocap (for o.w229u) [pid = 26987] - exit(1)
04/18/07 16:43 Error: Unexpected Oracle error: ORA-01403: no data found. in sp_ocap.c:1758 [sp_ocap(osp)/26987]
04/18/07 16:43 Notice: ORA-01403: no data found. [sp_ocap(osp)/26987]
04/18/07 16:43 Notice: Oracle env - w229u:/opt/oracle/product/10.2.0.3 [sp_ocap(pdb)/26987]
04/18/07 16:43 Process launched: sp_ordr (for o.w229u) [pid = 27013]
04/18/07 16:43 Notice: FioSetEnsure: set redolog_ensure to 1 [sp_ocap/26987]
04/18/07 16:43 Notice: Capture log parser queue size is 100000 [sp_ocap/26987]
event_log (15/32)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.