0

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?

2 Answers 2

0

dbca -silent ... -gdbname ${ORACLE_SID} -sid ${ORACLE_SID} ...

Is this creating a Pluggable database inside an already-existing Container database?

If so, then the Block Size is defined by the Container database (which is a "real" Oracle database) and not the Pluggable database (which is, effectively, a Tablespace on steroids).

2
0

Use the GUI (DBCA) in one of the test system and fill all the details you want to fill for the production environment. At the end there will be an option to export as a script or something similar.

The output will be a command which you can run on production and it will do the installation.

Otherwise use the Oracle documentation and find all the commands/options.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.