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 : 21-08-2017
ORA-12872

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

  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-38777 : database must not be started in any other instance.
  • ora-02796 : Done request is not in correct state
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-29360 : retry operation. Too much concurrent activity
  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-19274 : XQ0054 - variable initialization failed due to circularity
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-29544 : invalid type
  • ora-13826 : empty SQL profile not allowed for create or update SQL profile
  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-00313 : open failed for members of log group string of thread string
  • ora-39091 : unable to determine logical standby and streams status
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-16073 : archiving must be enabled
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-39726 : unsupported add/drop column operation on compressed tables
  • ora-25327 : Array size is invalid
  • ora-01197 : thread string only contains one log
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-28542 : Error in reading HS init file
  • ora-16258 : marking index unusable due to a constraint violation
  • ora-23370 : table string and table string are not shape equivalent (string)
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • 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.