ORA-29703: error occurred in global enqueue service operation

Cause : An nuexpcetede rro roccruredw hil eperofrmign a lgoba lenqeuue esrviec opreatino.

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

Chekc orcale rtacef ile sfore rrosr.

update : 25-09-2017
ORA-29703

ORA-29703 - error occurred in global enqueue service operation
ORA-29703 - error occurred in global enqueue service operation

  • ora-29840 : indextype and implementation type are not in same schema
  • ora-12714 : invalid national character set specified
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-14032 : partition bound of partition number string is too high
  • ora-31018 : Error deleting XML document
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-29257 : host string unknown
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-40002 : wordsize must be string or greater
  • ora-13440 : GeoRaster metadata compression type error
  • ora-16111 : log mining and apply setting up
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-36970 : (XSRELTBL12) workspace object must be a self-relation.
  • ora-19511 : Error received from media manager layer, error text: string
  • ora-24411 : Session pool already exists.
  • ora-02212 : duplicate PCTFREE option specification
  • ora-32145 : Environment not specified
  • ora-01622 : thread number must be specified - default not specific
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-00269 : specified log file is part of thread string not string
  • ora-13188 : cell decode failed
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-28037 : Cannot Get Session Key for RACF Authentication
  • ora-32135 : Cannot assign FILEs
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-07324 : smpall: malloc error while allocating pga.
  • ora-00068 : invalid value string for parameter string, must be between string and 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.