Estava atualizando um banco de dados 11g Enterprise Edition Release 11.2.0.2.0 para um 12.1.0.2, quando tive o seguinte erro durante a atualização:
Space usage reason: Upgrade Tablespace Name: SYSTEM Additional space required: 287MB Datafile: /ORACLE/TECHDATABASKET/base/dbs/system01.dbf Auto Extensible: Yes ... Disk space usage summary /ORACLE/TECHDATABASKET/archive/ has enough space. Required space is 2208 MB , available space is 29830 MB. / has enough space. Required space is 160 MB , available space is 28643 MB. /ORACLE/TECHDATABASKET/base/ has enough space. Required space is 287 MB , available space is 29830 MB. Additional space required is more than max allowed space for these datafiles Tablespace Name: SYSTEM Datafile: /ORACLE/TECHDATABASKET/base/dbs/system01.dbf Additional space required: 287 MB Maximum allowed space on datafile: 200 MB
Isto acontece porque o valor máximo do datafile está sendo mostrado com um valor menor do que o necessário e a solução para este erro é aumentar o limite de maxsize ( MAXBYTES ) para um valor maior que o tamanho do dafile.
Exemplo:
alter database datafile <diretorio do arquivo > autoextend ON maxsize <novo valor>; SQL> alter database datafile '/ORACLE/TECHDATABASKET/base/dbs/system01.dbf' autoextend on next 10M maxsize 1024M; Database altered.
E depois reprocessar o DBUA:
oracle:TECHDATABASKET:/applications/oracle/oracle_base/product/12.1.0.2/dbhome_1/bin > tail -f nohup.out Log files for the upgrade operation are located at: /applications/oracle/base/cfgtoollogs/dbua/TECHDATABASKET/upgrade3 Performing Pre Upgrade 4% complete 4% complete 20% complete Performing RDBMS Upgrade 20% complete 20% complete 21% complete 21% complete 22% complete 22% complete 22% complete 23% complete 23% complete 24% complete 24% complete 24% complete 25% complete 25% complete 26% complete 26% complete 26% complete 27% complete 27% complete 28% complete 28% complete 28% complete 29% complete 29% complete 30% complete 30% complete 30% complete 31% complete 31% complete 32% complete 32% complete 32% complete 33% complete 33% complete 34% complete 34% complete 34% complete 35% complete 35% complete 36% complete 36% complete 36% complete 37% complete 37% complete 38% complete 38% complete 38% complete 39% complete 39% complete 40% complete
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)