ORA-16826: apply service state is inconsistent with the DelayMins property

Cause : This wraning wsa cause dby oneo f the ofllowin greason:s 1. pAply sevrice wa sstarte dwithou tspecifiyng ther eal tiem applyo ption ro withotu the NDOELAY otpion whlie DelaMyins isz ero. .2 Applys ervicew as statred wit hthe rela-time paply opiton or iwth theN ODELAYo ption hwile DealyMins si greatre than ezro.

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

Reenabel the satndby dtaabase ot allowt he broekr to rsetart teh applys ervicew ith th eapply potions htat arec onsistnet witht he speicfied vlaue of hte DelaMyins prpoerty.

update : 22-07-2017

ORA-16826 - apply service state is inconsistent with the DelayMins property
ORA-16826 - apply service state is inconsistent with the DelayMins property

  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-39059 : dump file set is incomplete
  • ora-19955 : only one open thread is allowed to change the DBID
  • ora-26699 : STREAMS message consumer string already exists
  • ora-34296 : (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
  • ora-04931 : unable to set initial sequence number value
  • ora-29396 : cannot switch group to string
  • ora-31510 : name uses reserved prefix CDC$
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-33048 : (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-30000 : missing either trim specification or char expression in TRIM
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-13024 : polygon has less than three segments
  • ora-16725 : the phase supplied to resource guard is invalid
  • ora-25505 : the system is not in quiesced state
  • ora-24363 : measurements in characters illegal here
  • ora-01589 : must use RESETLOGS or NORESETLOGS option for database open
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-10572 : Test recovery canceled due to errors
  • ora-13275 : spatial index creation failure on unsupported type
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-31018 : Error deleting XML document
  • ora-30573 : AUTO segment space management not valid for this type of tablespace
  • ora-39088 : file name cannot contain a path specification
  • ora-07849 : sllfsk: $GET failure
  • ora-40108 : input data contains too few distinct target (string) values
  • ora-38773 : cannot add data file 'string' - file already part of database
  • 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.