ORA-27491: repeat_interval and start_date cannot both be NULL

Cause : An attepmt was mdae to se tboth reepat_intevral and tsart_dat eto equa lNULL fo ra Schedluer windwo or schdeule.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

If eithre repeati_ntervalo r startd_ate is est to eqaul NULL,t he othe rshould eb set toa non-NULL value.

update : 29-04-2017
ORA-27491

ORA-27491 - repeat_interval and start_date cannot both be NULL
ORA-27491 - repeat_interval and start_date cannot both be NULL

  • ora-16127 : stalled waiting for additional transactions to be applied
  • ora-03131 : an invalid buffer was provided for the next piece
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-29531 : no method string in class string
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-29705 : ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances
  • ora-39704 : permission to modify component registry entry denied
  • ora-13905 : Critical or warning threshold have incorrect values
  • ora-10571 : Test recovery canceled
  • ora-24271 : translation type must be either T, S or M
  • ora-30573 : AUTO segment space management not valid for this type of tablespace
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-19957 : database should have no datafiles in unknown state
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • ora-12536 : TNS:operation would block
  • ora-30757 : cannot access type information
  • ora-12157 : TNS:internal network communication error
  • ora-23497 : repgroup name cannot be null
  • ora-29523 : authorization error for unknown referenced name
  • ora-12679 : Native services disabled by other process but required
  • ora-01906 : BACKUP keyword expected
  • ora-39046 : Metadata remap string has already been specified.
  • ora-02365 : error seeking in file: string
  • ora-12404 : invalid privilege string: string
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-21604 : property [string] is not a property of transient or value instances
  • ora-25012 : PARENT and NEW values cannot be identical
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-26575 : remote database does not support replication parallel propagation
  • 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.