ORA-27419: unable to determine valid execution date from repeat interval

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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 23-06-2017
ORA-27419

ORA-27419 - unable to determine valid execution date from repeat interval
ORA-27419 - unable to determine valid execution date from repeat interval

  • ora-37113 : OLAP API initialization error: (string)
  • ora-13337 : failure in concatenating LRS polygons
  • ora-19666 : cannot do incremental restore of the control file
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-01949 : ROLE keyword expected
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-02267 : column type incompatible with referenced column type
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-12591 : TNS:event signal failure
  • ora-01598 : rollback segment 'string' is not online
  • ora-28009 : connection as SYS should be as SYSDBA or SYSOPER
  • ora-01110 : data file string: 'string'
  • ora-31652 : command response message was invalid type - detaching job
  • ora-39768 : only one direct path context top level column array is allowed
  • ora-23603 : STREAMS enqueue aborted due to low SGA
  • ora-19910 : can not change recovery target incarnation in control file
  • ora-12646 : Invalid value specified for boolean parameter
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-32017 : failure in updating SPFILE
  • ora-36720 : (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-02816 : Unable to kill a process
  • ora-29277 : invalid SMTP operation
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-16511 : messaging error using ksrget
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-34358 : (MXDSS14) number other users reading
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-00018 : maximum number of sessions exceeded
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.