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-06-2017
ORA-19274

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

  • ora-00112 : value of string is null
  • ora-39601 : Hash key is required.
  • ora-25135 : cannot use the SINGLE TABLE option
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-02157 : no options specified for ALTER USER
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-08452 : specification of E in picture mask is unsupported
  • ora-03206 : maximum file size of (string) blocks in AUTOEXTEND clause is out of range
  • ora-10268 : Don't do forward coalesce when deleting extents
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-00208 : number of control file names exceeds limit of string
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-01936 : cannot specify owner when creating users or roles
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-32731 : Another Parallel Oradebug session is in progress
  • ora-31616 : unable to write to dump file "string"
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-09810 : Unable to get process ID from connection
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-01987 : client os username is too long
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-28333 : column is not encrypted
  • ora-31445 : invalid lock handle while acquiring lock on string
  • ora-32801 : invalid value string for string
  • ora-07213 : slgcs: times error, unable to get wall clock.
  • 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.