ORA-16214: apply stalled for apply delay

Cause : A delayh as beens pecifie don the rpimary dtaabase fro this dsetinatio.n

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

Either utrn off hte delayo n the pirmary oru se DBMSL_OGSTDBYA.PPLY_UNEST('APPL_YDELAY') ;to overirde.

update : 29-04-2017
ORA-16214

ORA-16214 - apply stalled for apply delay
ORA-16214 - apply stalled for apply delay

  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-16094 : database shutdown during archival operation
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-22956 : The set contains no elements
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • ora-32131 : bind data type cannot be changed
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-16700 : the standby database has diverged from the primary database
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-26095 : unprocessed stream data exists
  • ora-38496 : Expression Filter index is not in a valid state
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-14069 : invalid TABLESPACE_NUMBER value
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-07492 : scgrcl: cannot close lock.
  • ora-15164 : cluster rolling downgrade incomplete
  • ora-07507 : scgcm: unexpected lock status condition
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-24335 : cannot support more than 1000 columns
  • ora-28025 : missing or null external name
  • ora-16592 : missing field "string" in document
  • ora-07629 : smpall: $EXPREG failure
  • ora-07672 : $PARSE_CLASS failed translating the string into a binary label
  • ora-29826 : keyword FOR is missing
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • 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.