ORA-01170: file not found 'string'

Cause : ALL datafiles and, if NORESETLOGS, ALL logfiles MUST be accessible by the process for CREATE CONTROLFILE.

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

The file specified probably contains a typing error. Double check command and the existance of all files and then resubmit.

update : 27-04-2017
ORA-01170

ORA-01170 - file not found 'string'
ORA-01170 - file not found 'string'

  • ora-07394 : unable to append string to text file
  • ora-06132 : NETTCP: access denied, wrong password
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-38767 : flashback retention target parameter mismatch
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-19288 : XP0017 - invalid number of arguments to function - string
  • ora-13185 : failed to generate initial HHCODE
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-28176 : incorrect certificate version
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-25218 : enqueue failed, delay must be zero for queue string.string
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-01697 : control file is for a clone database
  • ora-00364 : cannot write header to new log member
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-02728 : osnfop: access error on oracle executable
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-12731 : invalid collation class in regular expression
  • ora-25223 : user_data type used is not supported
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-16407 : Standby database is in the future of the archive log
  • ora-39113 : Unable to determine database version
  • ora-13026 : unknown element type for element string.string.string
  • ora-12157 : TNS:internal network communication error
  • ora-31639 : unexpected data found
  • 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.