ORA-01220: file based sort illegal before database is open

Cause : A query issued against a fixed table or view required a temporary segment for sorting before the database was open. Only in-memory sorts are supported before the database is open.

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

Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.

update : 20-08-2017

ORA-01220 - file based sort illegal before database is open
ORA-01220 - file based sort illegal before database is open

  • ora-02821 : Unable to read the requested number of blocks.
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • ora-31002 : Path name string is not a container
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-24763 : transaction operation cannot be completed now
  • ora-00437 : ORACLE feature is not licensed. Contact Oracle Corp. for assistance
  • ora-14123 : duplicate NOREVERSE clause
  • ora-22628 : OCIAnyData already constructed
  • ora-01909 : REUSE keyword expected
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-22296 : invalid ALTER TABLE option for conversion of LONG datatype to LOB
  • ora-29811 : missing STATISTICS keyword
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-01507 : database not mounted
  • ora-27077 : too many files open
  • ora-01665 : control file is not a standby control file
  • ora-24340 : cannot support more than 255 columns
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-27047 : unable to read the header block of file
  • ora-28047 : database is not a member of any enterprise domain in OID
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-32742 : Hang analysis initialize failed
  • ora-00361 : cannot remove last log member string for group string
  • ora-06530 : Reference to uninitialized composite
  • 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.