Answer / senthilora

Two of my jobs have failed with the same error.

They were using the following scheduled clauses:
'FREQ=HOURLY;BYMINUTE=0'.

I scheduled them to run for 3 days by setting up start_date
and end_date attribute of scheduler.

They ran successfully for every hours for 3 days and failed
on 3rd day when it reached the end_date (time).

I think, this error can be read as a alarm note to note that
the scheduler has reached the end_date and so the jobs which
are all using this scheduler will not be executed here after.

Regards

Answer / guest

Cause: The specified repeat interval contained conflicting
clauses that made it impossible to ever find a matching
date, e.g., 'FREQ=YEARLY;BYMONTH=FEB;BYMONTHDAY=31'.
Alternatively, the scheduler reached its maximum number of
attempts to try to find a valid execution date. This occurs
when theoretically there is a valid execution date far in
the future, but the scheduler took too many attempts to
determine this date.

Action: Remove the conflicting clauses, or simplify the
repeat interval so that it is easier to determine the next
execution date.

Please add more information about this Error

ORA-00081: address range [string, string) is not readable

1 Answers  

---

ORA-38481: ADT "string" is used for a dependent object.

1 Answers  

---

TNS-04087: Unable to shutdown atleast one of the gateways.

1 Answers  

---

ORA-28659: COMPRESS must be specified at object level first

1 Answers  

---

QSM-02145: GROUP BY clause is present but no aggregate functions are used

1 Answers  

---

ORA-27034: maximum length of ORACLE_SID exceeded

1 Answers  

---

ORA-13772: unexpected deadlock on "SQL Tuning Set" "string"

1 Answers  

---

ORA-01906: BACKUP keyword expected

1 Answers  

---

LPX-00606: Missing attribute '~1s' in element '~2S'.

1 Answers  

---

TNS-00240: Connection Manager: Logging is now ON

1 Answers  

---

ORA-00237: snapshot operation disallowed: controlfile newly created

1 Answers  

---

ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA

1 Answers  

---