Skip to Main Content

Oracle Database Express Edition (XE)

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 Database XE 21c cannot create database

User_81UY9Jan 15 2022

I am installing an Oracle Database XE 21c in Windows 64bit architecture. Youtube installation looks easy but mine did fail on database creation!
I am invoking a DBCA tool and I am encountering a memory configuration issue. Database XE max should be 2GB for both SGA and PGA but dbca does not allow me to continue with less than 2GB else it fails. And when I put more than 2GB, it will ask for more and says ORA-00821: Specified value of SGA_target 2096M is too small, needs to be atleast 2240M.
I need help, been working on this for quite a while. Thanks in advance.

Comments

goose29

You can find it all the sample datasets under SQL Workshop>>Utilities>>Sample Datasets.

image.png

nsuDev

Thanks for your answer User_1NHML but I am not looking for sample datasets. I am looking for the sample application supposedly found in the apps gallery called "Sample Database Application". It is not there or anywhere that I can find.

User_MF3EJ

Hi, if you are using apex 21.1, then you find some sample and starter applications on github or here: https://oracle.github.io/apex/#section-starter.
But there are only few apps not the whole gallery like in former versions ( like apex 18.x). You have to download and install the applications via apex appBuilder ( Import-Function).
I am also missing one app ( P-Track), it's a grate pity to see that all this nice starter apps are lost .
Anybody a clue to get P-Track for Apex 21.1?

regards

User_MF3EJ

Good morning,
If you want to use one of the former starter apps (Example P-Track) which is not hosted on GitHub for APEX 21.1,
then you have to install a prior Apex version "Example 18.x" and install your preferred Starter App from this version.

Hint came from Hilary ( thanks for the Hint :-))

regards Udo

nsuDev

Thanks User_MF3EJ.
Do you know if it is possible to switch to an older version on my free cloud oracle.apex.com account or do i have to download and install the older version locally (to my pc)?
Regards,
jr

User_2KJ92

The latest documentation for 21.1 directs you to the lab Introduction to JavaScript for APEX Developers. However, the lab requires you to have version 20.2 or lower. The required Sample Database Application used in the lab is not available in 21.1. So there is not currently a lab tutorial possible for anyone using the free cloud one as far as I can see. Seems like either the Sample Database Application should be added back into 21.1+ or the training lab documentation should be updated to use another app as an example that is available.

1 - 6

Post Details

Added on Jan 15 2022
11 comments
4,450 views