Hello all, on my laptop I am trying to install Oracle express on a Windows 11 Home environment. I have downloaded the zip Oracle_express_21c and unzipped it.
On the site https://docs.oracle.com/en/database/oracle/oracle-database/21/xeinw/installing-oracle-database-xe.html it says what to do.
However, during installation I get an error message indicating to look in the cfgtoollogsdbca trace.log_2024-07-10.
Here it says as the last line
INFO: jul 10, 2024 4:20:02 PM oracle.assistants.dbca.driver.DBConfigDriverHelper updateSPFileLocation
INFO: Entering method.. updateSPFileLocation for updating the DBUNIQUENAME in spFileLocation location
[progressPage.flowWorker] [ 2024-07-10 16:20:02.715 CEST ] [InstallUtils.getOracleBase:489] OracleBase from orabase C:\app\vakan\product\21c
INFO: jul 10, 2024 4:20:02 PM oracle.assistants.dbca.driver.DBConfigDriverHelper constructLogAndMessageFile
INFO: Log Directory :C:\app\vakan\product\21c\cfgtoollogs\dbca
When I scroll back a bit I also come across the following frequently in the log file
INFO: jul 10, 2024 4:20:00 PM oracle.assistants.common.base.util.InitParamCollectionUtil getInitParam
INFO: Could not find the init param
Furthermore, I looked in 21c\cfgtoollogs\dbca\XE where there is also a log file XE1.log.
Here it states
[ 2024-07-10 16:20:02,896 CEST ] Prepare for db operation.
DBCA_PROGRESS : 7%
[ 2024-07-10 16:20:04.518 CEST ] Copying database files
DBCA_PROGRESS : 8%
[ 2024-07-10 16:23:20.754 CEST ] [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%
[ 2024-07-10 16:23:20.754 CEST ] [FATAL] ORA-01034: ORACLE not available
DBCA_PROGRESS : 29%
DBCA_PROGRESS : 100%
[ 2024-07-10 16:23:20.760 CEST ] [FATAL] ORA-01034: ORACLE not available
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 0%
Googled the text of sga_target and then came up with the page below
https://geraldonit.com/2022/06/14/ora-00821-specified-value-of-sga_target-is-too-small/
Finally created and modified the file myself and placed it in assistants/dbca/templates and named it XE_Database.dbc
<initParam name="sga_target" value="1600" unit="MB"/> -→ normaly 1536 value
Did another retry to complete the installation, but it still doesn't work.
Any advice is appreciated, many thanks in advance.