摘要：
本次部署的11G RAC 是在虚拟化云平台上实现，部署过程中发现，该VM未配置 SWAP 分区，使用本次文件创建SWAP分区后，完成数据库的安装。
执行安装的时候只需要指定该文件即可自动的以silent和非图形化的形式完成整个安装过程，这个保存配置的文件叫做响应文件，response是响应文件目录，其中包含了3个响应文件：
[oracle@redhat6 response]$ ls
dbca.rsp* db_install.rsp* netca.rsp*
db_install.rsp是用于安装Database的响应文件，dbca.rsp是用于创建数据库的响应文件，netca.rsp是用于创建监听器的响应文件。每个响应文件打开之后都有详细的说明，包括哪些参数，参数的含义及参数的可选项。以db_install.rsp为例，在该文件中对每个参数的含义、选项都做了详细的说明，下面是对db_install.rsp修改的值，用于Oracle Database 11gR2软件的安装(以下配置仅供修改参考，不可直接使用)。
以上配置只会安装单机环境的数据库软件，不会创建数据库。
其中DECLINE_SECURITY_UPDATES一定要设置成true，否则在安装的时候会出现以下的告警：
[WARNING] - My Oracle Support Username/Email Address Not Specified
[SEVERE] - Provide the My Oracle Support password.
1.安装环境
[grid@qhitnmdb1 ~]$ uname -a
Linux qhitnmdb1 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[grid@qhitnmdb1 ~]$
[root@qhitnmdb1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[root@qhitnmdb1 ~]#
存储使用了oracleasmlib 来配置管理:
[root@qhitnmdb1 ~]# oracleasm listdisks
DATA0
DATA1
DATA2
DATA3
DATA4
DATA5
DATA6
DATA7
DATA8
DATA9
FRA0
FRA1
FRA2
FRA3
FRA4
FRA5
OCRVOTE0
OCRVOTE1
OCRVOTE2
REDO0
REDO1
REDO2
REDO3
REDO4
[root@qhitnmdb1 ~]#
2.集群软件(GI) 静默安装
将11.2.0.3 集群安装软件解压缩到/home/grid/11.2.0.3/grid路径下。
step 1.使用runcluvfy.sh 来执行安装前的预检查，来避免由于环境配置引发的安装失败问题。
[root@qhitnmdb1 ~]# su - grid
[grid@qhitnmdb1 ~]$ cd /opt/Oracle11.2.0.4-for-linux/grid/
[grid@qhitnmdb1 grid]$
[grid@qhitnmdb1 grid]$ ls
install readme.html response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
[grid@qhitnmdb1 grid]$ ./runcluvfy.sh stage -pre crsinst -n qhitnmdb1,qhitnmdb2 -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "qhitnmdb1"
Destination Node Reachable?
------------------------------------ ------------------------
qhitnmdb2 yes
qhitnmdb1 yes
Result: Node reachability check passed from node "qhitnmdb1"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
qhitnmdb2 failed
qhitnmdb1 failed
Result: PRVF-4007 : User equivalence check failed for user "grid"
ERROR:
User equivalence unavailable on all the specified nodes
Verification cannot proceed
Pre-check for cluster services setup was unsuccessful on all the nodes.
[grid@qhitnmdb1 grid]$
确认为SSH互信配置问题，从新配置。
Result: PRVF-4007 : User equivalence check failed for user "grid"
step 2.配置grid.rsp文件
下面是对grid_install.rsp文件修改的内容（仅供修改参考，不可直接拷贝使用）：
###############################################################################
## 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. ##
## ##
###############################################################################
###############################################################################
## ##
## Instructions to fill this response file ##
## To install and configure 'Grid Infrastructure for Cluster' ##
## - Fill out sections A,B,C,D,E,F and G ##
## - Fill out section G if OCR and voting disk should be placed on ASM ##
## ##
## To install and configure 'Grid Infrastructure for Standalone server' ##
## - Fill out sections A,B and G ##
## ##
## To install software for 'Grid Infrastructure' ##
## - Fill out sections A,B and C ##
## ##
## To upgrade clusterware and/or Automatic storage management of earlier ##
## releases ##
## - Fill out sections A,B,C,D and H ##
## ##
###############################################################################
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
###############################################################################
# #
# SECTION A - BASIC #
# #
###############################################################################
#-------------------------------------------------------------------------------
# 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=cgs1
#-------------------------------------------------------------------------------
# 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 installation option.
# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY
# - CRS_CONFIG : To configure Grid Infrastructure for cluster
# - HA_CONFIG : To configure Grid Infrastructure for stand alone server
# - UPGRADE : To upgrade clusterware software of earlier release
# - CRS_SWONLY : To install clusterware files only (can be configured for cluster
# or stand alone server later)
#-------------------------------------------------------------------------------
oracle.install.option=CRS_CONFIG
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/grid
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#-------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/11.2.0/grid
################################################################################
# #
# SECTION B - GROUPS #
# #
# The following three groups need to be assigned for all GI installations. #
# OSDBA and OSOPER can be the same or different. OSASM must be different #
# than the other two. #
# The value to be specified for OSDBA, OSOPER and OSASM group is only for #
# Unix based Operating System. #
# #
################################################################################
#-------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#-------------------------------------------------------------------------------
oracle.install.asm.OSDBA=asmdba
#-------------------------------------------------------------------------------
# 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.asm.OSOPER=asmoper
#-------------------------------------------------------------------------------
# The OSASM_GROUP is the OS group which is to be granted OSASM privileges. This
# must be different than the previous two.
#-------------------------------------------------------------------------------
oracle.install.asm.OSASM=asmadmin
################################################################################
# #
# SECTION C - SCAN #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify a name for SCAN
#-------------------------------------------------------------------------------
oracle.install.crs.config.gpnp.scanName=cgs-scan
#-------------------------------------------------------------------------------
# Specify a unused port number for SCAN service
#-------------------------------------------------------------------------------
oracle.install.crs.config.gpnp.scanPort=1521
################################################################################
# #
# SECTION D - CLUSTER & GNS #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify a name for the Cluster you are creating.
#
# The maximum length allowed for clustername is 15 characters. The name can be
# any combination of lower and uppercase alphabets (A - Z), (0 - 9), hyphen(-)
# and underscore(_).
#-------------------------------------------------------------------------------
oracle.install.crs.config.clusterName=cgs-cluster
#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure Grid Naming Service(GNS), else
# specify 'false'
#-------------------------------------------------------------------------------
oracle.install.crs.config.gpnp.configureGNS=false
#-------------------------------------------------------------------------------
# Applicable only if you choose to configure GNS
# Specify the GNS subdomain and an unused virtual hostname for GNS service
# Additionally you may also specify if VIPs have to be autoconfigured
#
# Value for oracle.install.crs.config.autoConfigureClusterNodeVIP should be true
# if GNS is being configured(oracle.install.crs.config.gpnp.configureGNS), false
# otherwise.
#-------------------------------------------------------------------------------
oracle.install.crs.config.gpnp.gnsSubDomain=
oracle.install.crs.config.gpnp.gnsVIPAddress=
oracle.install.crs.config.autoConfigureClusterNodeVIP=false
#-------------------------------------------------------------------------------
# Specify a list of public node names, and virtual hostnames that have to be
# part of the cluster.
#
# The list should a comma-separated list of nodes. Each entry in the list
# should be a colon-separated string that contains 2 fields.
#
# The fields should be ordered as follows:
# 1. The first field is for public node name.
# 2. The second field is for virtual host name
# (specify as AUTO if you have chosen 'auto configure for VIP'
# i.e. autoConfigureClusterNodeVIP=true)
#
# Example: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip
#-------------------------------------------------------------------------------
oracle.install.crs.config.clusterNodes=cgs1:cgs1-vip,cgs2:cgs2-vip
#-------------------------------------------------------------------------------
# The value should be a comma separated strings where each string is as shown below
# InterfaceName:SubnetAddress:InterfaceType
# where InterfaceType can be either "1", "2", or "3"
# (1 indicates public, 2 indicates private, and 3 indicates the interface is not used)
#
# For example: eth0:140.87.24.0:1,eth1:10.2.1.0:2,eth2:140.87.52.0:3
#
#-------------------------------------------------------------------------------
oracle.install.crs.config.networkInterfaceList=eth1:192.168.10.0:2,eth0:10.182.208.0:1
################################################################################
# #
# SECTION E - STORAGE #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting
# Disks files
# - ASM_STORAGE
# - FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.crs.config.storageOption=ASM_STORAGE
#-------------------------------------------------------------------------------
# THIS PROPERTY NEEDS TO BE FILLED ONLY IN CASE OF WINDOWS INSTALL.
# Specify a comma separated list of strings where each string is as shown below:
# Disk Number:Partition Number:Drive Letter:Format Option
# The Disk Number and Partition Number should refer to the location which has to
# be formatted. The Drive Letter should refer to the drive letter that has to be
# assigned. "Format Option" can be either of the following -
# - SOFTWARE : Format to place software binaries.
# - DATA : Format to place the OCR/VDSK files.
#
# For example: 1:2:P:DATA,1:3:Q:SOFTWARE,1:4:R:DATA,1:5:S:DATA
#
#-------------------------------------------------------------------------------
oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
#-------------------------------------------------------------------------------
# These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for
# storing OCR and voting disk
# Specify the location(s) and redundancy for OCR and voting disks
# Multiple locations can be specified, separated by commas.
# In case of windows, mention the drive location that is specified to be
# formatted for DATA in the above property.
# Redundancy can be one of these:
# EXTERNAL - one(1) location should be specified for OCR and voting disk
# NORMAL - three(3) locations should be specified for OCR and voting disk
# Example:
# For Unix based Operating System:
# oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=/oradbocfs/storage/vdsk1,/oradbocfs/storage/vdsk2,/oradbocfs/storage/vdsk3
# oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=/oradbocfs/storage/ocr1,/oradbocfs/storage/ocr2,/oradbocfs/storage/ocr3
# For Windows based Operating System:
# oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=P:\vdsk1,R:\vdsk2,S:\vdsk3
# oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=P:\ocr1,R:\ocr2,S:\ocr3
#-------------------------------------------------------------------------------
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
################################################################################
# #
# SECTION F - IPMI #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure Intelligent Power Management interface
# (IPMI), else specify 'false'
#-------------------------------------------------------------------------------
oracle.install.crs.config.useIPMI=false
#-------------------------------------------------------------------------------
# Applicable only if you choose to configure IPMI
# i.e. oracle.install.crs.config.useIPMI=true
# Specify the username and password for using IPMI service
#-------------------------------------------------------------------------------
oracle.install.crs.config.ipmi.bmcUsername=
oracle.install.crs.config.ipmi.bmcPassword=
################################################################################
# #
# SECTION G - ASM #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify a password for SYSASM user of the ASM instance
#-------------------------------------------------------------------------------
oracle.install.asm.SYSASMPassword=
#-------------------------------------------------------------------------------
# The ASM DiskGroup
#
# Example: oracle.install.asm.diskGroup.name=data
#
#-------------------------------------------------------------------------------
oracle.install.asm.diskGroup.name=OCR
#-------------------------------------------------------------------------------
# Redundancy level to be used by ASM.
# It can be one of the following
# - NORMAL
# - HIGH
# - EXTERNAL
# Example: oracle.install.asm.diskGroup.redundancy=NORMAL
#
#-------------------------------------------------------------------------------
oracle.install.asm.diskGroup.redundancy=NORMAL
#-------------------------------------------------------------------------------
# Allocation unit size to be used by ASM.
# It can be one of the following values
# - 1
# - 2
# - 4
# - 8
# - 16
# - 32
# - 64
# Example: oracle.install.asm.diskGroup.AUSize=4
# size unit is MB
#
#-------------------------------------------------------------------------------
oracle.install.asm.diskGroup.AUSize=1
#-------------------------------------------------------------------------------
# List of disks to create a ASM DiskGroup
#
# Example:
# For Unix based Operating System:
# oracle.install.asm.diskGroup.disks=/oracle/asm/disk1,/oracle/asm/disk2
# For Windows based Operating System:
# oracle.install.asm.diskGroup.disks=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1
#
#-------------------------------------------------------------------------------
oracle.install.asm.diskGroup.disks=/dev/asm_diskOCR1,/dev/asm_diskOCR2,/dev/asm_diskOCR3
#-------------------------------------------------------------------------------
# The disk discovery string to be used to discover the disks used create a ASM DiskGroup
#
# Example:
# For Unix based Operating System:
# oracle.install.asm.diskGroup.diskDiscoveryString=/oracle/asm/*
# For Windows based Operating System:
# oracle.install.asm.diskGroup.diskDiscoveryString=\\.\ORCLDISK*
#
#-------------------------------------------------------------------------------
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*
#-------------------------------------------------------------------------------
# oracle.install.asm.monitorPassword=password
#-------------------------------------------------------------------------------
oracle.install.asm.monitorPassword=
################################################################################
# #
# SECTION H - UPGRADE #
# #
################################################################################
#-------------------------------------------------------------------------------
# Specify nodes for Upgrade.
# For upgrade on Windows, installer overrides the value of this parameter to include
# all the nodes of the cluster. However, the stack is upgraded one node at a time.
# Hence, this parameter may be left blank for Windows.
# Example: oracle.install.crs.upgrade.clusterNodes=node1,node2
#-------------------------------------------------------------------------------
oracle.install.crs.upgrade.clusterNodes=
#-------------------------------------------------------------------------------
# For RAC-ASM only. oracle.install.asm.upgradeASM=true/false
# Value should be 'true' while upgrading Cluster ASM of version 11gR2(11.2.0.1.0) and above
#-------------------------------------------------------------------------------
oracle.install.asm.upgradeASM=false
#------------------------------------------------------------------------------
# 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=
#------------------------------------------------------------------------------
# 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=0
#------------------------------------------------------------------------------
# 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.
#
# Example : PROXY_REALM=metalink
#------------------------------------------------------------------------------
PROXY_REALM=
step 3. 使用以下命令来开始静默安装集群软件：
以grid用户切换到Grid Infrastructure安装介质目录，执行以下的命令开始静默安装Grid Infrastructure软件：
[grid@qhitnmdb1 ~]$ ./runInstaller -silent -ignorePrereq -showProgress -responseFile /opt/Oracle11.2.0.4-for-linux/grid/response/install.rsp
Checking Temp space: must be greater than 120 MB. Actual 8448 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1023 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-03-30_01-29-06PM. Please wait ...
[grid@qhitnmdb1 grid]$
安装完成，提示执行脚本
[grid@qhitnmdb1 ~]$ The installation of Oracle Grid Infrastructure 11g was successful.
Please check '/oracle/app/oraInventory/logs/silentInstall2018-03-30_04-01-24PM.log' for more details.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /oracle/app/oraInventory/orainstRoot.sh
2. /oracle/app/11.2.0/grid/root.sh
Execute /oracle/app/oraInventory/orainstRoot.sh on the following nodes:
[qhitnmdb1, qhitnmdb2]
Execute /oracle/app/11.2.0/grid/root.sh on the following nodes:
[qhitnmdb1, qhitnmdb2]
.................................................. 100% Done.
Execute Root Scripts successful.
As install user, execute the following script to complete the configuration.
1. /oracle/app/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>
Note:
1. This script must be run on the same host from where installer was run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
Successfully Setup Software.
在所有节点执行脚本成功之后，返回到安装gi的节点，使用grid用户继续执行以上安装日志中提到的configToolAllCommands：
需要创建一个cfgrsp.properties空文件来确保configToolAllCommands脚本的成功：
$ touch /u01/app/11.2.0/grid/cfgtoollogs/cfgrsp.properties
su - root
# chmod 600 cfgrsp.properties
# ls -rtl /u01/app/11.2.0/grid/cfgtoollogs
-rw------- 1 grid oinstall 330 Apr 30 11:50 /u01/app/11.2.0/grid/cfgtoollogs/cfgrsp.properties
su - grid
$cd /u01/app/11.2.0/grid/cfgtoollogs/
$./configToolAllCommands RESPONSE_FILE=/u01/app/11.2.0/grid/cfgtoollogs/cfgrsp.properties
GI软件安装完成。执行以下命令来确保集群服务的启动情况
crsctl stat res -t
crsctl stat res -t -init
crsctl check cluster -all
crsctl命令无法正常使用：
occur "libcap.so.1: cannot open shared object file" during Install oracle Grid ifrastructure
Performing root user operation for Oracle 11g
a.查找是否已正确安装并生成了lib文件
shadcdlora08:~ # rpm -qa|grep libcap
libcap2-32bit-2.11-2.17.1
libcap2-2.11-2.17.1
b.很明显 libcap包已安装过了，为什么oracle不会自动去寻找呢，继续查找
shadcdlora08:/ # find / -name libcap*
/lib/libcap.so.2
/lib/libcap.so.2.11
/lib64/libcap.so.2
/lib64/libcap.so.2.11
/lib64/libcap.so.1.10
libcap.so.1 不存在
c.根据错误提示缺少libcap.so.1，为其建立一个软连接
shadcdlora08:~ # cd /lib64
shadcdlora08:~ # ln -s libcap.so.1.10 libcap.so.1
shadcdlora08# ls -al libcap*
lrwxrwxrwx 1 root root 14 Aug 1 17:22 libcap.so.1 -> libcap.so.1.10
-rwxr-xr-x 1 root root 14792 Feb 21 2009 libcap.so.1.10
lrwxrwxrwx 1 root root 14 Jul 17 23:53 libcap.so.2 -> libcap.so.2.11
-rwxr-xr-x 1 root root 19016 Nov 5 2011 libcap.so.2.11
3.创建ASM磁盘组：
SQL> create diskgroup data external redundancy
2 disk
3 '/dev/oracleasm/disks/DATA01',
4 '/dev/oracleasm/disks/DATA02'
5 ATTRIBUTE 'compatible.asm'='11.2.0.0.0';
Diskgroup created.
SQL> create diskgroup arch external redundancy
2 disk
3 '/dev/oracleasm/disks/ARCH01',
4 '/dev/oracleasm/disks/ARCH02'
5 ATTRIBUTE 'compatible.asm'='11.2.0.0.0'
6 ;
Diskgroup created.
SQL> select group_number,name,state from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 OCRVDISK MOUNTED
2 DATA MOUNTED
3 ARCH MOUNTED
确保RAC所有节点都成功MOUNT，如果其他节点没有MOUNT，执行alter diskgroup mount;命令加载ASM磁盘组。
4.安装数据库软件
[oracle@localhost ~]$ cat db_install.rsp
####################################################################
## 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
#
# 选择安装类型：1.只装数据库软件 2.安装数据库软件并建库 3.升级数据库
#-------------------------------------------------------------------------------
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)
#
# 指定操作系统主机名，通过hostname命令获得
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#
# 指定oracle inventory目录的所有者，通常会是oinstall或者dba
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#
# 指定产品清单oracle inventory目录的路径
#-------------------------------------------------------------------------------
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
#
# 指定数据库语言，可以选择多个，用逗号隔开。选择en, zh_CN(英文和简体中文)
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=en
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#
# 设置ORALCE_HOME的路径
#------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#
# 设置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
#------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
#------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# - EE : Enterprise Edition
# - SE : Standard Edition
#
# 选择Oracle安装数据库软件的版本（企业版，标准版，标准版1），不同的版本功能不同
#------------------------------------------------------------------------------
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的组件：
# 选择false，则会使用默认的组件
# 选择true，否则需要自己在下面一条参数将要安装的组件一一列出。
# 安装相应版权后会安装所有的组件，后期如果缺乏某个组件，再次安装会非常的麻烦。
#------------------------------------------------------------------------------
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
# - 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
#------------------------------------------------------------------------------
###############################################################################
# #
# 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.
#
# 指定拥有OSDBA、OSOPER权限的用户组，通常会是dba组
#------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=oinstall
#------------------------------------------------------------------------------
# Specify the cluster node names selected during the installation.
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#
# RAC的安装，在这里指定所有的节点
#------------------------------------------------------------------------------
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=GENERAL_PURPOSE
#------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
#
# 指定GlobalName
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=itmsmdj
#------------------------------------------------------------------------------
# Specify the Starter Database SID.
#
# 指定SID
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=itmsmdj
#------------------------------------------------------------------------------
# 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=ZHS16GBK
#------------------------------------------------------------------------------
# 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.
#
# 11g的新特性自动内存管理，也就是SGA_TARGET和PAG_AGGREGATE_TARGET都#不用设置了，Oracle会自动调配两部分大小。
#------------------------------------------------------------------------------
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自动管理内存的大小，最小是512MB
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=2560
#------------------------------------------------------------------------------
# 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=admin123
#-------------------------------------------------------------------------------
# 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
#
# 数据库本地管理工具DB_CONTROL，远程集中管理工具GRID_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.control=DB_CONTROL
#-------------------------------------------------------------------------------
# Specify the Management Service to use if Grid Control is selected to manage
# the database.
#
# GRID_CONTROL需要设定grid control的远程路径URL
#-------------------------------------------------------------------------------
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.
#
# 设置自动备份，和OUI里的自动备份一样
#------------------------------------------------------------------------------
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.
#
# 自动备份会启动一个job，指定启动JOB的系统用户ID
#------------------------------------------------------------------------------
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.
#
# 自动备份会开启一个job，需要指定OSUser的密码
#-------------------------------------------------------------------------------
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
#
# 自动备份，要求指定使用的文件系统存放数据库文件还是ASM
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
# 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
#
# 使用文件系统存放数据库文件才需要指定数据文件、控制文件、Redo log的存放目录
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata/itmsmdj
#-------------------------------------------------------------------------------
# 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=/u01/app/oracle/backup
#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#
# 使用ASM存放数据库文件才需要指定存放的磁盘组
#-------------------------------------------------------------------------------
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
#
# 使用ASM存放数据库文件才需要指定ASM实例密码
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com
#
# 指定metalink账户用户名
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example : MYORACLESUPPORT_PASSWORD=password
#
# 指定metalink账户密码
#------------------------------------------------------------------------------
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
#
# 用户是否可以设置metalink密码
#------------------------------------------------------------------------------
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
#
# False表示不需要设置安全更新，注意，在11.2的静默安装中疑似有一个BUG
# Response File中必须指定为true，否则会提示错误,不管是否正确填写了邮件地址
#------------------------------------------------------------------------------
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.
#
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=https://orasupporthub.company.com:8080/
#------------------------------------------------------------------------------
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=
#------------------------------------------------------------------------------
# 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=
[oracle@localhost ~]$
执行静默安装
[oracle@localhost database]$ ./runInstaller -silent -ignorePrereq -showProgress -responseFile /home/oracle/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 33913 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5119 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-12-30_03-11-54AM. Please wait ...[oracle@localhost database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2020-12-30_03-11-54AM.log
Prepare in progress.
.................................................. 9% Done.
Prepare successful.
Copy files in progress.
.................................................. 14% Done.
.................................................. 20% Done.
.................................................. 26% Done.
.................................................. 31% Done.
.................................................. 36% Done.
.................................................. 41% Done.
.................................................. 46% Done.
.................................................. 51% Done.
.................................................. 56% Done.
.................................................. 63% Done.
.................................................. 68% Done.
.................................................. 73% Done.
.................................................. 78% Done.
.................................................. 83% Done.
..............................
Copy files successful.
Link binaries in progress.
..........
Link binaries successful.
Setup files in progress.
.................................................. 88% Done.
.................................................. 94% Done.
Setup files successful.
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2020-12-30_03-11-54AM.log' for more details.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/11.2.0/db_1/root.sh
.................................................. 100% Done.
Execute Root Scripts successful.
Successfully Setup Software.
[oracle@localhost database]$
根据提示执行脚本
[root@localhost oracle]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@localhost oracle]#
[root@localhost oracle]#
[root@localhost oracle]# cat /u01/app/oracle/product/11.2.0/db_1/install/root_localhost.localdomain_2020-12-30_03-19-21.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Finished product-specific root actions.
[root@localhost oracle]#
5.创建监听
[oracle@localhost database]$ netca -silent -responsefile /home/oracle/database/response/netca.rsp
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/11.2.0/db_1/lib/libnjni11.so: libclntsh.so.11.1: cannot open shared object file: No such file or directory
java.lang.UnsatisfiedLinkError: jniGetOracleHome
at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)
at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)
at oracle.net.ca.NetCALogger.getOracleHome(NetCALogger.java:230)
at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:215)
at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130)
at oracle.net.ca.NetCA.main(NetCA.java:427)
Error: jniGetOracleHome
Oracle Net Services configuration failed. The exit code is 1
[oracle@localhost database]$、
根据错误，缺少库文件
[oracle@localhost database]$ cd $ORACLE_HOME/inventory/Scripts/ext/lib/
[oracle@localhost lib]$ cp libclntsh.so.11.1 $ORACLE_HOME/lib
[oracle@localhost lib]$ netca -silent -responsefile /home/oracle/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@localhost lib]$
6.dbca静默建库
##############################################################################
## ##
## 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
#
# 操作类型：创建数据库
# 可选还有创建模版从数据库，创建克隆模版，删除数据库，配置数据库，添加实例（只限RAC），删除实例（只限RAC）
#-----------------------------------------------------------------------------
OPERATION_TYPE = "createDatabase"
#-----------------------*** End of GENERAL section ***------------------------
#-----------------------------------------------------------------------------
# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".
#
# 当操作类型选择创建数据库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
#
# 数据库的全局数据库名称：SID+主机名
#-----------------------------------------------------------------------------
GDBNAME = "orcl11g.us.oracle.com"
#-----------------------------------------------------------------------------
# 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）:SID
#-----------------------------------------------------------------------------
SID = "orcl11g"
#-----------------------------------------------------------------------------
# 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 = "password"
#-----------------------------------------------------------------------------
# Name : SYSTEMPASSWORD
# Datatype : String
# Description : Password for SYSTEM user
# Valid values : Check Oracle11g Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
#SYSTEMPASSWORD = "password"
#-----------------------------------------------------------------------------
# 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 = "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=
#-----------------------------------------------------------------------------
# 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 =
#-----------------------------------------------------------------------------
# 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 = "US7ASCII"
#-----------------------------------------------------------------------------
# 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 会启用这个选项
#-----------------------------------------------------------------------------
[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
#
# 给源数据库创建模版：主机名+1521+SID
#-----------------------------------------------------------------------------
SOURCEDB = "myhost:1521:orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#
# 使用的数据库角色是system
#-----------------------------------------------------------------------------
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 使用下面的选项
#-----------------------------------------------------------------------------
[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
#
# 克隆源数据库的SID
#-----------------------------------------------------------------------------
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启动下面的选项
#-----------------------------------------------------------------------------
[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启用下面的选项
#-----------------------------------------------------------------------------
[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启动下面的选项
#-----------------------------------------------------------------------------
[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启动下面选项
#-----------------------------------------------------------------------------
[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 ***------------------------
执行脚本创建数据库
[oracle@localhost ~]$ dbca -silent -responseFile database/response/dbca.rsp
Copying database files
1% complete
2% complete
4% complete
37% complete
Creating and starting Oracle instance
38% complete
40% complete
45% complete
50% complete
51% complete
56% complete
57% complete
61% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
74% complete
85% complete
86% complete
98% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/itmsmdj/itmsmdj.log" for further details.
[oracle@localhost ~]$
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
