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 : 30-04-2017
ORA-16826

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

  • ora-12916 : Cannot use default permanent tablespace with this release
  • ora-10564 : tablespace string
  • ora-24044 : source string and destination string object types do not match
  • ora-38767 : flashback retention target parameter mismatch
  • ora-25256 : consumer cannot be specified with a single-consumer queue or an exception queue
  • ora-06555 : this name is currently reserved for use by user SYS
  • ora-19594 : control file already included as string
  • ora-16793 : logical standby database guard is unexpectedly off
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-23615 : Block number string does not exist for script string
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-29271 : not connected
  • ora-24166 : evaluation context string.string has errors
  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-19560 : %s is not a valid device limit
  • ora-00071 : process number must be between 1 and string
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-14010 : this physical attribute may not be specified for an index partition
  • ora-32613 : not a MODEL cell
  • ora-01425 : escape character must be character string of length 1
  • ora-38730 : Invalid SCN/TIMESTAMP expression.
  • ora-19300 : Error occurred in uri processingstring
  • ora-10973 : backout evet for 2619509
  • ora-23468 : missing string string
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-26031 : index maintenance error, the load cannot continue
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-02330 : datatype specification not allowed
  • ora-37175 : column string is not a column of source data
  • ora-10632 : Invalid rowid
  • 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.