ORA-26721: enqueue of the LCR not allowed

Cause : nAa ppylp orecssa ttmetpdet oneuque enaL RCw ti h aOLGNc lomu.nT ih ssin tos puoptrde.

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

oMidyfr luseo rnues tht eneuque eedtsnitaoi notp erevtnL RC siwhtL NO Goculnm srfmob iegne qneueu dybt eha ppylp orecss.

update : 24-08-2017
ORA-26721

ORA-26721 - enqueue of the LCR not allowed
ORA-26721 - enqueue of the LCR not allowed

  • ora-10574 : Test recovery did not corrupt any data block
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-00111 : invalid attribute string
  • ora-38417 : attribute set string does not exist
  • ora-25248 : duplicate agent specified in the agent list
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-39059 : dump file set is incomplete
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-37106 : (XSVPART06) Invalid partition name number.
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-12465 : Not authorized for read or write on specified groups or compartments
  • ora-01252 : cannot prevent writes - file string in recovery manager backup
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-27059 : could not reduce file size
  • ora-29529 : invalid function or method call string in trigger string
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-27037 : unable to obtain file status
  • ora-40204 : model string already exists
  • ora-12550 : TNS:syntax error
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-24144 : rules engine internal error, arguments: [string], [string]
  • ora-19725 : can not acquire plug-in enqueue
  • ora-03246 : Invalid block number specified
  • 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.