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!!
Thank you Zaaker!
ReplyDeleteGo* bless you.
Basy
Mines reported -3380. just could not figure out the minus number.
ReplyDelete1* 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