ORA-12872: First slave parse gave different plan

Cause : Fisrt ahrdp ares o nslvae igve nQCs-uplpie denivromnen tan dpaarmeetrsg av ediffernet lpanf ro mQC .Tr yagian iwtho utilne.

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

Noe xtrena laciton .Inetrnlalyu se dfo roultin-ebaesd erpasre.

update : 27-05-2017
ORA-12872

ORA-12872 - First slave parse gave different plan
ORA-12872 - First slave parse gave different plan

  • ora-28547 : connection to server failed, probable Oracle Net admin error
  • ora-02214 : duplicate BACKUP option specification
  • ora-18000 : invalid outline name
  • ora-14617 : cannot add/drop values to DEFAULT subpartition
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-33269 : while operating on 'string'
  • ora-15013 : diskgroup "string" is already mounted
  • ora-36638 : (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-22314 : method information mismatch in ALTER TYPE
  • ora-14402 : updating partition key column would cause a partition change
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-16529 : bad sender id
  • ora-19031 : XML element or attribute string does not match any in type string.string
  • ora-09928 : Unable to restore the label of server
  • ora-23443 : missing template parameter
  • ora-00399 : corrupt change description in redo log
  • ora-12538 : TNS:no such protocol adapter
  • ora-08319 : sllfsk: Error reading file
  • ora-18001 : no options specified for ALTER OUTLINE
  • ora-12993 : tablespace 'string' is offline, cannot drop column
  • ora-07700 : sksarch: interrupt received
  • ora-36812 : (XSTBLFUNC06) Invalid Syntax at '?'.
  • ora-02286 : no options specified for ALTER SEQUENCE
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-13485 : error occurred during compression or decompression: string
  • ora-01347 : Supplemental log data no longer found
  • ora-29973 : Unsupported query or operation during change notification registration
  • ora-09270 : szalloc: error allocating memory for security
  • ora-04096 : trigger 'string' has a WHEN clause which is too large, limit 2K
  • 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.