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 : 25-09-2017
ORA-01170

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

  • ora-12030 : cannot create a fast refresh materialized view
  • ora-24060 : cannot convert QUEUE_TABLE, string already is compatible with release string
  • ora-02289 : sequence does not exist
  • ora-12487 : clearance labels not between DBHIGH and DBLOW
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-38486 : FUNCTION/PACKAGE/TYPE already exists for the attribute set
  • ora-01863 : the year is not supported for the current calendar
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • ora-01319 : Invalid Logminer session attribute
  • ora-26013 : List allocated may not be big enough
  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-16020 : less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
  • ora-23448 : duplicate user parameter value
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-30085 : syntax error was found in overlaps predicate
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-29890 : specified primary operator does not have an index context
  • ora-33429 : (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
  • ora-22991 : insufficient space allocated for argument string
  • ora-00482 : LMD* process terminated with error
  • ora-14058 : partition number string: INITRANS value must be less than MAXTRANS value
  • ora-12647 : Authentication required
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-02242 : no options specified for ALTER INDEX
  • ora-02302 : invalid or missing type name
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-00293 : control file out of sync with redo log
  • ora-30952 : illegal configuration of HTTP/HTTPS in xdbconfig.xml
  • ora-30488 : argument should be a function of expressions in PARTITION BY
  • 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.