ORA-01166: file number string is larger than string (string)

Cause : File mentioned in CREATE CONTROLFILE has a file number which is larger than that specified for MAXDATAFILES or MAXLOGFILES.

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

Increase the maximum specified on the command line.

update : 27-04-2017
ORA-01166

ORA-01166 - file number string is larger than string (string)
ORA-01166 - file number string is larger than string (string)

  • ora-00105 : too many dispatcher configurations
  • ora-39018 : master process received invalid message number string
  • ora-12453 : label string already exists
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-24126 : invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-12152 : TNS:unable to send break message
  • ora-09819 : Number exceeds maximum legal value
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-30678 : too many open connections
  • ora-16508 : channel handle not initialized
  • ora-12430 : invalid privilege number
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-29385 : cannot create plan directive from string to string
  • ora-19815 : WARNING: string of string bytes is string%% used, and has string remaining bytes available.
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-16603 : Data Guard broker detected a mismatch in configuration ID
  • ora-38791 : flashback did not start because file string was not in a valid incarnation
  • ora-01529 : error closing file 'string'
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-09788 : sllfrb: unable to read file.
  • ora-24787 : remote cursors must be closed before a call completes
  • ora-02233 : invalid CLOSE mode
  • ora-07610 : $GETJPIW failed in retrieving the user's MAC priviledges
  • ora-19112 : error raised during evaluation: string
  • ora-09838 : removeCallback: failure removing the callback port.
  • 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.