How to create a custom database with 32k block size via DBCA silent mode?

0 votes

2 answers

1421 views

oracle configuration installation oracle-19c

                          I am trying to create an Oracle 19c single instance (warehouse) with dbca silent mode. The problem is, when I try the command below, it gets a warning: "Ora-0058: DB_BLOCK_SIZE must be 8192 to mount this database (not 32768)". Rest of the lines are full of errors.

The command:

    dbca -silent -createDatabase -initparams db_block_size=32768 -templateName Data_Warehouse.dbc -gdbname ${ORACLE_SID} -sid  ${ORACLE_SID} -responseFile NO_VALUE  -characterSet WE8ISO8859P9  -sysPassword SysPassword1 -systemPassword SysPassword1    -databaseType DATA_WAREHOUSING  -memoryPercentage 40  -memoryMgmtType AUTO_SGA  -storageType FS -datafileDestination "${DATA_DIR}"  -redoLogFileSize 2048     -emConfiguration NONE   -ignorePreReqs

I assume this is because of the template I'm using. But I don't have any custom templates. Also I don't want to use GUI as I'm not going to have this option for certain reasons.

How can I fix the command so dbca won't fail?

Asked by postgresnewbie (127 rep)

Dec 15, 2021, 08:31 AM
Last activity: Feb 11, 2025, 05:03 PM

How to create a custom database with 32k block size via DBCA silent mode?

Related Questions