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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00821 Oracle 18c XE installation fails

user-gl1o3Apr 13 2023 — edited Apr 14 2023

Hello,

  1. I've downloaded DB from here - https://www.oracle.com/database/technologies/xe18c-downloads.html
  2. Installing it on Windows 11
  3. Installation is done without issues
  4. When trying to startup DB there are errors
  5. Also, there are errors in \18.0.0\cfgtoollogs\dbca\XE wich is I assume is installation logs
[ 2023-04-13 21:49:09.543 ALMT ] [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
[ 2023-04-13 21:49:09.544 ALMT ] [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
[ 2023-04-13 21:49:09.544 ALMT ] [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
[ 2023-04-13 21:49:09.796 ALMT ] Prepare for db operation
DBCA_PROGRESS : 7%
[ 2023-04-13 21:49:09.999 ALMT ] Copying database files
DBCA_PROGRESS : 8%
[ 2023-04-13 21:49:22.801 ALMT ] [WARNING] ORA-00821: Specified value of sga_target 1536M is too small, needs to be at least 1968M
ORA-01078: failure in processing system parameters

DBCA_PROGRESS : 9%
[ 2023-04-13 21:49:22.802 ALMT ] [FATAL] ORA-01034: ORACLE not available

DBCA_PROGRESS : 29%
DBCA_PROGRESS : 100%
[ 2023-04-13 21:49:22.807 ALMT ] [FATAL] ORA-01034: ORACLE not available

DBCA_PROGRESS : 7%
DBCA_PROGRESS : 0%

I assume I have issues because of ORA-00821 and as a result, installation doesn't go right.

I found that the issue may be because of the CPU and amount of cores on it (32 for mine), and sga_target calculated incorrectly and therefore leads to an error.

Could you please help me? I'm not that great with DB, so hard to figure it out. I've tried to install 21c XE but also got an error (though another one).

Comments

Post Details

Added on Apr 13 2023
3 comments
1,150 views