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 : 24-07-2017
ORA-19274

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

  • ora-39144 : file name parameter must be specified and non-null
  • ora-19750 : change tracking file: 'string'
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-08454 : more than one S symbol specified in picture mask
  • ora-31071 : Invalid database username or GUID string
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-31485 : invalid database link
  • ora-10691 : Set background process core file type (Unix only)
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-00490 : PSP process terminated with error
  • ora-14073 : bootstrap table or cluster may not be truncated
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-19687 : SPFILE not found in backup set
  • ora-38959 : Failed to update block 0 to new version 10 format
  • ora-09948 : Process information label retrieval failed.
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-00060 : deadlock detected while waiting for resource
  • ora-12913 : Cannot create dictionary managed tablespace
  • ora-00408 : parameter string is set to TRUE
  • ora-12819 : missing options in PARALLEL clause
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-02362 : error closing file: string
  • ora-40261 : input data for model build contains negative values
  • ora-23459 : flavor string must contain "string"
  • ora-09943 : Allocation of memory for password list component failed.
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-02024 : database link not found
  • 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.