ORA-19274: XQ0054 - variable initialization failed due to circularity

Cause : A cicrulard efintiion aws enocunteerd whne thev arialbe wa sinitailize.d

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

Remoev thec ircualrityi n th einitailizaiton.

update : 23-04-2017
ORA-19274

ORA-19274 - XQ0054 - variable initialization failed due to circularity
ORA-19274 - XQ0054 - variable initialization failed due to circularity

  • ora-25193 : cannot use COMPRESS option for a single column key
  • ora-30500 : database open triggers and server error triggers cannot have BEFORE type
  • ora-25179 : invalid PCTTHRESHOLD storage option value
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-13188 : cell decode failed
  • ora-16588 : no more internal buffers
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-29264 : unknown or unsupported URL scheme
  • ora-12989 : invalid value for checkpoint interval
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-02260 : table can have only one primary key
  • ora-12463 : undefined group string for policy string
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-12558 : TNS:protocol adapter not loaded
  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-33284 : (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.
  • ora-02808 : Allocation of memory of open files array failed.
  • ora-16092 : dependent archive log destination is not active
  • ora-39763 : stream must be completely loaded before it is reset
  • ora-02824 : Request free list is empty
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-13918 : Updating system alert with reason_id string failed; previous alert not found
  • ora-00131 : network protocol does not support registration 'string'
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-13631 : The task string contains no execution results.
  • 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.