1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Error:ORA-01166: file number 288 is larger than MAXDATAFILES (100)

Discussion in 'General' started by GSM, Apr 19, 2010.

  1. GSM

    GSM Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    While upgrading database form 9.2.0.8.0 to 11g in upgrade phase(by DBUA Method), I got below error at 73%:

    /d01/oracle/proddata/sysaux01.dbf 11
    ORACLE instance shut down.
    ORACLE instance started.
    Total System Global Area 652877824 bytes
    Fixed Size 1315252 bytes
    Variable Size 469765708 bytes
    Database Buffers 167772160 bytes
    Redo Buffers 14024704 bytes
    Create controlfile reuse set database "PROD"
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01166: file number 288 is larger than MAXDATAFILES (100)
    ORA-01110: data file 288: '/u01/app/oracle/oradata/PROD/system10.dbf'
    ORA-01507: database not mounted

    Please how to resolve this error?

    Thanks
    Regards
    GSM
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You need to modify the create controlfile script for the database in question to increase the maxdatafiles parameter. I expect you didn't read the migration checklist to see what problems could occur and how to prevent them. Ideally you should have recreated the controlfile with the increased maxdatafiles value before you upgraded.
     
    GSM likes this.
  3. GSM

    GSM Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Thanks.

    Now how to increase maxdata files value before upgrade?Please gives details steps as I am not DBA & it will help to resolve the problem.

    Thanks
    Regards
    GSM
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You really need a DBA to do this for you.
     
  5. GSM

    GSM Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I means to say that I am fresher.

    Thanks
    Regards
    GSM
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You do know how to use 'alter database backup controlfile to trace' to generate a script to recreate your controlfile?
     
  7. GSM

    GSM Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Ok I have created controlfile by using 'alter database backup controlfile to trace' .I should create controlfile & make necessary change in MAXDATAFILES value then I should proceed for upgrade.

    Thanks
    Regards
    GSM
     
  8. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You need to change the generated script FIRST and then create the new controlfile.