Oracle Database Commands and Practical Examples

Friday 14 June 2019

Install database DBCA using Response file oracle 12c R1 dbca.rsp

STEP 1 :

[oracle@srv1 database]$ cd response/
[oracle@srv1 response]$ ll
total 140
-rwxrwxr-x. 1 oracle oinstall 74822 Apr 4 2014 dbca.rsp
-rwxrwxr-x. 1 oracle oinstall 25171 Jun 14 17:28 db_install.rsp
-rwxr-xr-x. 1 oracle oinstall 25036 Jun 14 15:57 db_install.rsp_bkp
-rwxrwxr-x. 1 oracle oinstall 6038 Jan 24 2014 netca.rsp
[oracle@srv1 response]$ cp dbca.rsp dbca.rsp_bkp
[oracle@srv1 response]$

STEP 2 :

Make entry on dbca.rsp response file. (Check BOLD Text)

[root@srv1 oracle]# cat /u01/database/response/dbca.rsp

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

## ##

## 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 section is required for all types of database creations.

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

[GENERAL]

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

# Name : RESPONSEFILE_VERSION

# Datatype : String

# Description : Version of the database to create

# Valid values : "12.1.0"

# Default value : None

# Mandatory : Yes

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

RESPONSEFILE_VERSION = "12.1.0"

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

# Name : OPERATION_TYPE

# Datatype : String

# Description : Type of operation

# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase" \ "deletePluggableDatabase" \ "configurePluggableDatabase"

# Default value : None

# Mandatory : Yes

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

OPERATION_TYPE = "createDatabase"

#-----------------------*** End of GENERAL section ***------------------------

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

# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".

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

[CREATEDATABASE]

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

# Name : GDBNAME

# Datatype : String

# Description : Global database name of the database

# Valid values : <db_name>.<db_domain> - when database domain isn't NULL

# <db_name> - when database domain is NULL

# Default value : None

# Mandatory : Yes

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

GDBNAME = "smr1.example.com"

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

# Name : DATABASECONFTYPE

# Datatype : String

# Description : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database

# Valid values : SI\RAC\RACONENODE

# Default value : SI

# Mandatory : No

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

DATABASECONFTYPE = "SI"

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

# Name : RACONENODESERVICENAME

# Datatype : String

# Description : Service is required by application to connect to RAC One

# Node Database

# Valid values : Service Name

# Default value : None

# Mandatory : No [required in case DATABASECONFTYPE is set to RACONENODE ]

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

#RACONENODESERVICENAME =

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

# Name : POLICYMANAGED

# Datatype : Boolean

# Description : Set to true if Database is policy managed and

# set to false if Database is admin managed

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#POLICYMANAGED = "false"

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

# Name : CREATESERVERPOOL

# Datatype : Boolean

# Description : Set to true if new server pool need to be created for database

# if this option is specified then the newly created database

# will use this newly created serverpool.

# Multiple serverpoolname can not be specified for database

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#CREATESERVERPOOL = "false"

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

# Name : SERVERPOOLNAME

# Datatype : String

# Description : Only one serverpool name need to be specified

# if Create Server Pool option is specified.

# Comma-separated list of Serverpool names if db need to use

# multiple Server pool

# Valid values : ServerPool name

# Default value : None

# Mandatory : No [required in case of RAC service centric database]

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

#SERVERPOOLNAME =

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

# Name : CARDINALITY

# Datatype : Number

# Description : Specify Cardinality for create server pool operation

# Valid values : any positive Integer value

# Default value : Number of qualified nodes on cluster

# Mandatory : No [Required when a new serverpool need to be created]

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

#CARDINALITY =

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

# Name : FORCE

# Datatype : Boolean

# Description : Set to true if new server pool need to be created by force

# if this option is specified then the newly created serverpool

# will be assigned server even if no free servers are available.

# This may affect already running database.

# This flag can be specified for Admin managed as well as policy managed db.

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#FORCE = "false"

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

# Name : PQPOOLNAME

# Datatype : String

# Description : Only one serverpool name needs to be specified

# if create server pool option is specified.

# Comma-separated list of serverpool names if use

# server pool. This is required to

# create Parallel Query (PQ) database. Applicable to Big Cluster

# Valid values : Parallel Query (PQ) pool name

# Default value : None

# Mandatory : No [required in case of RAC service centric database]

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

#PQPOOLNAME =

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

# Name : PQCARDINALITY

# Datatype : Number

# Description : Specify Cardinality for create server pool operation.

# Applicable to Big Cluster

# Valid values : any positive Integer value

# Default value : Number of qualified nodes on cluster

# Mandatory : No [Required when a new serverpool need to be created]

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

#PQCARDINALITY =

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

# Name : SID

# Datatype : String

# Description : System identifier (SID) of the database

# Valid values : Check Oracle12c Administrator's Guide

# Default value : <db_name> specified in GDBNAME

# Mandatory : No

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

SID = "smr1"

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

# Name : CREATEASCONTAINERDATABASE

# Datatype : boolean

# Description : flag to create database as container database

# Valid values : Check Oracle12c Administrator's Guide

# Default value : false

# Mandatory : No

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

#CREATEASCONTAINERDATABASE =

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

# Name : NUMBEROFPDBS

# Datatype : Number

# Description : Specify the number of pdb to be created

# Valid values : 0 to 252

# Default value : 0

# Mandatory : No

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

#NUMBEROFPDBS =

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

# Name : PDBNAME

# Datatype : String

# Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#PDBNAME =

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

# Name : PDBADMINPASSWORD

# Datatype : String

# Description : PDB Administrator user password

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

# PDBADMINPASSWORD = ""

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

# Name : NODELIST

# Datatype : String

# Description : Comma-separated list of cluster nodes

# Valid values : Cluster node names

# Default value : None

# Mandatory : No (Yes for RAC database-centric database )

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

#NODELIST=

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

# Name : TEMPLATENAME

# Datatype : String

# Description : Name of the template

# Valid values : Template file name

# Default value : None

# Mandatory : Yes

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

TEMPLATENAME = "General_Purpose.dbc"

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

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#OBFUSCATEDPASSWORDS = FALSE

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

# Name : SYSPASSWORD

# Datatype : String

# Description : Password for SYS user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

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

SYSPASSWORD = "system123"

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

# Name : SYSTEMPASSWORD

# Datatype : String

# Description : Password for SYSTEM user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

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

SYSTEMPASSWORD = "system123"

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

# Name : SERVICEUSERPASSWORD

# Datatype : String

# Description : Password for Windows Service user

# Default value : None

# Mandatory : If Oracle home is installed with windows service user

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

#SERVICEUSERPASSWORD = "password"

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

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : CENTRAL|DBEXPRESS|ALL|NONE

# Default value : NONE

# Mandatory : No

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

EMCONFIGURATION = "NONE"

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

# Name : EMEXPRESSPORT

# Datatype : Number

# Description : Enterprise Manager Configuration Type

# Valid values : Check Oracle12c Administrator's Guide

# Default value : NONE

# Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable

# or auto generates a free port between 5500 and 5599

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

#EMEXPRESSPORT = ""

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

# Name : RUNCVUCHECKS

# Datatype : Boolean

# Description : Specify whether to run Cluster Verification Utility checks

# periodically in Cluster environment

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#RUNCVUCHECKS = FALSE

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

# Name : DBSNMPPASSWORD

# Datatype : String

# Description : Password for DBSNMP user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if EMCONFIGURATION is specified or

# the value of RUNCVUCHECKS is TRUE

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

DBSNMPPASSWORD = "system123"

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

# Name : OMSHOST

# Datatype : String

# Description : EM management server host name

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#OMSHOST =

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

# Name : OMSPORT

# Datatype : Number

# Description : EM management server port number

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#OMSPORT =

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

# Name : EMUSER

# Datatype : String

# Description : EM Admin username to add or modify targets

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#EMUSER =

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

# Name : EMPASSWORD

# Datatype : String

# Description : EM Admin user password

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#EMPASSWORD=

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

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#DVCONFIGURATION = "false"

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

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERNAME = ""

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

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERPASSWORD = ""

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

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERNAME = ""

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

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERPASSWORD = ""

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

# Name : OLSCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Label Security

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#OLSCONFIGURATION = "false"

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

# Name : DATAFILEJARLOCATION

# Datatype : String

# Description : Location of the data file jar

# Valid values : Directory containing compressed datafile jar

# Default value : None

# Mandatory : No

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

#DATAFILEJARLOCATION =

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

# Name : DATAFILEDESTINATION

# Datatype : String

# Description : Location of the data file's

# Valid values : Directory for all the database files

# Default value : $ORACLE_BASE/oradata

# Mandatory : No

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

DATAFILEDESTINATION =/u01/app/oracle/flash_recovery_area/smr1/oradata

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

# Name : RECOVERYAREADESTINATION

# Datatype : String

# Description : Location of the data file's

# Valid values : Recovery Area location

# Default value : $ORACLE_BASE/flash_recovery_area

# Mandatory : No

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

RECOVERYAREADESTINATION=/u01/app/oracle/flash_recovery_area/smr1

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

# Name : STORAGETYPE

# Datatype : String

# Description : Specifies the storage on which the database is to be created

# Valid values : FS (CFS for RAC), ASM

# Default value : FS

# Mandatory : No

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

STORAGETYPE=FS

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

# Name : DISKGROUPNAME

# Datatype : String

# Description : Specifies the disk group name for the storage

# Default value : DATA

# Mandatory : No

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

#DISKGROUPNAME=DATA

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

# Name : ASMSNMP_PASSWORD

# Datatype : String

# Description : Password for ASM Monitoring

# Default value : None

# Mandatory : No

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

#ASMSNMP_PASSWORD=""

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

# Name : RECOVERYGROUPNAME

# Datatype : String

# Description : Specifies the disk group name for the recovery area

# Default value : RECOVERY

# Mandatory : No

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

#RECOVERYGROUPNAME=RECOVERY

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

# Name : CHARACTERSET

# Datatype : String

# Description : Character set of the database

# Valid values : Check Oracle12c National Language Support Guide

# Default value : "US7ASCII"

# Mandatory : NO

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

CHARACTERSET = "US7ASCII"

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

# Name : NATIONALCHARACTERSET

# Datatype : String

# Description : National Character set of the database

# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide

# Default value : "AL16UTF16"

# Mandatory : No

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

#NATIONALCHARACTERSET= "UTF8"

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

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#REGISTERWITHDIRSERVICE= TRUE

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

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEUSERNAME= "name"

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

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEPASSWORD= "password"

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

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#WALLETPASSWORD= "password"

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

# Name : LISTENERS

# Datatype : String

# Description : Specifies list of listeners to register the database with.

# By default the database is configured for all the listeners specified in the

# $ORACLE_HOME/network/admin/listener.ora

# Valid values : The list should be comma separated like "listener1,listener2".

# Mandatory : NO

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

#LISTENERS = "listener1,listener2"

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

# Name : VARIABLESFILE

# Datatype : String

# Description : Location of the file containing variable value pair

# Valid values : A valid file-system file. The variable value pair format in this file

# is <variable>=<value>. Each pair should be in a new line.

# Default value : None

# Mandatory : NO

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

#VARIABLESFILE =

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

# Name : VARIABLES

# Datatype : String

# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates

# Default value : None

# Mandatory : NO

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

#VARIABLES =

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

# Name : INITPARAMS

# Datatype : String

# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates

# Default value : None

# Mandatory : NO

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

#INITPARAMS =

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

# Name : SAMPLESCHEMA

# Datatype : Boolean

# Description : Specifies whether or not to add the Sample Schemas to your database

# Valid values : TRUE \ FALSE

# Default value : FASLE

# Mandatory : No

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

SAMPLESCHEMA=TRUE

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

# Name : MEMORYPERCENTAGE

# Datatype : String

# Description : percentage of physical memory for Oracle

# Default value : None

# Mandatory : NO

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

MEMORYPERCENTAGE = "30"

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

# Name : DATABASETYPE

# Datatype : String

# Description : used for memory distribution when MEMORYPERCENTAGE specified

# Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP

# Default value : MULTIPURPOSE

# Mandatory : NO

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

#DATABASETYPE = "MULTIPURPOSE"

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

# Name : AUTOMATICMEMORYMANAGEMENT

# Datatype : Boolean

# Description : flag to indicate Automatic Memory Management is used

# Valid values : TRUE/FALSE

# Default value : TRUE

# Mandatory : NO

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

AUTOMATICMEMORYMANAGEMENT = "TRUE"

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

# Name : TOTALMEMORY

# Datatype : String

# Description : total memory in MB to allocate to Oracle

# Valid values :

# Default value :

# Mandatory : NO

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

#TOTALMEMORY = "800"

#-----------------------*** End of CREATEDATABASE section ***------------------------

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

# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".

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

[createTemplateFromDB]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database from which to create the template

# Valid values : The format is <host>:<port>:<sid>

# Default value : none

# Mandatory : YES

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

SOURCEDB = "myhost:1521:orcl"

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

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

SYSDBAUSERNAME = "system"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES

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

#SYSDBAPASSWORD = "password"

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

# Name : TEMPLATENAME

# Datatype : String

# Description : Name for the new template.

# Default value : None

# Mandatory : Yes

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

TEMPLATENAME = "My Copy TEMPLATE"

#-----------------------*** End of createTemplateFromDB section ***------------------------

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

# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".

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

[createCloneTemplate]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID from which to create the template.

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

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

#SYSDBAUSERNAME = "sys"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES

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

#SYSDBAPASSWORD = "password"

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

# Name : TEMPLATENAME

# Datatype : String

# Description : Name for the new template.

# Default value : None

# Mandatory : Yes

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

TEMPLATENAME = "My Clone TEMPLATE"

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

# Name : DATAFILEJARLOCATION

# Datatype : String

# Description : Location of the data file jar

# Valid values : Directory where the new compressed datafile jar will be placed

# Default value : $ORACLE_HOME/assistants/dbca/templates

# Mandatory : NO

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

#DATAFILEJARLOCATION =

#-----------------------*** End of createCloneTemplate section ***------------------------

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

# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".

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

[DELETEDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

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

#SYSDBAUSERNAME = "sys"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES, if no OS authentication

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

#SYSDBAPASSWORD = "password"

#-----------------------*** End of deleteDatabase section ***------------------------

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

# GENERATESCRIPTS section

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

[generateScripts]

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

# Name : TEMPLATENAME

# Datatype : String

# Description : Name of the template

# Valid values : Template name as seen in DBCA

# Default value : None

# Mandatory : Yes

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

TEMPLATENAME = "New Database"

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

# Name : GDBNAME

# Datatype : String

# Description : Global database name of the database

# Valid values : <db_name>.<db_domain> - when database domain isn't NULL

# <db_name> - when database domain is NULL

# Default value : None

# Mandatory : Yes

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

GDBNAME = "orcl12.us.oracle.com"

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

# Name : SCRIPTDESTINATION

# Datatype : String

# Description : Location of the scripts

# Valid values : Directory for all the scripts

# Default value : None

# Mandatory : No

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

#SCRIPTDESTINATION =

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

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : CENTRAL

# Default value : NONE

# Mandatory : No

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

#EMCONFIGURATION = "NONE"

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

# Name : OMSHOST

# Datatype : String

# Description : EM management server host name

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#OMSHOST =

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

# Name : OMSPORT

# Datatype : Number

# Description : EM management server port number

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#OMSPORT =

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

# Name : EMUSER

# Datatype : String

# Description : EM Admin username to add or modify targets

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#EMUSER =

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

# Name : EMPASSWORD

# Datatype : String

# Description : EM Admin user password

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

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

#EMPASSWORD=

#-----------------------*** End of deleteDatabase section ***------------------------

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

# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".

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

[CONFIGUREDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

#SOURCEDB = "orcl"

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

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

#SYSDBAUSERNAME = "sys"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES, if no OS authentication

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

#SYSDBAPASSWORD =

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

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#REGISTERWITHDIRSERVICE= TRUE

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

# Name : UNREGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to unregister with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#UNREGISTERWITHDIRSERVICE= TRUE

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

# Name : REGENERATEDBPASSWORD

# Datatype : Boolean

# Description : Specifies whether regenerate database password in OID/Wallet

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#REGENERATEDBPASSWORD= TRUE

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

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

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

#DIRSERVICEUSERNAME= "name"

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

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

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

#DIRSERVICEPASSWORD= "password"

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

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

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

#WALLETPASSWORD= "password"

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

# Name : ENABLESECURITYCONFIGURATION

# Datatype : String

# Description : Database Security Settings

# Valid values : true|false

# Default value : true

# Mandatory : No

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

#ENABLESECURITYCONFIGURATION = "true"

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

# Name : DBSNMPPASSWORD

# Datatype : String

# Description : Password for DBSNMP user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if EMCONFIGURATION is specified

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

#DBSNMPPASSWORD = "password"

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

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#DVCONFIGURATION = "false"

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

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERNAME = ""

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

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERPASSWORD = ""

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

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERNAME = ""

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

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------*** End of CONFIGUREDATABASE section ***------------------------

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

# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".

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

[ADDINSTANCE]

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

# Name : DB_UNIQUE_NAME

# Datatype : String

# Description : DB Unique Name of the RAC database

# Valid values : <db_unique_name>

# Default value : None

# Mandatory : Yes

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

DB_UNIQUE_NAME = "orcl12c.us.oracle.com"

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

# Name : INSTANCENAME

# Datatype : String

# Description : RAC instance name to be added

# Valid values : Check Oracle12c Administrator's Guide

# Default value : <sid_prefix>+<highest_current_thread+1>

# Mandatory : No

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

#INSTANCENAME = "orcl1"

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

# Name : NODENAME

# Datatype : String

# Description : Node on which to add new instance

# (in 10gR2, instance addition is supported on 1 node at a time)

# Valid values : Cluster node name

# Default value : None

# Mandatory : Yes

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

NODENAME=

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

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#OBFUSCATEDPASSWORDS = FALSE

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

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

SYSDBAUSERNAME = "sys"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# Default value : none

# Mandatory : YES

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

#SYSDBAPASSWORD = "password"

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

# Name : SERVICEUSERPASSWORD

# Datatype : String

# Description : Password for Windows Service user

# Default value : None

# Mandatory : If Oracle home is installed with windows service user

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

#SERVICEUSERPASSWORD = "password"

#-----------------------*** End of ADDINSTANCE section ***------------------------

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

# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".

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

[DELETEINSTANCE]

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

# Name : DB_UNIQUE_NAME

# Datatype : String

# Description : DB Unique Name of the RAC database

# Valid values : <db_unique_name>

# Default value : None

# Mandatory : Yes

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

DB_UNIQUE_NAME = "orcl12c.us.oracle.com"

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

# Name : INSTANCENAME

# Datatype : String

# Description : RAC instance name to be deleted

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

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

INSTANCENAME = "orcl12c"

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

# Name : NODENAME

# Datatype : String

# Description : Node on which instance to be deleted (SID) is located

# Valid values : Cluster node name

# Default value : None

# Mandatory : No

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

#NODENAME=

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

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

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

#OBFUSCATEDPASSWORDS = FALSE

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

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

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

SYSDBAUSERNAME = "sys"

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

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# Default value : none

# Mandatory : YES

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

#SYSDBAPASSWORD = "password"

#-----------------------*** End of DELETEINSTANCE section ***------------------------

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

# CREATEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "createPluggableDatabase".

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

[CREATEPLUGGABLEDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

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

PDBNAME = "PDB1"

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

# Name : CREATEASCLONE

# Datatype : Boolean

# Description : specify true or false for PDB to be create as Clone.

# : When "true" is passed a new PDB GUID is generated for the plugged in PDB

# Default value : true

# Mandatory : NO

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

# CREATEASCLONE = "TRUE"

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

# Name : CREATEPDBFROM

# Datatype : String

# Description : specify the source of pdb to be plugged

# Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML

# Default value : DEFAULT

# Mandatory : NO

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

# CREATEPDBFROM = "DEFAULT"

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

# Name : PDBARCHIVEFILE

# Datatype : String

# Description : Full path and name for pdbArchive file

# Default value : None

# Mandatory : Mandatory when creating new PDB using FILEARCHIVE

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

# PDBARCHIVEFILE = ""

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

# Name : PDBBACKUPFILE

# Datatype : String

# Description : Full path and name for pdb back up file

# Default value : None

# Mandatory : Mandatory when creating new PDB using RMANBACKUP

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

# PDBBACKUPFILE = ""

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

# Name : PDBMETADATAFILE

# Datatype : String

# Description : Full path and name for pdb metadata file

# Default value : None

# Mandatory : Mandatory when creating new PDB using RMANBACKUP or USINGXML

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

# PDBMETADATAFILE = ""

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

# Name : PDBUSEMULTIPLEBACKUP

# Datatype : boolean

# Description : Flag that can used to create PDB from single or multiple backupsets

# Default value : true

# Mandatory : Optional when creating new PDB using RMANBACKUP or USINGXML

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

# PDBUSEMULTIPLEBACKUP =

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

# Name : PDBADMINUSERNAME

# Datatype : String

# Description : PDB Administrator user name

# Default value : None

# Mandatory : Mandatory only when creating new DEFAULT PDB

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

# PDBADMINUSERNAME = ""

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

# Name : PDBADMINPASSWORD

# Datatype : String

# Description : PDB Administrator user password

# Default value : None

# Mandatory : Mandatory only when creating new DEFAULT PDB

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

# PDBADMINPASSWORD = ""

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

# Name : CREATENEWPDBADMINUSER

# Datatype : String

# Description : When Plugging a pdb from FILEARCHIVE or RMANBACKUP

# a new PDB Administrator user can be created using this option

# This option should be given along with pdbadmin username and password

# Default value : False

# Mandatory : NO

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

# CREATENEWPDBADMINUSER = ""

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

# Name : SOURCEFILENAMECONVERT

# Datatype : String

# Description : This clause specifies how to locate files listed in an XML file

# describing a Pluggable Database if they reside in a location different

# from that specified in the XML file.

# This clause is valid when creating Pluggable database in USINGXML option

# Valid values : (<filename_pattern>, <replacement_filename_pattern>,....)

# Default value : "NONE"

# Mandatory : NO

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

# SOURCEFILENAMECONVERT = ""

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

# Name : FILENAMECONVERT

# Datatype : String

# Description : This clause specifies how to generate names of files

# for the Pluggable Database being created using names of existing files

# This clause is valid when creating Pluggable database in USINGXML option

# Valid values : (<filename_pattern>, <replacement_filename_pattern>,....)

# Default value : "NONE"

# Mandatory : NO

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

# FILENAMECONVERT = ""

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

# Name : COPYPDBFILES

# Datatype : Boolean

# Description : If COPY is specified, it will indicate that datafiles need to be copied.

# : This option can be true only when FILENAMECONVERT is specified or

# CDB files are Oracle Managed Files(OMF)

# Valid values : TRUE \ FALSE

# Default value : False

# Mandatory : NO

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

# COPYPDBFILES = ""

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

# Name : PDBDATAFILEDESTINATION

# Datatype : String

# Description : common location for PDB datafile area

# Default value : None

# Mandatory : NO

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

# PDBDATAFILEDESTINATION = ""

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

# Name : USEMETADATAFILELOCATION

# Datatype : Boolean

# Description : Specify true if datafile path defined in Meta datafile within PDB

# archive file is to be used to un-archive datafile.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : NO

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

# USEMETADATAFILELOCATION = ""

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

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#REGISTERWITHDIRSERVICE= TRUE

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

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEUSERNAME= "name"

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

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEPASSWORD= "password"

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

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#WALLETPASSWORD= "password"

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

# Name : LBACSYSPASSWORD

# Datatype : String

# Description : Password for LBACSYS user

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService are TRUE

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

#LBACSYSPASSWORD= "password"

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

# Name : CREATEUSERTABLESPACE

# Datatype : Boolean

# Description : Specify true if a default user tablespace need to be created in new PDB

# Valid values : TRUE \ FALSE

# Default value : TRUE

# Mandatory : NO

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

# CREATEUSERTABLESPACE = ""

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

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#DVCONFIGURATION = "false"

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

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERNAME = ""

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

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERPASSWORD = ""

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

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERNAME = ""

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

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------*** End of createPluggableDatabase section ***------------------------

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

# UNPLUGDATABASE section is used when OPERATION_TYPE is defined as "unplugDatabase".

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

[UNPLUGDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

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

PDBNAME = "PDB1"

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

# Name : ARCHIVETYPE

# Datatype : String

# Description : The unplugged database datafile backup will in tar.gz or rman backup

# This pdb name must not be same as sourcedb name.

# Valid values : TAR | RMAN

# Default value : TAR

# Mandatory : NO

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

ARCHIVETYPE = "TAR"

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

# Name : PDBARCHIVEFILE

# Datatype : String

# Description : Full path and name for pdbArchive file

# Default value : None

# Mandatory : NO

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

# PDBARCHIVEFILE = ""

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

# Name : PDBBACKUPFILE

# Datatype : String

# Description : Full path and name for pdb back up file

# Default value : None

# Mandatory : No

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

# PDBBACKUPFILE = ""

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

# Name : PDBMETADATAFILE

# Datatype : String

# Description : Full path and name for pdb metadata file

# Default value : None

# Mandatory : No

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

# PDBMETADATAFILE = ""

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

# Name : UNREGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to unregister with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#UNREGISTERWITHDIRSERVICE= TRUE

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

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

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

#DIRSERVICEUSERNAME= "name"

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

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

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

#DIRSERVICEPASSWORD= "password"

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

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

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

#WALLETPASSWORD= "password"

#-----------------------*** End of unplugDatabase section ***------------------------

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

# DELETEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "deletePluggableDatabase".

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

[DELETEPLUGGABLEDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

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

PDBNAME = "PDB1"

#-----------------------*** End of deletePluggableDatabase section ***------------------------

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

# CONFIGUREPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "configurePluggableDatabase".

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

[CONFIGUREPLUGGABLEDATABASE]

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

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

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

SOURCEDB = "orcl"

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

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

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

PDBNAME = "PDB1"

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

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#DVCONFIGURATION = "false"

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

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERNAME = ""

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

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

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

#DVOWNERPASSWORD = ""

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

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERNAME = ""

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

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

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

#DVACCOUNTMANAGERPASSWORD = ""

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

# Name : OLSCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Label Security

# Valid values : True/False

# Default value : False

# Mandatory : No

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

#OLSCONFIGURATION = "false"

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

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

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

#REGISTERWITHDIRSERVICE= TRUE

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

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEUSERNAME= "name"

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

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#DIRSERVICEPASSWORD= "password"

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

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

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

#WALLETPASSWORD= "password"

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

# Name : LBACSYSPASSWORD

# Datatype : String

# Description : Password for LBACSYS user

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of olsConfiguration and registerWithDirService are TRUE

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

#LBACSYSPASSWORD= "password"

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

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : DBEXPRESS|NONE

# Default value : NONE

# Mandatory : No

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

#EMCONFIGURATION = "NONE"

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

# Name : EMEXPRESSPORT

# Datatype : Number

# Description : Enterprise Manager Configuration Type

# Valid values : Check Oracle12c Administrator's Guide

# Default value : NONE

# Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable

# or auto generates a free port between 5500 and 5599

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

#EMEXPRESSPORT = ""

#-----------------------*** End of configurePluggableDatabase section ***------------------------

[root@srv1 oracle]#

[oracle@srv1 bin]$ /u01/app/oracle/product/dbhome_1/bin/dbca -silent -responsefile /u01/database/response/dbca.rsp

Copying database files

1% complete

3% complete

11% complete

18% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

60% complete

61% complete

62% complete

65% complete

Completing Database Creation

69% complete

73% complete

76% complete

88% complete

99% complete

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/smr1/smr1.log" for further details.

[oracle@srv1 bin]$

[root@srv1 oracle]# tail -1000f "/u01/app/oracle/cfgtoollogs/dbca/smr1/smr1.log"

Unique database identifier check passed.

/ has enough space. Required space is 6140 MB , available space is 23191 MB.

File Validations Successful.

Copying database files

DBCA_PROGRESS : 1%

DBCA_PROGRESS : 3%

DBCA_PROGRESS : 11%

DBCA_PROGRESS : 18%

DBCA_PROGRESS : 37%

Creating and starting Oracle instance

DBCA_PROGRESS : 40%

DBCA_PROGRESS : 45%

DBCA_PROGRESS : 50%

DBCA_PROGRESS : 55%

DBCA_PROGRESS : 60%

DBCA_PROGRESS : 61%

DBCA_PROGRESS : 62%

DBCA_PROGRESS : 65%

Completing Database Creation

DBCA_PROGRESS : 69%

DBCA_PROGRESS : 73%

DBCA_PROGRESS : 76%

DBCA_PROGRESS : 88%

DBCA_PROGRESS : 99%

DBCA_PROGRESS : 100%

Database creation complete. For details check the logfiles at:

/u01/app/oracle/cfgtoollogs/dbca/smr1.

Database Information:

Global Database Name:smr1.example.com

System Identifier(SID):smr1

[oracle@srv1 bin]$ ps -ef |grep pmon
oracle 10166 1 0 18:22 ? 00:00:00 ora_pmon_smr1
oracle 10602 5600 0 18:40 pts/0 00:00:00 grep pmon
[oracle@srv1 bin]$

Install database software using Response file oracle 12c R1 db_install.rsp

STEP 1:
Go to response file folder.
[oracle@srv1 u01]$ cd database/
[oracle@srv1 database]$ ll
total 36
drwxrwxr-x. 4 oracle oinstall 4096 Jun 14 14:59 install
drwxrwxr-x. 2 oracle oinstall 4096 Jul 7 2014 response
drwxrwxr-x. 2 oracle oinstall 4096 Jul 7 2014 rpm
-rwxrwxr-x. 1 oracle oinstall 8533 Jul 7 2014 runInstaller
drwxrwxr-x. 2 oracle oinstall 4096 Jul 7 2014 sshsetup
drwxrwxr-x. 14 oracle oinstall 4096 Jul 7 2014 stage
-rwxrwxr-x. 1 oracle oinstall 500 Feb 7 2013 welcome.html
[oracle@srv1 database]$ cd response/
[oracle@srv1 response]$ ll
total 112
-rwxrwxr-x. 1 oracle oinstall 74822 Apr 4 2014 dbca.rsp
-rwxrwxr-x. 1 oracle oinstall 25036 Jul 7 2014 db_install.rsp
-rwxrwxr-x. 1 oracle oinstall 6038 Jan 24 2014 netca.rsp

Step 2 : Always make copy before changes.

[oracle@srv1 response]$ cp db_install.rsp db_install.rsp_bkp

Step 3 : Make Entry on db_install.rsp file

[oracle@srv1 response]$ vi db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=srv1.example.com

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en

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

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

DECLINE_SECURITY_UPDATES=true

[oracle@srv1 response]$ cat db_install.rsp

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

## ##

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

## your installation. ##

## ##

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

## can help to populate the variables with the appropriate ##

## values. ##

## ##

## IMPORTANT NOTE: This file contains plain text passwords and ##

## should be secured to have read permission only by oracle user ##

## or db administrator who owns this installation. ##

## ##

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

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

# Do not change the following system generated value.

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

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0

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

# Specify the installation option.

# It can be one of the following:

# - INSTALL_DB_SWONLY

# - INSTALL_DB_AND_CONFIG

# - UPGRADE_DB

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

oracle.install.option=INSTALL_DB_SWONLY

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

# Specify the hostname of the system as set during the install. It can be used

# to force the installation to use an alternative hostname rather than using the

# first hostname found on the system. (e.g., for systems with multiple hostnames

# and network interfaces)

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

ORACLE_HOSTNAME=srv1.example.com

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

# Specify the Unix group to be set for the inventory directory.

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

UNIX_GROUP_NAME=oinstall

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

# Specify the location which holds the inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

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

INVENTORY_LOCATION=/u01/app/oraInventory

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

# Specify the languages in which the components will be installed.

# en : English ja : Japanese

# fr : French ko : Korean

# ar : Arabic es : Latin American Spanish

# bn : Bengali lv : Latvian

# pt_BR: Brazilian Portuguese lt : Lithuanian

# bg : Bulgarian ms : Malay

# fr_CA: Canadian French es_MX: Mexican Spanish

# ca : Catalan no : Norwegian

# hr : Croatian pl : Polish

# cs : Czech pt : Portuguese

# da : Danish ro : Romanian

# nl : Dutch ru : Russian

# ar_EG: Egyptian zh_CN: Simplified Chinese

# en_GB: English (Great Britain) sk : Slovak

# et : Estonian sl : Slovenian

# fi : Finnish es_ES: Spanish

# de : German sv : Swedish

# el : Greek th : Thai

# iw : Hebrew zh_TW: Traditional Chinese

# hu : Hungarian tr : Turkish

# is : Icelandic uk : Ukrainian

# in : Indonesian vi : Vietnamese

# it : Italian

# all_langs : All languages

# Specify value as the following to select any of the languages.

# Example : SELECTED_LANGUAGES=en,fr,ja

# Specify value as the following to select all the languages.

# Example : SELECTED_LANGUAGES=all_langs

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

SELECTED_LANGUAGES=en

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

# Specify the complete path of the Oracle Home.

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

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

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

# Specify the complete path of the Oracle Base.

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

ORACLE_BASE=/u01/app/oracle

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

# Specify the installation edition of the component.

# The value should contain only one of these choices.

# - EE : Enterprise Edition

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

oracle.install.db.InstallEdition=EE

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

# #

# PRIVILEGED OPERATING SYSTEM GROUPS #

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

# Provide values for the OS groups to which OSDBA and OSOPER privileges #

# needs to be granted. If the install is being performed as a member of the #

# group "dba", then that will be used unless specified otherwise below. #

# #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System. #

# #

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

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

# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

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

oracle.install.db.DBA_GROUP=dba

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

# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

# The value to be specified for OSOPER group is optional.

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

oracle.install.db.OPER_GROUP=oinstall

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

# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.

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

oracle.install.db.BACKUPDBA_GROUP=dba

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

# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.

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

oracle.install.db.DGDBA_GROUP=dba

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

# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.

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

oracle.install.db.KMDBA_GROUP=dba

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

# #

# Grid Options #

# #

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

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

# Specify the type of Real Application Cluster Database

# - ADMIN_MANAGED: Admin-Managed

# - POLICY_MANAGED: Policy-Managed

# If left unspecified, default will be ADMIN_MANAGED

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

oracle.install.db.rac.configurationType=

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

# Value is required only if RAC database type is ADMIN_MANAGED

# Specify the cluster node names selected during the installation.

# Leaving it blank will result in install on local server only (Single Instance)

# Example : oracle.install.db.CLUSTER_NODES=node1,node2

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

oracle.install.db.CLUSTER_NODES=

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

# This variable is used to enable or disable RAC One Node install.

# - true : Value of RAC One Node service name is used.

# - false : Value of RAC One Node service name is not used.

# If left blank, it will be assumed to be false.

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

oracle.install.db.isRACOneInstall=

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

# Value is required only if oracle.install.db.isRACOneInstall is true.

# Specify the name for RAC One Node Service

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

oracle.install.db.racOneServiceName=

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

# Value is required only if RAC database type is POLICY_MANAGED

# Specify a name for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolName=pool1

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

oracle.install.db.rac.serverpoolName=

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

# Value is required only if RAC database type is POLICY_MANAGED

# Specify a number as cardinality for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolCardinality=2

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

oracle.install.db.rac.serverpoolCardinality=

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

# #

# Database Configuration Options #

# #

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

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

# Specify the type of database to create.

# It can be one of the following:

# - GENERAL_PURPOSE

# - DATA_WAREHOUSE

# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.

# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.

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

oracle.install.db.config.starterdb.type=

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

# Specify the Starter Database Global Database Name.

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

oracle.install.db.config.starterdb.globalDBName=

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

# Specify the Starter Database SID.

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

oracle.install.db.config.starterdb.SID=

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

# Specify whether the database should be configured as a Container database.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

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

oracle.install.db.ConfigureAsContainerDB=

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

# Specify the Pluggable Database name for the pluggable database in Container Database.

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

oracle.install.db.config.PDBName=

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

# Specify the Starter Database character set.

# One of the following

# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

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

oracle.install.db.config.starterdb.characterSet=

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

# This variable should be set to true if Automatic Memory Management

# in Database is desired.

# If Automatic Memory Management is not desired, and memory allocation

# is to be done manually, then set it to false.

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

oracle.install.db.config.starterdb.memoryOption=

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

# Specify the total memory allocation for the database. Value(in MB) should be

# at least 256 MB, and should not exceed the total physical memory available

# on the system.

# Example: oracle.install.db.config.starterdb.memoryLimit=512

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

oracle.install.db.config.starterdb.memoryLimit=

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

# This variable controls whether to load Example Schemas onto

# the starter database or not.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

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

oracle.install.db.config.starterdb.installExampleSchemas=

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

# #

# Passwords can be supplied for the following four schemas in the #

# starter database: #

# SYS #

# SYSTEM #

# DBSNMP (used by Enterprise Manager) #

# #

# Same password can be used for all accounts (not recommended) #

# or different passwords for each account can be provided (recommended) #

# #

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

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

# This variable holds the password that is to be used for all schemas in the

# starter database.

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

oracle.install.db.config.starterdb.password.ALL=

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

# Specify the SYS password for the starter database.

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

oracle.install.db.config.starterdb.password.SYS=

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

# Specify the SYSTEM password for the starter database.

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

oracle.install.db.config.starterdb.password.SYSTEM=

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

# Specify the DBSNMP password for the starter database.

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

oracle.install.db.config.starterdb.password.DBSNMP=

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

# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

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

oracle.install.db.config.starterdb.password.PDBADMIN=

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

# Specify the management option to use for managing the database.

# Options are:

# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.

# 2. DEFAULT -If you want to manage your database using the default Database Express option.

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

oracle.install.db.config.starterdb.managementOption=

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

# Specify the OMS host to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

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

oracle.install.db.config.starterdb.omsHost=

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

# Specify the OMS port to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

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

oracle.install.db.config.starterdb.omsPort=

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

# Specify the EM Admin user name to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

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

oracle.install.db.config.starterdb.emAdminUser=

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

# Specify the EM Admin password to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

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

oracle.install.db.config.starterdb.emAdminPassword=

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

# #

# SPECIFY RECOVERY OPTIONS #

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

# Recovery options for the database can be mentioned using the entries below #

# #

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

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

# This variable is to be set to false if database recovery is not required. Else

# this can be set to true.

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

oracle.install.db.config.starterdb.enableRecovery=

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

# Specify the type of storage to use for the database.

# It can be one of the following:

# - FILE_SYSTEM_STORAGE

# - ASM_STORAGE

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

oracle.install.db.config.starterdb.storageType=

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

# Specify the database file location which is a directory for datafiles, control

# files, redo logs.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

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

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

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

# Specify the recovery location.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

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

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

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

# Specify the existing ASM disk groups to be used for storage.

# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

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

oracle.install.db.config.asm.diskGroup=

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

# Specify the password for ASMSNMP user of the ASM instance.

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

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

oracle.install.db.config.asm.ASMSNMPPassword=

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

# Specify the My Oracle Support Account Username.

# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com

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

MYORACLESUPPORT_USERNAME=

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

# Specify the My Oracle Support Account Username password.

# Example : MYORACLESUPPORT_PASSWORD=password

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

MYORACLESUPPORT_PASSWORD=

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

# Specify whether to enable the user to set the password for

# My Oracle Support credentials. The value can be either true or false.

# If left blank it will be assumed to be false.

# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

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

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

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

# Specify whether user doesn't want to configure Security Updates.

# The value for this variable should be true if you don't want to configure

# Security Updates, false otherwise.

# The value can be either true or false. If left blank it will be assumed

# to be false.

# Example : DECLINE_SECURITY_UPDATES=false

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

DECLINE_SECURITY_UPDATES=true

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

# Specify the Proxy server name. Length should be greater than zero.

# Example : PROXY_HOST=proxy.domain.com

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

PROXY_HOST=

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

# Specify the proxy port number. Should be Numeric and at least 2 chars.

# Example : PROXY_PORT=25

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

PROXY_PORT=

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

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example : PROXY_USER=username

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

PROXY_USER=

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

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example : PROXY_PWD=password

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

PROXY_PWD=

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

# Specify the Oracle Support Hub URL.

# Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/

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

COLLECTOR_SUPPORTHUB_URL=

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

[oracle@srv1 database]$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -responseFile /u01/database/response/db_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 28530 MB Passed

Checking swap space: must be greater than 150 MB. Actual 5983 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-06-14_05-26-47PM. Please wait ...[oracle@srv1 database]$ [FATAL] [INS-35344] The value is not specified for Encryption Key Management administrative (OSKMDBA) group.

ACTION: Specify a valid group name for Encryption Key Management administrative (OSKMDBA) group.

A log of this session is currently saved as: /tmp/OraInstall2019-06-14_05-26-47PM/installActions2019-06-14_05-26-47PM.log. Oracle recommends that if you want to keep this log, you should move it from the temporary location.

[oracle@srv1 database]$ vi /u01/database/response/db_install.rsp

[oracle@srv1 database]$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -responseFile /u01/database/response/db_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 28521 MB Passed

Checking swap space: must be greater than 150 MB. Actual 5983 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-06-14_05-28-31PM. Please wait ...[oracle@srv1 database]$ You can find the log of this install session at:

/u01/app/oraInventory/logs/installActions2019-06-14_05-28-31PM.log

The installation of Oracle Database 12c was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2019-06-14_05-28-31PM.log' for more details.

As a root user, execute the following script(s):

1. /u01/app/oraInventory/orainstRoot.sh

2. /u01/app/oracle/product/dbhome_1/root.sh

Successfully Setup Software.

[oracle@srv1 database]$

[root@srv1 ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@srv1 ~]# /u01/app/oracle/product/dbhome_1/root.sh

Check /u01/app/oracle/product/dbhome_1/install/root_srv1.example.com_2019-06-14_17-39-15.log for the output of root script

[root@srv1 ~]#

NOTE: We face issue below whle installing using response file.

[oracle@srv1 database]$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -responseFile /u01/database/response/db_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 28530 MB Passed

Checking swap space: must be greater than 150 MB. Actual 5983 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-06-14_05-22-56PM. Please wait ...[oracle@srv1 database]$

[oracle@srv1 database]$ [WARNING] - My Oracle Support Username/Email Address Not Specified

A log of this session is currently saved as: /tmp/OraInstall2019-06-14_05-22-56PM/installActions2019-06-14_05-22-56PM.log. Oracle recommends that if you want to keep this log, you should move it from the temporary location.

make enrty in DECLINE_SECURITY_UPDATES=true on db_install.rsp file

YUM Installation

Step:1
Install yum packages from Linux OS DVD.

# rpm -i deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
# rpm -i python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
# rpm -i createrepo-0.9.8-4.el6.noarch.rpm
Step:2
Configuring Yum repository.
1.Create the Directories:
mkdir -pv /var/ftp/pub/Server

2. Copy the RPMs from the CDs/DVD to /var/ftp/pub/Server

3.Create the base repository headers:
createrepo -v /var/ftp/pub/Server

4.Go to /etc/yum.repos.d and create file with any name
(i.e repo would be fine with .repo extension)

Go to directory : /etc/yum.repos.d/
NOTE: Move other .repo file to another location or delete it.

[root@localhost yum.repos.d]# cat myyum.repo
[local-installation]
name=yum-local
baseurl=file:///var/ftp/pub/Server
enabled=1
gpgcheck=0

For virtual box guest edition

yum install gcc* -y

yum install kernel* -y