Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE XE APEX 19.2 installation problem / ORA-12954

FischertDec 16 2019 — edited Dec 16 2019

During installation/upgrade APEX in ORACLE XE (XEPDB1) iget the following error - after a lot of lines showing OK

pastedImage_0.png

I'm sure there was no error upgrading to 19.1 and I' think I didn't reach the limits of ORACL XE.

Database show the following information:

pastedImage_1.png

Can anybody give me a hint were the point is and a howto solving the problem.

regards

Thorsten

This post has been answered by Fischert on Dec 16 2019
Jump to Answer

Comments

_AZ_

add space to SYSTEM.

double-check you are NOT installing into CDB

Fischert

Okay thank,

I checked it and can't add space to SYSTEm with the same ORA message.

How could I check if it is the CDB - if I login into XE (the CDB from my point of view) and run "select * from dba_pdbs;" I got this:

pastedImage_0.png

could you confirm that XEPDB1 is NOT the CDB?

MatthiasHoys

Did you execute:

ALTER SESSION SET CONTAINER=XEPDB1;

before starting with the upgrade?

Matthias

Fischert
Answer

After playing around with tablespace parameter APEX script is running nearly untill end

but i got the same error again but later and extending the SYSTEM tablespace is not possible

this is the SYSTEM tablespace definition - I would expext it autoextend untill 1 GB but it stop at 501 MB

pastedImage_0.png

May be the error message are the same oracle can't autoextend because 12 GB limit is reaches - any idear how to shrink or extend SYSTEM tabelespace?

I Think I found the problem some one extended the CDB Tablespace and it seems XE count this tablespace as part of the 12GB limit, taking it offline let me extend the sysem tablespace in PDB.

Thanks for the hint to SYSTEM

tablespace.

Marked as Answer by Fischert · Sep 27 2020
1 - 4

Post Details

Added on Dec 16 2019
4 comments
473 views