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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)