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

Valeriy Burmaka

I have the same error on Windows 10 Pro, Dell Precision 7810, 32 GB memory,
2 CPU x 8 Cores x 2 threads = 32 threads...

User_81UY9

any progress on your installation? @user-g0fb5-oracle@user-gmsnn

Is error occurring during the installation of XE, or after it is completed?
Did you receive an error during installation?

Valeriy Burmaka
ORA-00821 occurs during installation, and it is impossible to connect to the database
using sqlplus as sysdba "sqlplus / as sysdba".
User_81UY9

@christian-shay-oracle,I encountered during the installation and will not able to complete due to ORA-00821: Specified value of SGA_target 2096M is too small, needs to be atleast 2240M. I am installing on Windows 64 bit with 64gb of RAM.

User_81UY9

The problem is it won't allow me to create a database with more than 2GB RAM of PGA+SGA(Database Express limitation) but it won't allow me to create with too small SGA for shared pool size. I have 64GB of RAM in my machine, running MS Windows SQLServer 2019

Valeriy Burmaka

...product\21c\cfgtoollogs\dbca\XE\XE.log :
----------------------------------------------------------------------------------------------------------------
2022-01-24 22:01:34.262 CST ] Prepare for db operation
DBCA_PROGRESS : 7%
[ 2022-01-24 22:01:39.199 CST ] Copying database files
DBCA_PROGRESS : 8%
[ 2022-01-24 22:02:00.239 CST ] [WARNING] ORA-00821: Specified value of sga_target 1536M is too small, needs to be at least 1600M
ORA-01078: failure in processing system parameters
DBCA_PROGRESS : 9%
[ 2022-01-24 22:02:00.239 CST ] [FATAL] ORA-01034: ORACLE not available
... and so on ...

User_7CH7A

Any word on this? I have the exact same problem. Seems to be high-memory machines. I have Windows 10 Pro for Workstations... 32-core, 48GB RAM.

Valeriy Burmaka

/************************
** Solution was found: **
************************/

  1. "Start button" -> Find [Control Panel] -> [System Configuration] -> [Boot] folder.
  2. Click [Advanced Options...] button. In the form "Boot Advanced Options"
    check the "[ ] Number of processors " checkbox, then select number of CPUs (about 8). Save your changes.
    (Just in case - I selected 4 CPUs).
  3. Restart your PC.
  4. Install Oracle 21c XE database. Install process is to slow (took about 30 min), but without errors.
  5. When installation is done, check the services (using the command "lsnrctl status").
    Services "XE", "XEXDB", "XEPDB1" have to work.
  6. Go go [Advanced Options...] of your PC (see item#2) and UNCHECK the "[ ] Number of processors " checkbox. Save your changes.
  7. Restart your PC. Database will work as expected.
  8. Enjoy :)
User_YJECZ

@user-gmsnn THANK YOU!!! this worked for me. I have a ryzen 5950x with 16cores and I bumped it down to 4 for the install. The errors I was getting was mostly about TNS, but turns out the database wasnt installed correctly and the installer did not tell me.

Valeriy Burmaka

You are welcome ! :)

1 - 11

Post Details

Added on Jan 15 2022
11 comments
4,263 views