前言:
今天兄弟们对“oracle dbca 静默安装数据文件路径”大概比较注重,小伙伴们都想要学习一些“oracle dbca 静默安装数据文件路径”的相关知识。那么小编在网摘上网罗了一些对于“oracle dbca 静默安装数据文件路径””的相关文章,希望姐妹们能喜欢,小伙伴们快快来了解一下吧!1.检查安装包是否安装完全
rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl pdksh sysstat unixODBC unixODBC-devel | grep "not installed"
yum install 安装没有安装的安装包
2.创建用户和组
groupadd oinstall
groupadd oper
groupadd dba
useradd -g oinstall -G dba,oper oracle
echo "oracle:oracle" | chpasswd
3.配置内核参数
cat <<EOF >>/etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576EOF
4.配置资源限制
cat <<EOF >>/etc/security/limits.conforacle soft nofile 65536oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle stack nproc 10240oracle stack nproc 10240EOF执行:sysctl -p
5.创建相关目录
mkdir -p /u01/app/oracle/product/11.2.0.4/db_1 mkdir -p /u01/app/oracle/oradatamkdir -p /u01/app/oracle/flash_recovery_areamkdir -p /u01/app/oracle/archlogchown -R oracle:oinstall /u01
6.配置oracle的环境变量
cat .bash_profileCOLUMNS=132; export COLUMNSLINES=47; export LINESEDITOR=vi; export EDITORTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOMEORACLE_SID=orcl; export ORACLE_SIDSHLIB_PATH=$LD_LIBRARY_PATH;export SHLIB_PATHNLS_LANG=American_America.zhs16gbk;export NLS_LANGORA_NLS10=$ORACLE_HOME/nls/data;export ORA_NLS10TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMINORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHalias glance=/opt/perf/bin/glance:xalias gohome='cd /u01/app/oracle/product/11.2.0.4'alias cdb='cd /u01/app/oracle/admin/orcl/bdump'alias cdu='cd /u01/app/oracle/admin/orcl/udump'alias sqlplus='rlwrap sqlplus'alias rman='rlwrap rman'source .bash_profile
修改操作系统的版本:cat /etc/redhat-release
把原本的注释,添加:redhat-4
7.安装数据库
cd /downloadunzip p13390677_112040_Linux-x86-64_1of7.zipunzip p13390677_112040_Linux-x86-64_2of7.zipcd /download/database/response修改:db_install.rsp需要修改以下内容:oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=oracleUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventoryORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=operoracle.install.db.config.starterdb.password.ALL=oracleDECLINE_SECURITY_UPDATES=trueoracle.installer.autoupdates.option=SKIP_UPDATES直接复制即可:###################################################################### Copyright(c) Oracle Corporation 1998,2013. All rights reserved.#### #### 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_v11_2_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=oracle#-------------------------------------------------------------------------------# 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/11.2.0.4/db_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 # - SE : Standard Edition # - SEONE : Standard Edition One# - PE : Personal Edition (WINDOWS ONLY)#------------------------------------------------------------------------------oracle.install.db.InstallEdition=EE#------------------------------------------------------------------------------# This variable is used to enable or disable custom install and is considered# only if InstallEdition is EE.## true : Components mentioned as part of 'optionalComponents' property# are considered for install.# false : Value for 'optionalComponents' is not considered.#------------------------------------------------------------------------------oracle.install.db.EEOptionsSelection=false#------------------------------------------------------------------------------# This variable is considered only if 'EEOptionsSelection' is set to true. ## Description: List of Enterprise Edition Options you would like to enable.## The following choices are available. You may specify any# combination of these choices. The components you choose should# be specified in the form "internal-component-name:version"# Below is a list of components you may specify to enable.# # oracle.oraolap:11.2.0.4.0 - Oracle OLAP# oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining# oracle.rdbms.dv:11.2.0.4.0 - Oracle Database Vault# oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security# oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning# oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing#------------------------------------------------------------------------------oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0################################################################################ ## 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=oper#------------------------------------------------------------------------------# Specify the cluster node names selected during the installation.# 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=#------------------------------------------------------------------------------# Specify the name for RAC One Node Service. #------------------------------------------------------------------------------oracle.install.db.racOneServiceName=#------------------------------------------------------------------------------# Specify the type of database to create.# It can be one of the following:# - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------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 the Starter Database character set.# # It can be 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=AL32UTF8#------------------------------------------------------------------------------# 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=true#------------------------------------------------------------------------------# 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.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.installExampleSchemas=false#------------------------------------------------------------------------------# This variable includes enabling audit settings, configuring password profiles# and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------oracle.install.db.config.starterdb.enableSecuritySettings=true################################################################################ ## Passwords can be supplied for the following four schemas in the ## starter database: ## SYS ## SYSTEM ## SYSMAN (used by Enterprise Manager) ## 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=oracle#-------------------------------------------------------------------------------# 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 SYSMAN password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYSMAN=#-------------------------------------------------------------------------------# Specify the DBSNMP password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.DBSNMP=#-------------------------------------------------------------------------------# Specify the management option to be selected for the starter database. # It can be one of the following:# - GRID_CONTROL# - DB_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.control=DB_CONTROL#-------------------------------------------------------------------------------# Specify the Management Service to use if Grid Control is selected to manage # the database. #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=################################################################################ ## SPECIFY BACKUP AND RECOVERY OPTIONS ## ------------------------------------ ## Out-of-box backup and recovery options for the database can be mentioned ## using the entries below. ## #################################################################################------------------------------------------------------------------------------# This variable is to be set to false if automated backup is not required. Else # this can be set to true.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.enable=false#------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user that is # specified in this variable.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.osuid=#-------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user specified by the # above entry. The following entry stores the password for the above operating # system user.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.ospwd=#-------------------------------------------------------------------------------# 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 backup and 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.storage=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 proxy realm. This value is used if auto-updates option is selected.## Example : PROXY_REALM=metalink #------------------------------------------------------------------------------PROXY_REALM=#------------------------------------------------------------------------------# Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL= Specify the auto-updates option. It can be one of the following:# - MYORACLESUPPORT_DOWNLOAD# - OFFLINE_UPDATES# - SKIP_UPDATES#------------------------------------------------------------------------------oracle.installer.autoupdates.option=SKIP_UPDATES#------------------------------------------------------------------------------# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where# the updates are to be downloaded.# In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present.#------------------------------------------------------------------------------oracle.installer.autoupdates.downloadUpdatesLoc=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username which has the patches download privileges # to be used for software updates.# Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_USERNAME=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username password which has the patches download privileges # to be used for software updates.## Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
8.修改dbca.rsp
需要修改以下:GDBNAME = "orcl"SID = "orcl"SYSPASSWORD = "orcl"SYSTEMPASSWORD = "orcl"SYSMANPASSWORD = "orcl"DBSNMPPASSWORD = "orcl"DATAFILEDESTINATION ="/u01/app/oracle/oradata"STORAGETYPE=FSCHARACTERSET = "ZHS16GBK"DATABASETYPE = "MULTIPURPOSE"复制即可:################################################################################ #### DBCA response file #### ------------------ #### Copyright 1998, 2013, 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 : "<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 : "11.1.0"# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------RESPONSEFILE_VERSION = "11.2.0"#-----------------------------------------------------------------------------# Name : OPERATION_TYPE# Datatype : String# Description : Type of operation# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only)# 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 = "orcl"#-----------------------------------------------------------------------------# Name : RACONENODE# Datatype : Boolean# Description : Set to true for RAC One Node database# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#RACONENODE = "false"#-----------------------------------------------------------------------------# 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 RACONENODE flag is set to true]#-----------------------------------------------------------------------------#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 : 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 : 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 : SID# Datatype : String# Description : System identifier (SID) of the database# Valid values : Check Oracle11g Administrator's Guide# Default value : <db_name> specified in GDBNAME# Mandatory : No#-----------------------------------------------------------------------------SID = "orcl"#-----------------------------------------------------------------------------# 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 Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------SYSPASSWORD = "orcl"#-----------------------------------------------------------------------------# Name : SYSTEMPASSWORD# Datatype : String# Description : Password for SYSTEM user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------SYSTEMPASSWORD = "orcl"#-----------------------------------------------------------------------------# Name : EMCONFIGURATION# Datatype : String# Description : Enterprise Manager Configuration Type# Valid values : CENTRAL|LOCAL|ALL|NONE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#EMCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : DISABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#DISABLESECURITYCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : SYSMANPASSWORD# Datatype : String# Description : Password for SYSMAN user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION#-----------------------------------------------------------------------------SYSMANPASSWORD = "orcl"#-----------------------------------------------------------------------------# Name : DBSNMPPASSWORD# Datatype : String# Description : Password for DBSNMP user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if EMCONFIGURATION is specified#-----------------------------------------------------------------------------DBSNMPPASSWORD = "orcl"#-----------------------------------------------------------------------------# Name : CENTRALAGENT# Datatype : String# Description : Grid Control Central Agent Oracle Home# Default value : None# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#CENTRALAGENT = #-----------------------------------------------------------------------------# Name : HOSTUSERNAME# Datatype : String# Description : Host user name for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERNAME = #-----------------------------------------------------------------------------# Name : HOSTUSERPASSWORD# Datatype : String# Description : Host user password for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERPASSWORD= #-----------------------------------------------------------------------------# Name : BACKUPSCHEDULE# Datatype : String# Description : Daily backup schedule in the form of hh:mm# Default value : 2:00# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#BACKUPSCHEDULE=#-----------------------------------------------------------------------------# Name : DVOWNERNAME# Datatype : String# Description : DataVault Owner# Valid values : Check Oracle11g 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 Oracle11g 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 Oracle11g Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#DVACCOUNTMANAGERNAME = ""#-----------------------------------------------------------------------------# Name : DVACCOUNTMANAGERPASSWORD# Datatype : String# Description : Password for DataVault Account Manager# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#DVACCOUNTMANAGERPASSWORD = ""#-----------------------------------------------------------------------------# 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/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=#-----------------------------------------------------------------------------# 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 Oracle11g National Language Support Guide# Default value : "US7ASCII"# Mandatory : NO#-----------------------------------------------------------------------------CHARACTERSET = "ZHS16GBK"#-----------------------------------------------------------------------------# Name : NATIONALCHARACTERSET# Datatype : String# Description : National Character set of the database# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle11g 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 space separated names 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 = "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 <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 = "orcl11.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 =#-----------------------*** 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 : DISABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#DISABLESECURITYCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : ENABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : true|false# Default value : true# Mandatory : No#-----------------------------------------------------------------------------#ENABLESECURITYCONFIGURATION = "true"#-----------------------------------------------------------------------------# Name : EMCONFIGURATION# Datatype : String# Description : Enterprise Manager Configuration Type# Valid values : CENTRAL|LOCAL|ALL|NONE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#EMCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : SYSMANPASSWORD# Datatype : String# Description : Password for SYSMAN user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION#-----------------------------------------------------------------------------#SYSMANPASSWORD = "password"#-----------------------------------------------------------------------------# Name : DBSNMPPASSWORD# Datatype : String# Description : Password for DBSNMP user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if EMCONFIGURATION is specified#-----------------------------------------------------------------------------#DBSNMPPASSWORD = "password"#-----------------------------------------------------------------------------# Name : CENTRALAGENT# Datatype : String# Description : Grid Control Central Agent Oracle Home# Default value : None# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#CENTRALAGENT = #-----------------------------------------------------------------------------# Name : HOSTUSERNAME# Datatype : String# Description : Host user name for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERNAME = #-----------------------------------------------------------------------------# Name : HOSTUSERPASSWORD# Datatype : String# Description : Host user password for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERPASSWORD= #-----------------------------------------------------------------------------# Name : BACKUPSCHEDULE# Datatype : String# Description : Daily backup schedule in the form of hh:mm# Default value : 2:00# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#BACKUPSCHEDULE=#-----------------------*** 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 = "orcl11g.us.oracle.com"#-----------------------------------------------------------------------------# Name : INSTANCENAME# Datatype : String# Description : RAC instance name to be added# Valid values : Check Oracle11g Administrator's Guide# Default value : <sid_prefix>+<highest_current_thread+1># Mandatory : No#-----------------------------------------------------------------------------#INSTANCENAME = "orcl1"#-----------------------------------------------------------------------------# Name : NODELIST# 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#-----------------------------------------------------------------------------NODELIST=#-----------------------------------------------------------------------------# 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 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 = "orcl11g.us.oracle.com"#-----------------------------------------------------------------------------# Name : INSTANCENAME# Datatype : String# Description : RAC instance name to be deleted# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------INSTANCENAME = "orcl11g"#-----------------------------------------------------------------------------# Name : NODELIST# Datatype : String# Description : Node on which instance to be deleted (SID) is located# Valid values : Cluster node name# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#NODELIST=#-----------------------------------------------------------------------------# 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 ***------------------------
9.执行静默安装db_install.rsp,dbca.rsp,netca.rsp
su - oraclecd /download/database/./runInstaller -silent -responseFile /download/database/response/db_install.rsp在root下执行两个root脚本提示:如果不小心安装错误已经在$ORACLE_HOME和/u01/app/oraInventory下生成了很多文件目录 rm -rf /u01/app/oraInventory cd $ORACLE_HOME/ rm -rf *安装dbca.rspdbca -silent -responseFile /download/database/response/dbca.rsp安装netca.rspnetca -silent -responseFile /download/database/response/netca.rsp安装完毕打开数据库即可卸载oracle
cd $ORACLE_HOMEcd deinstall./deinstall
标签: #oracle dbca 静默安装数据文件路径 #oracle11g修改memory #oracle安装包 #redhat64安装oracle11g #oracle11gunixodbc