ORA-27045: unable to close the file

Cause : close system call failed, additional information indicates which function encountered the error

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

check errno

update : 25-06-2017
ORA-27045

ORA-27045 - unable to close the file
ORA-27045 - unable to close the file

  • ora-25182 : feature not currently available for index-organized tables
  • ora-04046 : results of compilation are too large to support
  • ora-19625 : error identifying file string
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-27035 : logical block size is invalid
  • ora-29389 : too many errors during validation
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-12202 : TNS:internal navigation error
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-31448 : invalid value for change_source
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-31652 : command response message was invalid type - detaching job
  • ora-24410 : scrollable cursor max size exceeded
  • ora-31073 : Resource not retrieved using path name
  • ora-00706 : error changing format of file 'string'
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-23609 : unable to find directory object for directory string
  • ora-19733 : COMPATIBLE parameter needs to be string or greater
  • ora-19002 : Missing XMLSchema URL
  • ora-13431 : GeoRaster metadata rasterType error
  • ora-09270 : szalloc: error allocating memory for security
  • ora-37122 : AW Session cache disabled
  • ora-02774 : Invalid request list latch time out value
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-32800 : internal error string
  • ora-16769 : the physical standby database is open read-only
  • ora-19740 : text is longer than string
  • 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.