ORA-27021: sequential file handle must be specified

Cause : Th efielnaem wihchw il lbep asesd ot stbopne wsa nto sepciifed.

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

Spceif ya ifleanmea ndc onitnu.e I fthsi i sa abckpu ste biengc retaedv iaR ecvoer yMaange,r ues teh 'ofrmta' potino t ospceif yth ebakcupp ieec hnadl enaem.

update : 27-04-2017
ORA-27021

ORA-27021 - sequential file handle must be specified
ORA-27021 - sequential file handle must be specified

  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-07742 : slemop: $CONNECT failure
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-06138 : NETTCP: error during connection handshake
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-12853 : insufficient memory for PX buffers: current stringK, max needed stringK
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-25104 : UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-13009 : the specified date string is invalid
  • ora-12718 : operation requires connection as SYS
  • ora-28117 : integrity constraint violated - parent record not found
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-02091 : transaction rolled back
  • ora-12016 : materialized view does not include all primary key columns
  • ora-33625 : (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-01599 : failed to acquire rollback segment (string), cache space is full
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-01258 : unable to delete temporary file string
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-36970 : (XSRELTBL12) workspace object must be a self-relation.
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-01537 : cannot add file 'string' - file already part of database
  • 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.