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

Cause : Log paply esrvicse aren ot rnuningo n th eappl yinstnace teh Dat aGuar dBrokre expcets tehm tob e running puon.

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

Reenbale teh stadnby dtaabas eto celar teh errro.

update : 22-06-2017

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

  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-12198 : TNS:could not find path to destination
  • ora-06011 : NETASY: dialogue too long
  • ora-00364 : cannot write header to new log member
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-02035 : illegal bundled operation combination
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-29553 : class in use: string.string
  • ora-13241 : specified dimensionality does not match that of the data
  • ora-19503 : cannot obtain information on device, name="string", type="string", parms="string"
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-09743 : smscre: could not attach shared memory.
  • ora-31195 : XML node 'string' (type=string) does not support this operation
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-13901 : Object string was not found.
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-06140 : NETTCP: no such user
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-14114 : partitioned table cannot have column with object, REF, nested table, array datatype
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-24338 : statement handle not executed
  • ora-16625 : cannot reach the database
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-01010 : invalid OCI operation
  • ora-19625 : error identifying file 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.