Monday, May 15, 2017

Additional space required is more than max allowed space for these datafiles - During 12c Upgrades

I was upgrading a 11gR2 database to 12.1.0.2, and faced following error during upgrade using DBUA:

Upgrade Storage Check  

 Disk space usage summary  
/opt/app/testdb/oradata01/ has enough space. 
Required space is 0 MB , available space is 380732 MB.  

Details: Space usage summary  Space usage reason: Upgrade  

Tablespace Name: SYSTEM 
Additional space required: 0MB Datafile: /opt/app/testdb/oradata01/testdb/system_01.dbf Auto Extensible: No  

Tablespace Name: SYSAUX 
Additional space required: 0MB Datafile: /opt/app/testdb/oradata01/testdb/sysaux_01.dbf Auto Extensible: No  

Tablespace Name: UNDO 
Additional space required: 0MB Datafile: /opt/app/testdb/oradata01/testdb/undo_01.dbf Auto Extensible: Yes  

Tablespace Name: TEMP 
Additional space required: 0MB Datafile: /opt/app/testdb/oradata01/testdb/temp_01.dbf Auto Extensible: Yes  

Disk space usage summary  
/opt/app/testdb/oradata01/ has enough space. 
Required space is 0 MB , available space is 380732 MB.  

Additional space required is more than max allowed space for these datafiles  

Tablespace Name: 
TEMP Datafile: /opt/app/testdb/oradata01/testdb/temp_01.dbf 
Additional space required: 0 MB 
Maximum allowed space on datafile: -27647 MB  

This is because the maximum value of the datafile is being shown with a lower value than required and the solution for this error is to increase the maxsize limit (MaxBytes) to a value greater than the datafile size.

Example :
alter database tempfile '/opt/app/testdb/oradata01/testdb/temp_01.dbf' autoextend on next 10M maxsize 32767M; 

And then reprocess the DBUA:

Hope this resolves your issue!!


2 comments:

  1. Thank you Zaaker!
    Go* bless you.
    Basy

    ReplyDelete
  2. Mines reported -3380. just could not figure out the minus number.
    1* select file_name,BYTES/1048576,MAXBYTES/1048576,(MAXBYTES/1048576 - BYTES/1048576) short from dba_data_files where file_name like '%data101%'
    SQL> /

    FILE_NAME
    --------------------------------------------------------------------------------
    BYTES/1048576 MAXBYTES/1048576 SHORT
    ------------- ---------------- ----------
    /oracle/oradata10g/PDM1/dbf/data101.dbf
    8500 5120 -3380
    Fix:
    SQL> alter database datafile '/oracle/oradata10g/PDM1/dbf/data101.dbf' autoextend on maxsize 9000M;
    Anyway, great post. I was tearing my hair out on that message.
    Peter

    ReplyDelete