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 : 20-09-2017

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

  • ora-27017 : skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
  • ora-12687 : Credentials expired.
  • ora-28300 : No permission to read user entry in LDAP directory service.
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • ora-13457 : GeoRaster cell data error
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-19669 : proxy copy functions cannot be run on DISK channel
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-02202 : no more tables permitted in this cluster
  • ora-31509 : publication does not exist
  • ora-32015 : unable to restore SPFILE
  • ora-00166 : remote/local nesting level is too deep
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-12210 : TNS:error in finding Navigator data
  • ora-12229 : TNS:Interchange has no more free connections
  • ora-32055 : invalid file type
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-32320 : REFRESH FAST of "string"."string" unsupported after container table PMOPs
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-07200 : slsid: oracle_sid not set.
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-13602 : The specified parameter string is not valid for task or object string.
  • ora-14027 : only one PARTITION clause may be specified
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-24902 : invalid subscription name or name-length in subscription handle
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • 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.