ORA-07238: slemcl: close error.

Cause : Unable to close file. Possible OS error.

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

Contact system administator. Check additional information for errno.

update : 24-05-2017
ORA-07238

ORA-07238 - slemcl: close error.
ORA-07238 - slemcl: close error.

  • ora-39309 : schema sync operation failed
  • ora-38403 : attribute set name may not be longer than 22 characters
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-02846 : Unkillable server
  • ora-16097 : ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
  • ora-07701 : sksatln: internal exception: output buffer too small
  • ora-38707 : Media recovery is not enabled.
  • ora-38467 : user cannot GRANT/REVOKE privileges to/from himself
  • ora-01866 : the datetime class is invalid
  • ora-23514 : invalid or incorrect number of arguments
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-24413 : Invalid number of sessions specified
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-27071 : unable to seek to desired position in file
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-22903 : MULTISET expression not allowed
  • ora-24414 : Only number sessions could be started.
  • ora-23542 : dependent object "string"."string" already registered
  • ora-15061 : ASM operation not supported [string]
  • ora-16655 : specified target standby database invalid
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-18009 : one or more outline system tables do not exist
  • ora-22850 : duplicate LOB storage option specificed
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-24120 : invalid string parameter passed to DBMS_REPAIR.string procedure
  • ora-02212 : duplicate PCTFREE option specification
  • ora-04053 : error occurred when validating remote object stringstringstringstringstring
  • 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.