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 : 23-08-2017
ORA-16214

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

  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-29824 : operator is invalid
  • ora-16958 : DML statements running parallel are not supported for test execute.
  • ora-19510 : failed to set size of string blocks for file "string" (blocksize=string)
  • ora-13048 : recursive SQL fetch error
  • ora-12153 : TNS:not connected
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-13411 : subset results in null data set
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-15108 : missing or invalid template name
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-16587 : ambiguous object specified to Data Guard broker
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-02021 : DDL operations are not allowed on a remote database
  • ora-26691 : operation not supported at non-Oracle system
  • ora-25212 : invalid PRIORITY specified when using sequence deviation
  • ora-09811 : Unable to initialize package.
  • ora-25118 : invalid DUMP DATAFILE/TEMPFILE option
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-29378 : invalid consumer group mapping priorities
  • ora-22884 : object modification failed
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-30439 : refresh of 'string.string' failed because of string
  • 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.