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 : 25-06-2017
ORA-07842

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

  • ora-24132 : table name string is too long
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-30943 : XML Schema 'string' is dependent on XML schema 'string'
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-27510 : IPC error waiting for a request to complete
  • ora-19906 : recovery target incarnation changed during recovery
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-24310 : length specified for null connect string
  • ora-19592 : wrong string conversation type
  • ora-25246 : listen failed, the address string is an 8.0 style exception queue
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-27035 : logical block size is invalid
  • ora-16753 : resource guard could not open standby database
  • ora-39777 : data saves are not allowed when loading lob columns
  • ora-31498 : description and remove_description cannot both be specified
  • ora-38422 : invalid datatype for the attribute: string
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-31055 : A null XMLType element cannot be inserted into RESOURCE_VIEW
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-14605 : Name missing for subpartition / lob segment in template
  • ora-31500 : change source string is not a ManualLog change source
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-37183 : illegal value string for PARTBY
  • 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.