Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBCA Ignoring Response Files Parameters

User_FVML9Dec 26 2016 — edited Jan 1 2017

Hi, I'm installing a single Oracle database using response file, however the dbca is ignoring some parameters.

I read the dbca documentation but there is no explicit syntax to create the database as I'm creating with response file.

For example, ARCHIVE_LOG=TRUE but the database does not start in archive log mode.

Do you have any documentation about parameters in response file that I can use?

The response file is:

##############################################################################

## ##

## DBCA response file ##

## ------------------ ##

## ##

## Specify values for the variables listed below to customize Oracle ##

## Database Configuration installation. ##

## ##

## Each variable is associated with a comment. The comment identifies the ##

## variable type. ##

## ##

## Please specify the values in the following format : ##

## Type : Example ##

## String : "<value>" ##

## Boolean : True or False ##

## Number : <numeric value> ##

## StringList : {"<value1>","<value2>"} ##

## ##

## Examples : ##

## 1. dbca -progress_only -responseFile <response file> ##

## Display a progress bar depicting progress of database creation ##

## process. ##

## ##

## 2. dbca -silent -responseFile <response file> ##

## Creates database silently. No user interface is displayed. ##

## ##

## 3. dbca -silent -createDatabase -cloneTemplate ##

## -responseFile <response file> ##

## Creates database silently with clone template. The template in ##

## responsefile is a clone template. ##

## ##

## 4. dbca -silent -deleteDatabase -responseFile <response file> ##

## Deletes database silently. ##

##############################################################################

[GENERAL]

RESPONSEFILE_VERSION = "12.1.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "DBORCL"

SID = "DBORCL"

TEMPLATENAME = "General_Purpose.dbc"

DATABASECONFTYPE = "SI"

SELECTED_LANGUAGES=en

ORACLE_HOSTNAME=terra

INVENTORY_LOCATION=/u01/app/oraInventory/

ORACLE_BASE=/u01/app/oracle/

ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oper

UNIX_GROUP_NAME=oinstall

############################################## PASSWORD ################################################

SYSPASSWORD = "oracle"

SYSTEMPASSWORD = "oracle"

DBSNMPPASSWORD = "oracle"

#ASMSNMP_PASSWORD="oracle"

############################################## PASSWORD ################################################

############################################## STORAGE ################################################

STORAGETYPE=FS

#DISKGROUPNAME=DATA

#RECOVERYGROUPNAME=DATA

CHARACTERSET = "US7ASCII"

NATIONALCHARACTERSET= "UTF8"

CONTROLFILE1="/u01/app/oracle/oradata/DBORCL/control01.ctl"

CONTROLFILE2="/u01/app/oracle/oradata/DBORCL/control02.ctl"

CONTROLFILE3="/u01/app/oracle/oradata/DBORCL/control03.ctl"

REDO_LOG1="/u01/app/oracle/oradata/DBORCL/redo01.ctl"

REDO_LOG2="/u01/app/oracle/oradata/DBORCL/redo02.ctl"

REDO_LOG3="/u01/app/oracle/oradata/DBORCL/redo03.ctl"

#REDO_LOG1_SIZE

#REDO_LOG2_SIZE

#REDO_LOG3_SIZE

REDOLOGFILESIZE=1024

ARCHIVE_LOG=TRUE

ARCHIVE_DESTINATION="/u01/app/oracle/fast_recovery_area/DBORCL/"

ARCHIVE_FORMAT="arch_%d_%t_%s.arc"

MAX_DATAFILES=1024

MAX_LOGMEMBERS=2

DATAFILEDESTINATION ="/u01/app/oracle/oradata/"

RECOVERYAREADESTINATION="/u01/app/oracle/fast_recovery_area/"

DB_RECOVERY_FILE_SIZE=51200m

############################################## STORAGE ################################################

############################################## PARAMETROS ################################################

#INITPARAMS ="sga_target=500m,sga_max_size=500m,control_file_record_keep_time=60,enable_ddl_logging=true,audit_sys_operations=true,session=400,pga_aggregate_target=20m,process=400"

SAMPLESCHEMA=TRUE

DATABASETYPE = "OLTP"

AUTOMATICMEMORYMANAGEMENT = "FALSE"

#TOTALMEMORY = "500"

MEMORYPERCENTAGE = "40"

#LISTENERS = "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=terra.localdomain)(PORT=1521)))"

FORCELOGGING=TRUE

COMPATIBLE="12.1.0.0"

#IFILE

############################################## PARAMETROS ################################################

############################################## TABLESPACE ################################################

[SYSTEM]

SIZE = 2048

#FILE_NAME = "/u01/app/oracle/oradata/DBORCL/system01.dbf"

INCREASE = 1

INITEXTENT = 65536

MINEXTENTS = 1

#NEXTEXTENT = 100

MAXEXTENT = 2147483645

UNLIMITEDEXTENT = False

AUTOEXTEND = True

AUTONEXT = 1024

MINIMUM_EXTENT = 64

[UNDOTBS1]

NAME="UNDOTBS1"

#FILE_NAME = "/u01/app/oracle/oradata/DBORCL/undotbs01.dbf"

SIZE=2048

INCREASE = 1

INITEXTENT = 65536

MINEXTENTS = 1

#NEXTEXTENT = 100

MAXEXTENT = 2147483645

UNLIMITEDEXTENT = False

AUTOEXTEND = True

AUTONEXT = 1024

MINIMUM_EXTENT = 64

RETENTION=GUARANTEE

[SYSAUX]

NAME="SYSAUX"

#FILE_NAME = "/u01/app/oracle/oradata/DBORCL/sysaux01.dbf"

SIZE=2048

INCREASE = 1

INITEXTENT = 65536

MINEXTENTS = 1

#NEXTEXTENT = 100

MAXEXTENT = 2147483645

UNLIMITEDEXTENT = False

AUTOEXTEND = True

AUTONEXT = 1024

MINIMUM_EXTENT = 64

[TEMP]

NAME = "TEMP"

SIZE = 2048

#FILE_NAME = "/u01/app/oracle/oradata/DBORCL/temp01.dbf"

INITEXTENT = 1048576

MINEXTENTS = 1

NEXTEXTENT = 1048576

AUTOEXTEND = TRUE

AUTONEXT = 1024

MINIMUM_EXTENT = 64

############################################## TABLESPACE ################################################

############################################## ENTERPRISE MANAGER ################################################

#SERVICEUSERPASSWORD = "password"

#EMCONFIGURATION = "DBEXPRESS"

#EMEXPRESSPORT = "5500"

#OMSHOST =

#OMSPORT =

#EMUSER =

#EMPASSWORD=

############################################## ENTERPRISE MANAGER ################################################

############################################## DATABASE VAULT ################################################

#DVCONFIGURATION = "false"

#DVOWNERNAME = ""

#DVOWNERPASSWORD = ""

#DVACCOUNTMANAGERNAME = ""

#DVACCOUNTMANAGERPASSWORD = ""

############################################## DATABASE VAULT ################################################

############################################## PDB DATABASE ################################################

#CREATEASCONTAINERDATABASE =

#NUMBEROFPDBS =

#PDBNAME =

#PDBADMINPASSWORD = ""

############################################## PDB DATABASE ################################################

############################################## RAC CONFIGURATION ################################################

#NODELIST=

#REGISTERWITHDIRSERVICE= TRUE

#RACONENODESERVICENAME =

#OLSCONFIGURATION = "false"

#RUNCVUCHECKS = FALSE

#POLICYMANAGED = "false"

#CREATESERVERPOOL = "false"

#SERVERPOOLNAME =

#CARDINALITY =

#FORCE = "false"

#PQPOOLNAME =

#PQCARDINALITY =

#oracle.install.db.CLUSTER_NODES=bcndb01,bcndb02

#oracle.install.db.racOneServiceName=

############################################## RAC CONFIGURATION ################################################

############################################## SECURITY CONFIGURATION ################################################

#OBFUSCATEDPASSWORDS = FALSE

#WALLETPASSWORD= "password"

############################################## SECURITY CONFIGURATION ################################################

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 29 2017

Added on Dec 26 2016

#general-database-discussions

19 comments

2,583 views