jueves, 21 de octubre de 2021

How to create a database with dbca in silent mode

From time to time I have been asked to create empty databases that take advantage of the patches already applied and also disabling components that the customer is not planning to use, this is very useful to avoid any usage of a component that is no licensed and it's not planned to be licensed. It's better to be safe and disable those components since the beginning. 

The following command will create an empty database, using scripts, not a template, so that the database will take advantage of all the patches already installed on the homes. Also will disable all the database components and it will be created with no archive mode. This command applies for Oracle Database 19c:

 

dbca -silent -createDatabase  -templateName New_Database.dbt -gdbname orcl -sid orcl -responseFile NO_VALUE -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16  -sysPassword Manager1 -systemPassword Manager1 -createAsContainerDatabase false -databaseType MULTIPURPOSE -memoryMgmtType auto_sga -totalMemory 78848 -storageType ASM -datafileDestination +DATA -databaseConfigType single  -redoLogFileSize 1024 -enableArchive false -emConfiguration NONE -dbOptions IMEDIA:false,CWMLITE:false,SAMPLE_SCHEMA:false,ORACLE_TEXT:false,APEX:false,OMS:false,DV:false,JSERVER:false,SPATIAL:false -ignorePreReqs 

Since this database will be created with scripts, it will take more time than if you were using a template.

No hay comentarios:

Publicar un comentario

Oracle ACE Director Award - Deiby Gómez

Thanks #OracleACE Program for this awesome certificate recognizing the work I have done in the community for the last year. Looking forwa...