UPGRADE 11G TO 12C: Additional space required is more than max allowed space for these datafiles

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

Related posts

Leave a Comment