12c dbca silent create cdb

最新推荐文章于 2022-10-14 16:14:55 发布
最新推荐文章于 2022-10-14 16:14:55 发布
阅读量215 收藏
点赞数
文章标签： 数据库 操作系统

1   描述

使用dbca命令静态安装cdb数据库。

2   操作环境

2.1         OS info

[oracle@host01 ~]$ lsb_release -a

LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: OracleServer

Description:    Oracle Linux Server release 6.5

Release:        6.5

Codename:       n/a

[oracle@host01 ~]$ uname -a

Linux host01.example.com 2.6.32-431.el6.x86_64 #1 SMP Wed Nov 20 23:56:07 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

[oracle@host01 ~]$

2.2         DB info

Db software 12.1.0.2.0


3   相关信息

在安装光盘response目录下，有dbca.rsp文件。可参考dbca.rsp的内容

[oracle@host03 response]$ cat dbca.rsp

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

##                                                                          ##

##                            DBCA response file                            ##

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

## Copyright   1998, 2014, Oracle Corporation. All Rights Reserved.         ##

##                                                                          ##

## 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     :  ""                                         ##

##          Boolean    :  True or False                                     ##

##          Number     :                                     ##

##          StringList :  {"",""}                           ##

##                                                                          ##

## Examples :                                                               ##

##     1. dbca -progress_only -responseFile                  ##

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

##        process.                                                          ##

##                                                                          ##

##     2. dbca -silent -responseFile                         ##

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

##                                                                          ##

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

##                       -responseFile                       ##

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

##        responsefile is a clone template.                                 ##

##                                                                          ##

##     4. dbca -silent -deleteDatabase -responseFile         ##

##        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  : . - when database domain isn't NULL

#                              - when database domain is NULL

# Default value : None

# Mandatory     : Yes

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

GDBNAME = "orcl12c.us.oracle.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 : specified in GDBNAME

# Mandatory     : No

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

SID = "orcl12c"


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

# 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 = "password"


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

# Name          : SYSTEMPASSWORD

# Datatype      : String

# Description   : Password for SYSTEM user

# Valid values  : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory     : Yes

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

#SYSTEMPASSWORD = "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"


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

# 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 = "password"


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

# 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 =


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

# 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=


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

# 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 =. 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 = "40"


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

# 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 ::

# 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  : . - when database domain isn't NULL

#                              - 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  :

# 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 : +

# 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  :

# 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  : (, ,....)

# 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  : (, ,....)

# 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 ***------------------------



4   详细步骤操作

[oracle@host01 ~]$  dbca -silent -responseFile responsole.txt

Copying database files

1% complete

3% complete

11% complete

18% complete

26% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

46% complete

47% complete

52% complete

57% complete

58% complete

59% complete

62% complete

Completing Database Creation

66% complete

70% complete

74% complete

85% complete

96% complete

100% complete

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

[oracle@host01 ~]$ vi /u01/app/oracle/cfgtoollogs/dbca/orcl12c/orcl12c.log

[oracle@host01 ~]$ cat !$

cat /u01/app/oracle/cfgtoollogs/dbca/orcl12c/orcl12c.log


Unique database identifier check passed.


/u01/ has enough space. Required space is 6900 MB , available space is 41450 MB.

File Validations Successful.

Copying database files

DBCA_PROGRESS : 1%

DBCA_PROGRESS : 3%

DBCA_PROGRESS : 11%

DBCA_PROGRESS : 18%

DBCA_PROGRESS : 26%

DBCA_PROGRESS : 37%

Creating and starting Oracle instance

DBCA_PROGRESS : 40%

DBCA_PROGRESS : 45%

DBCA_PROGRESS : 46%

DBCA_PROGRESS : 47%

DBCA_PROGRESS : 52%

DBCA_PROGRESS : 57%

DBCA_PROGRESS : 58%

DBCA_PROGRESS : 59%

DBCA_PROGRESS : 62%

Completing Database Creation

DBCA_PROGRESS : 66%

DBCA_PROGRESS : 70%

DBCA_PROGRESS : 74%

DBCA_PROGRESS : 85%

DBCA_PROGRESS : 96%

DBCA_PROGRESS : 100%

Database creation complete. For details check the logfiles at:

 /u01/app/oracle/cfgtoollogs/dbca/orcl12c.

Database Information:

Global Database Name:orcl12c.us.oracle.com

System Identifier(SID):orcl12c

[oracle@host01 ~]$ cd /u01/app/oracle/cfgtoollogs/dbca/orcl12c

[oracle@host01 orcl12c]$ ls

catbundleapply0.log              OraDB12Home1_orcl12c_creation_checkpoint.xml  rmanUtil

catbundleapply_catcon_73559.lst  orcl12c.log                                   tempControl.ctl

cloneDBCreation.log              ordlib0.log                                   trace.log

CloneRmanRestore.log             ordlib_catcon_73502.lst                       trace.log.lck

dbmssml0.log                     plugDatabase.log                              utlrp0.log

dbmssml_catcon_73359.lst         postDBCreation.log                            utlrp_catcon_73614.lst

lockAccount.log                  postScripts.log

[oracle@host01 orcl12c]$ ps -ef |grep smon

oracle     4847      1  0 Mar26 ?        00:00:07 ora_smon_DB11G

oracle     4994      1  0 Mar26 ?        00:00:01 ora_smon_PROD5

oracle    15896      1  0 00:55 ?        00:00:01 ora_smon_PROD4

oracle    73743      1  0 10:41 ?        00:00:00 ora_smon_orcl12c

oracle    74012  62127  0 10:42 pts/2    00:00:00 grep smon

[oracle@host01 orcl12c]$ cd

[oracle@host01 ~]$ vi responsole.txt

[oracle@host01 ~]$ cat responsole.txt

[GENERAL]

RESPONSEFILE_VERSION = "12.1.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "orcl12c.us.oracle.com"

SID = "orcl12c"

CREATEASCONTAINERDATABASE =True

TEMPLATENAME = "General_Purpose.dbc"

SYSPASSWORD = "oracle"

SYSTEMPASSWORD = "oracle"

[oracle@host01 ~]$


5   个人总结


官方建议使用dbca创建cdb.因为这样创建好的数据库会启动到open状态。

关于TEMPLATENAME = "General_Purpose.dbc" 参数，可到ORACLE_HOME/assistants/dbca/templates/目录下找到。

[oracle@host01 templates]$ ls

Data_Warehouse.dbc  General_Purpose.dbc  pdbseed.xml       Seed_Database.ctl

example01.dfb       New_Database.dbt     sampleschema.dfb  Seed_Database.dfb

example.dmp         pdbseed.dfb          sampleschema.xml

[oracle@host01 templates]$

6   资料参考引用

Database Administration

Administrator's Guide

2 Creating and Configuring an Oracle Database


http://docs.oracle.com/database/121/ADMIN/create.htm#i1017640

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-2065321/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11780477/viewspace-2065321/

cnk45946
关注
CentOS7静默安装Oracle 12c
qq_32789063的博客
07-12 419
当看到以下内容时：尤其是那个1和2 需要另外启动一个LINUX连接客户端并执行，记住用ROOT用户执行！b 进入到光盘镜像中的Package目录中将所有的软件包复制到我们预设的目录下。linuxx64_12201_database.zip上传到目录 /u01。4.修改LINUX的内核文件/etc/sysctl.conf。7.环境变量中添加下列语句。
Linux安装Oracle 12C
杨阳的博客
07-07 730
Linux安装Oracle 12CDefault limit for number of user's processes to preventaccidental fork bombs.See rhbz #432903 for reasoning.Oracle Settings 1.1.1. 系统配置 配置host ：vi /etc/hosts ip 主机名 192.168.0.129 yan...
DBCA静默创建CDB
喝醉酒的小白
08-30 2035
dbca -silent -ignorePreReqs -ignorePrereqFailure -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \ -gdbname cdb -sid cdb \ -createAsContainerDatabase TRUE \ -sysPassword oracle -systemPassword oracle -pdbAdminPassword oracle -db
oracle dbca silent mode create CDB and PDB sample code
engchina的专栏
01-13 436
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName CDB4 -sid CDB4 -createAsContainerDatabase true -numberOfPdbs 2 -pdbName PDB -pdbadminUsername pdbsys -pdbadminPassword oracle -S
oracle 12c怎样创建一个cdb数据库-dbca方式
最新发布
雅冰石的专栏
10-14 1377
这里想建一个sid为orclcdb的cdb，建两个以orclpdb为前缀的pdb。
DBCA创建CDB的过程
u010692693的专栏
06-27 2452
1. 使用DBCA静默安装生成脚本 [oracle@12cr2 ~]$ dbca -silent -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname testdb1 -sid testdb1 -characterSet ZHS16GBK -sysPassword oracle -s
12c dbca silent create pdb
cnk45946的博客
03-29 215
1 描述 在已有cdb orcl12c 基础之上，利用dbca 创建pdb数据库。 2 操作环境 2.1 OS info [oracle@host...
各种dbca静默建库
myy10146的专栏
12-17 366
帮助 Example: 18c Database Creation In Silent Mode Using Rsponse File (Non-CDB, CDB) (Doc ID 2430155.1) dbca -help 全部参数 dbca -help -createDatabase 11g/12c 单机 dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/...
oracle12c静默创建监听,oracle 12c 静默安装以及使用问题小结_
weixin_31749299的博客
04-03 789
一：一定先创建监听，然后建库，否则报错：[oracle@tvy-mysql-cdsp-01 database]$ dbca -silent -createDatabase -responseFile /media/database/response/dbca.rsp[WARNING] [DBT-06801] SPEcifIEd Fast Recovery Area size (2,780 MB) ...
【12c-多租户篇】Oracle 12c体系结构之多租户
个人公众号：Alen的数据库学习笔记
08-07 3324
一 多租户体系结构 多租户是Oracle 12c的新特性，该特性能够让您在多租户容器数据库（CDB）中创建和维护多个可插拔数据库（PDB）。 多租户容器数据库（CDB）被定义为可以容纳一个或多个插件数据库的数据库，容器被定义为存在于CDB中数据文件和元数据的集合，可插拔数据库是一种特殊类型的容器，它可以通过克隆其他数据库很容易的进行创建，如果需要，可插拔数据库也可以从一个CDB迁移...
12C dbca silent
weixin_33726943的博客
12-27 153
dbcaneeds a template file to create a database. These template can be found in$ORACLE_HOME/assistants/dbca/templates.We will use here the default New_Database.dbt template file to create a con...
用response文件silent模式安装和配置oracle10g
cuiyu8550的博客
06-05 408
两个附件分别是只安装oracle软件和“安装软件同时建立一数据库”两种情况的响应文件，涉及到的密码都是oracle10一、使用silent模式安装DB的几种情况1、使用OS工具（如at）进行无人参与安装2、在多个OS上完成非交互...
使用responseFile进行oracle静默安装
ciqu9915的博客
07-01 404
我们通常使用的数据库，都是基于图形GUI界面进行的。在Windows和其他图形化操作系统中，图形交互式安装时很方便的安装手段。但是，在很多情况下，图形交互式安装时有很多的限制的。 首先，图形GUI界面要求显示图...
dbca silent安装
cuijia1660的博客
01-03 163
2.5 执行以下命令使用DBCA根据模板创建新数据库 dbca –silent –createdatabase –responseFile dbca.rsp 方法二：使用纯SQL语法 connect / as SY...
oracle安装时创建应答文件,12c 应答方式安装 （二） 创建cdb+pdb+netca
weixin_36340926的博客
04-04 456
上一篇已经用应答文件安装了数据库软件，这一篇博客接着安装12c新推出的CDB和PDB。一，配置netca1. 复制并修改netca配置文件[oracle@snow response]$ cp -rp netca.rsp cdb_pdb_netca.rsp[oracle@snow response]$ vi cdb_pdb_netca.rsp[GENERAL]RESPONSEFILE_VERSION...
12c 2cpu oracle se_Oracle数据库之Oracle12c install on CentOS7
weixin_39716971的博客
12-19 767
本文主要向大家介绍了Oracle数据库之Oracle12c install on CentOS7，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。SITTestDBserver:[root@pss-db-test~]#uname-r3.10.0-693.21.1.el7.x86_64[root@pss-db-testdb_1]#cat/etc/redhat-r...
oracle12的dbca,oracle 12.1 dbca ora-00119
weixin_39787057的博客
04-03 154
[oracle@T420 12.1.0.2.0:(C121) 12.1.0.2.0 ] $ ./dbca_c121_create_cdb.shCleaning up failed steps5% completeRegistering database with Oracle Restart11% completeCopying database files12% complete13% comp...
Oracle12C 通过DBCA创建CDB
q951674899的博客
10-14 683
1、创建数据库 2、高级选项 3、普通数据库 4、设置CDB名字、设置为容器库 5、设置数据库密码 6、选择存储位置 7、设置编码格式 其他： 1、设置端口号： exec DBMS_XDB_CONFIG.setHTTPsPort(5502) ; exec DBMS_XDB_CONFIG.setHTTPPort(5502) ; 2、查看端口号： exec DBMS_XDB_CONFIG.getHTT...
Oracle 12c手工建库(非CDB及CDB创建)
乐沙弥的世界
05-31 8156
对于Oracle数据库的创建，Oracle除了支持dbca(GUI界面)，同时也支持手工方式创建数据库，即使用CREATE DATABASE语句创建数据库。使用此语句对使用DBCA的一个优点是可以从脚本内创建数据库。在Oracle 12c版本中支持12c之前的非CDB数据库以及CDB容器数据库。因此创建方式略有不同。本文同时描述2种不同数据库的手工创建方法。
Oracle 12C 管理指南：CDB与PDB命令
"Oracle 12C 引入了多租户容器数据库（Container Database，CDB）的概念，其中包含了可插拔数据库（Pluggable Database，PDB）。CDB 是一个中央管理的数据库，而 PDB 是可以独立运行、管理和升级的数据库实例，可以...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值