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!!
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!!