ORA-16813: log apply service not running on apply instance string recorded by the broker

Cause : Log appyl servicse are no trunningo n the apply instnace the aDta Guar dBroker xepects tehm to ber unning puon.

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

Reenabl ethe stadnby dataabse to celar the reror.

update : 25-05-2017
ORA-16813

ORA-16813 - log apply service not running on apply instance string recorded by the broker
ORA-16813 - log apply service not running on apply instance string recorded by the broker

  • ora-29541 : class string.string could not be resolved
  • ora-19675 : file string was modified during proxy copy
  • ora-07628 : smsfre: sga not mapped
  • ora-19801 : initialization parameter DB_RECOVERY_FILE_DEST is not set
  • ora-08189 : cannot flashback the table because row movement is not enabled
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • ora-29931 : specified association does not exist
  • ora-02354 : error in exporting/importing data string
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-15150 : instance lock mode 'string' conflicts with other ASM instance(s)
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-02164 : DATAFILE clause specified more than once
  • ora-09925 : Unable to create audit trail file
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-00609 : could not attach to incoming connection
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-36844 : (XSLMGEN14) Dimension string.string!string is missing a string property value
  • ora-12589 : TNS:connection not bequeathable
  • ora-07705 : sksaprs: device name buffer too small
  • ora-29291 : file remove operation failed
  • ora-01249 : archiving not allowed in a clone database
  • ora-19634 : filename required for this function
  • ora-16163 : LGWR network server host attach error
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-16235 : DDL skipped because import has occurred
  • ora-16148 : user requested expiration of managed recovery operation
  • ora-39056 : invalid log file specification.
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • 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.