This discussion is archived
1 Reply Latest reply: Oct 24, 2013 5:27 PM by Alvaro Branched to a new discussion. RSS

(oracle 10g) ORA-01403 comes in live system

946091 Newbie
Currently Being Moderated
(oracle 10g) ORA-01403 can be found in the trace files of process MMON,M000, CJQ0, it is not logged in alert log.

1. MMON (Every half an hour)

*** 2012-06-08 14:31:12.933
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
*** 2012-06-08 15:01:10.600
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN

2. M000 (once)
*** ACTION NAME:(Auto-Purge Slave Action) 2012-06-08 09:31:06.414
*** MODULE NAME:(MMON_SLAVE) 2012-06-08 09:31:06.414
*** SERVICE NAME:(SYS$BACKGROUND) 2012-06-08 09:31:06.414
*** SESSION ID:(829.36392) 2012-06-08 09:31:06.414
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN

3. CJQ0 (09:00 and 17:00, every day)
*** 2012-06-07 09:00:00.509
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
*** 2012-06-07 17:00:00.498
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN
*** 2012-06-08 09:00:00.613
KEWUFTSS: Error during schedule fetch for id: 0
KEWUFTSS: Error Message: ORA-01403: no data found
KEWUFTSS: No Maintainance Window schedule info available
KEWUFTSS: Auto Tasks will run in default mode without MWIN

Analysis
==========
[ORACLE Document]
ORA-01403 no data found
Cause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query.
Action: Terminate processing for the SELECT statement.

Question:
===========
1. What's the root cause of this fault?
2. It seems the following resolution can fix this problem, but I don't know what's catsvrm.sql using for and if we run it independtly(it is one part of catproc.sql), any impacts on live system?
1) No itme can be fetched with the condition schedule_id=0
select count(*) from WRI$_SCH_CONTROL where schedule_id=0;
0 rows selected
2) run catsvrm.sql
3) After step2, it seems be retrieved successfully, then ORA-01403 error messages disappear.
select count(*) from WRI$_SCH_CONTROL where schedule_id=0;
1 rows selected

Edited by: 943088 on Jun 27, 2012 3:03 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points