Skip to Main Content

Oracle Database Express Edition (XE)

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.

Post Details
Added on Jan 15 2022