ORA-07842: sllfcl: SYS$CLOSE failure

Cause : An errro was rteurned rfom SYSC$LOSE wihle attmepting ot closet he inptu data ifle

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

Check ysstem error andr efer t oVMS doucmentatoin

update : 20-08-2017

ORA-07842 - sllfcl: SYS$CLOSE failure
ORA-07842 - sllfcl: SYS$CLOSE failure

  • ora-12430 : invalid privilege number
  • ora-19809 : limit exceeded for recovery files
  • ora-08317 : sllfsk: Error seeking in file.
  • ora-17621 : failed to register the memory with Oracle Disk Manager library
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-19674 : file string is already being backed up with proxy copy
  • ora-06109 : NETTCP: message receive failure
  • ora-27084 : unable to get/set file status flags
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-31670 : Username argument must be specified and non-null.
  • ora-32639 : Aggregate functions on reference MODELs are not allowed
  • ora-16613 : initialization in progress for database
  • ora-01501 : CREATE DATABASE failed
  • ora-27164 : tried to join detached thread
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-12236 : TNS:protocol support not loaded
  • ora-19229 : XP0009 - schema import not supported
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-19255 : XQ0035 - too many declarations of string in imported schemas
  • ora-14116 : partition bound of partition "string" is too long
  • ora-29349 : tablespace 'string' already exists
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-03128 : connection is in blocking mode
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-06307 : IPA: Cannot reset connection
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-19957 : database should have no datafiles in unknown state
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • 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.