Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
2 comments
481 views