概要
在RHEL7静默方式安装oracle database 12.2 RAC.
一、环境配置
1. 配置hosts文件
cp /etc/hosts /etc/hosts_$(date +%Y%d%m)cat > /etc/hosts << EOF127.0.0.1 loopback localhost.localdomain localhost# Public192.168.10.166 orc1.example.com orc1192.168.10.167 orc2.example.com orc2# Private172.168.0.156 orc1-priv.example.com orc1-priv172.168.0.157 orc2-priv.example.com orc2-priv# Virtual192.168.10.168 orc1-vip.example.com orc1-vip192.168.10.169 orc2-vip.example.com orc2-vip# SCAN#192.168.10.170 orc12c-scan#192.168.10.171 orc12c-scan#192.168.10.172 orc12c-scanEOF
2. install packages requirements
cat > /tmp/db_req_rpm.txt << EOFbinutilscompat-libcap1compat-libstdc++-33compat-libstdc++-33.i686gccgcc-c++glibc.i686glibcglibc-develglibc-devel.i686kshlibgcc.i686libgcclibstdc++libstdc++.i686libstdc++-devellibstdc++-devel.i686libaiolibaio.i686libaio-devellibaio-devel.i686libXextlibXext.i686libXtstlibXtst.i686libX11libX11.i686libXaulibXau.i686libxcblibxcb.i686libXilibXi.i686makesysstatunixODBCunixODBC.i686unixODBC-develunixODBC-devel.i686libdmxxorg-x11-utilsxorg-x11-xauthlibXvlibXtlibXmulibXxf86misclibXxf86dgaLibXxf86vmdevice-mapper-multipathzlibzlib-devel.i686zlib-develunzipnfs-utilssmartmontoolsxorg-x11-server-utilspsmiscEOFcat > /etc/yum.repos.d/rhel7.repo << EOF[rhel-Packages]name=Red Hat Enterprise Linux \$releasever - \$basearch - Sourcebaseurl=file:///mntenabled=1gpgcheck=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-releaseEOFmount /dev/sr0 /mntif [[ -f "/mnt/RPM-GPG-KEY-redhat-release" ]]; then yum -y install $(awk '{print $1}' /tmp/db_req_rpm.txt) >> /tmp/db_req_rpm_install.logfi
3. 屏蔽RemoveIPC参数 [ rhel 7.2 BUG Doc ID 2081410.1 ]
if [[ -f "/etc/systemd/logind.conf" ]]; then cp /etc/systemd/logind.conf /etc/systemd/logind.conf_$(date +%Y%m%d) sed -i "/#RemoveIPC=no/c\#RemoveIPC=no\nRemoveIPC=no" /etc/systemd/logind.confelse cat > /etc/systemd/logind.conf << EOFRemoveIPC=noEOFfi-- 重启服务器或重启systemd-logindsystemctl daemon-reloadsystemctl restart systemd-logind
4. 关闭selinux
if [[ "$(getenforce)" = "Enforcing" ]]; then cp /etc/selinux/config /etc/selinux/config_$(date +%Y%m%d) setenforce 0 sed -i "/^SELINUX=enforcing/c\#SELINUX=enforcing\nSELINUX=disable" /etc/selinux/configfi
5. 关闭防火墙
if [[ "$(ps -ef |grep -v grep|grep -ci firewalld)" = "1" ]]; then systemctl stop firewalld systemctl disable firewalldfi
6. 配置系统参数
cp /etc/sysctl.conf /etc/sysctl.conf_$(date +%Y%m%d)cat > /etc/sysctl.conf << EOF# sysctl settings are defined through files in# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.## Vendors settings live in /usr/lib/sysctl.d/.# To override a whole file, create a new file with the same in# /etc/sysctl.d/ and put new settings there. To override# only specific settings, add a file with a lexically later# name in /etc/sysctl.d/ and put new settings there.## For more information, see sysctl.conf(5) and sysctl.d(5).vm.swappiness = 1vm.dirty_background_ratio = 3vm.dirty_ratio = 80vm.dirty_expire_centisecs = 500vm.dirty_writeback_centisecs = 100kernel.shmmax = 4398046511104kernel.shmall = 1073741824kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.panic_on_oops = 1net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2kernel.panic_on_oops = 1EOF # 启用参数 sysctl -p
7. 关闭avahi-daemon服务
if [[ -f "/etc/systemd/system/dbus-org.freedesktop.Avahi.service" ]]; then systemctl stop avahi-dnsconfd systemctl stop avahi-daemon systemctl disable avahi-dnsconfd systemctl disable avahi-daemonfi
8. 创建用户&用户组
# 创建用户组groupadd --gid 54321 oinstallgroupadd --gid 54322 dbagroupadd --gid 54323 asmdbagroupadd --gid 54324 asmopergroupadd --gid 54325 asmadmingroupadd --gid 54326 opergroupadd --gid 54327 backupdbagroupadd --gid 54328 dgdbagroupadd --gid 54329 kmdbagroupadd --gid 54330 racdba# 创建用户useradd --uid 54321 --gid oinstall --groups dba,oper,asmdba,asmoper,backupdba,dgdba,kmdba,racdba --comment "Oracle Software Owner" oracleuseradd --uid 54322 --gid oinstall --groups dba,asmadmin,asmdba,asmoper --comment "Grid Infrastructure Owner" grid# 设置用户密码OS_PASS=123456echo "${OS_PASS}"|passwd --stdin oracleecho "${OS_PASS}"|passwd --stdin grid 9. 创建软基纳目录
mkdir -p /ups/oracle/gridmkdir -p /ups/oracle/12.2/gridmkdir -p /ups/oracle/oraInventorychown -R grid:oinstall /ups/oraclemkdir -p /ups/oracle/databasechown oracle:oinstall /ups/oracle/databasechmod -R 775 /ups/oracle
10. 编辑用户环境变量
su - gridvi ~/.bash_profileexport ORACLE_SID=+ASM1export ORACLE_BASE=/ups/oracle/gridexport ORACLE_HOME=/ups/oracle/12.2/gridexport PATH=${PATH}:${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatchumask 022su - oraclevi ~/.bash_profileexport ORACLE_SID=orcl1export ORACLE_BASE=/ups/oracle/databaseexport ORACLE_HOME=${ORACLE_BASE}/product/12.2/db_1export GRID_HOME=/ups/oracle/12.2/gridexport LD_LIBRARY_PATH=${ORACLE_HOME}/libexport PATH=${PATH}:${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${GRID_HOME}/bin:${HOME}/dbaexport TNS_ADMIN=${GRID_HOME}/network/adminumask 022 11. Setting Shell Limits for the Grid and Oracle User
cat > /etc/security/limits.d/99-grid-oracle-limits.conf << EOForacle soft nproc 16384 #Ora bug 15971421oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768# setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAMoracle soft memlock 3145728 # current size is 3GBoracle hard memlock 3145728 #grid soft nproc 16384 #Ora bug 15971421grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 10240grid hard stack 32768grid soft memlock 3145728grid hard memlock 3145728EOF
12. huge pages script
#!/bin/bashKERN=`uname -r | awk -F. '{ printf("%d.%d\n",$1,$2); }'`# Find out the HugePage sizeHPG_SZ=`grep Hugepagesize /proc/meminfo | awk '{print $2}'`# Start from 1 pages to be on the safe side and guarantee 1 free HugePageNUM_PG=1# Cumulative number of pages required to handle the running shared memory segmentsfor SEG_BYTES in `ipcs -m | awk '{print $5}' | grep "[0-9][0-9]*"`doMIN_PG=`echo "$SEG_BYTES/($HPG_SZ*1024)" | bc -q`if [ $MIN_PG -gt 0 ]; thenNUM_PG=`echo "$NUM_PG+$MIN_PG+1" | bc -q`fidone# Finish with resultscase $KERN in'2.4') HUGETLB_POOL=`echo "$NUM_PG*$HPG_SZ/1024" | bc -q`;echo "Recommended setting: vm.hugetlb_pool = $HUGETLB_POOL" ;;'2.6') MEM_LOCK=`echo "$NUM_PG*$HPG_SZ" | bc -q`;echo "Recommended setting within the kernel boot command line: hugepages = $NUM_PG"echo "Recommended setting within /etc/security/limits.d/99-grid-oraclelimits.conf: oracle soft memlock $MEM_LOCK"echo "Recommended setting within /etc/security/limits.d/99-grid-oraclelimits.conf: oracle hard memlock $MEM_LOCK" ;;'3.10') MEM_LOCK=`echo "$NUM_PG*$HPG_SZ" | bc -q`;echo "Recommended setting within the kernel boot command line: hugepages = $NUM_PG"echo "Recommended setting within /etc/security/limits.d/99-grid-oraclelimits.conf: oracle soft memlock $MEM_LOCK"echo "Recommended setting within /etc/security/limits.d/99-grid-oraclelimits.conf: oracle hard memlock $MEM_LOCK" ;;*) echo "Unrecognized kernel version $KERN. Exiting." ;;esac 13. 配置profile
cat > /etc/profile.d/oracle-grid.sh << EOF#Setting the appropriate ulimits for oracle and grid userif [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -u 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifiif [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -u 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifiEOF
14. configurate the network of nozeroconf
cp /etc/sysconfig/network /etc/sysconfig/network_$(date +%Y%m%d)cat >> /etc/sysconfig/network << EOFNOZEROCONF=yesEOF
15. 关闭 transparent_hugepage
cp /etc/default/grub /etc/default/grub_$(date +%Y%m%d)cat > /etc/default/grub << EOFGRUB_TIMEOUT=5GRUB_DISTRIBUTOR="\$(sed 's, release .*$,,g' /etc/system-release)"GRUB_DEFAULT=savedGRUB_DISABLE_SUBMENU=trueGRUB_TERMINAL_OUTPUT="console"# GRUB_CMDLINE_LINUX="rd.lvm.lv=rootvg/lvroot rd.lvm.lv=rootvg/lvswap rhgb quiet"GRUB_CMDLINE_LINUX="rd.lvm.lv=rootvg/lvroot rd.lvm.lv=rootvg/lvswap quiet transparent_hugepage=never"GRUB_DISABLE_RECOVERY="true"EOFgrub2-mkconfig -o /boot/grub2/grub.cfg
16. 配置时间同步
1）时区--查看当前时区# timedatectl status--修改时区# timedatectl set-timezone Asia/ShangHai2）配置# 安装yum install chrony -ysystemctl start chronydsystemctl enable chronydsystemctl status chronydsystemctl stop chronydsystemctl disable chronyd# 添加同步服务器cp /etc/chrony.conf /etc/chrony.conf_$(date +%Y%m%d)server 192.168.10.166 iburst# 检查状态[root@orcl2 ~]# chronyc sources -v210 Number of sources = 1 .-- Source mode '^' = server, '=' = peer, '#' = local clock. / .- Source state '*' = current synced, '+' = combined , '-' = not combined,| / '?' = unreachable, 'x' = time may be in error, '~' = time too variable.|| .- xxxx [ yyyy ] +/- zzzz|| Reachability register (octal) -. | xxxx = adjusted offset,|| Log2(Polling interval) --. | | yyyy = measured offset,|| \ | | zzzz = estimated error.|| | | \MS Name/IP address Stratum Poll Reach LastRx Last sample===============================================================================^? orcl1.example.com 0 6 0 10y +0ns[ +0ns] +/- 0ns[root@orcl2 ~]# chronyc sourcestats -v210 Number of sources = 1 .- Number of sample points in measurement set. / .- Number of residual runs with same sign. | / .- Length of measurement set (time). | | / .- Est. clock freq error (ppm). | | | / .- Est. error in freq. | | | | / .- Est. offset. | | | | | | On the -. | | | | | | samples. \ | | | | | | |Name/IP Address NP NR Span Frequency Freq Skew Offset Std Dev==============================================================================orcl1.example.com 0 0 0 +0.000 2000.000 +0ns 4000ms[root@orcl2 ~]#
17. 配置dns
# yum 安装yum -y install unboundyum install -y bind-utils# 配置配置文件/etc/unbound/unbound.confvi /etc/unbound/unbound.conf……38 # interface: 0.0.0.039 interface: 0.0.0.0……//找到38行，复制去掉注释行，打开监听全网功能。177 # access-control: 0.0.0.0/0 refuse178 access-control: 192.168.10.0/24 allow179 # access-control: 127.0.0.0/8 allow// 找到配置文件/etc/unbound/unbound.conf的第177行，缺省为注释行，且内容为拒绝访问。复制本行内容到下面一行，去掉注释“#“，改refuse为allow。然后保存退出，重启服务即可。155 # do-ip6: yes156 do-ip6: no//找到155行内容，在其下复制一行并去除注释，改yes为no，重启服务即可去除对Ipv6的监听# 创建解析文件[root@orc1 ~]# catcat > /etc/unbound/local.d/example.conf << EOFlocal-zone: "example.com." staticlocal-data: "example.com. 86400 IN SOA ns.example.com. root 1 1D 1H 1W 1H"local-data: "ns.example.com. IN A 192.168.10.166"local-data: "orc1.example.com. IN A 192.168.10.166"local-data: "orc12c-scan.example.com. IN A 192.168.10.170"local-data: "orc12c-scan.example.com. IN A 192.168.10.171"local-data: "orc12c-scan.example.com. IN A 192.168.10.172"local-data-ptr: "192.168.10.170 orc12c-scan.example.com."local-data-ptr: "192.168.10.171 orc12c-scan.example.com."local-data-ptr: "192.168.10.172 orc12c-scan.example.com."EOF# 启动服务及检查systemctl start unboundsystemctl restart unboundsystemctl status unboundnetstat -tunlp |grep unbound
18. 配置共享存储
# 获取配置命令for i in c d e f gdoecho "KERNEL==\"sd?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"asm-disk$i\",OWNER=\"grid\", GROUP=\"asmadmin\",MODE=\"0660\"" >>/etc/udev/rules.d/99-oracle-asmdevices.rulesdone# 将上面结果写入文件，例如：cat > /etc/udev/rules.d/99-oracle-asmdevices.rules << EOFENV{DM_NAME}=="asm_crs1", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="mapper/\$env{DM_NAME}"ENV{DM_NAME}=="asm_crs2", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="mapper/\$env{DM_NAME}"ENV{DM_NAME}=="asm_crs3", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="mapper/\$env{DM_NAME}"ENV{DM_NAME}=="asm_mgmt1", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="mapper/\$env{DM_NAME}"ENV{DM_NAME}=="asm_data1", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="mapper/\$env{DM_NAME}"EOF# 重启生效/sbin/udevadm trigger --type=devices --action=change 19. 配置ssh互相
ssh-keygen -t rsa -P '' -f ~/.ssh/id_rsassh-keygen -t dsa -P '' -f ~/.ssh/id_dsacat ~/.ssh/*.pub >> ~/.ssh/authorized_keysssh -o stricthostkeychecking=no 192.168.0.12 cat ~/.ssh/*.pub >> ~/.ssh/authorized_keysscp ~/.ssh/authorized_keys 192.168.0.12:~/.ssh/authorized_keys# 检查确认ssh -o stricthostkeychecking=no orc1.example.com datessh -o stricthostkeychecking=no orc2.example.com datessh -o stricthostkeychecking=no orc1-priv.example.com datessh -o stricthostkeychecking=no orc2-priv.example.com datessh -o stricthostkeychecking=no orc1 datessh -o stricthostkeychecking=no orc2 date
二、Oracle软件安装
1. 解压grid software
1 unzip -q /ups/soft/linuxx64_12201_grid_home.zip -d /ups/oracle/12.2/grid
2. 安装cvuqdisk--所有节点
1 cd /ups/oracle/12.2/grid/cv/rpm2 rpm -ivh cvuqdisk-1.0.10-1.rpm3 4 scp /ups/oracle/12.2/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm orc2:/tmp/5 ssh -o stricthostkeychecking=no orc26 rpm -ivh /tmp/cvuqdisk-1.0.10-1.rpm
3. 检查环境
1 cd /ups/oracle/12.2/grid/2 ./runcluvfy.sh stage -pre crsinst -n orc1,orc2 -fixup -verbose > ~/grid_env_check.txt
4. 安装GI软件
1 cd /ups/oracle/12.2/grid/2 ./gridSetup.sh -silent -responseFile ~/.giinstall.rsp -skipPrereqs
~/.giinstall.rsp 内容如下：
################################################################################# Copyright(c) Oracle Corporation 1998,2017. 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_v12.2.0################################################################################ ## SECTION A - BASIC ## #################################################################################-------------------------------------------------------------------------------# Specify the location which holds the inventory files.# This is an optional parameter if installing on# Windows based Operating System.#-------------------------------------------------------------------------------INVENTORY_LOCATION=/ups/oracle/oraInventory#-------------------------------------------------------------------------------# Specify the installation option.# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY or HA_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)# - HA_SWONLY : To install clusterware files only (can be configured for stand# alone server later. This is only supported on Windows.)#-------------------------------------------------------------------------------oracle.install.option=CRS_CONFIG#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Base.#-------------------------------------------------------------------------------ORACLE_BASE=/ups/oracle/grid#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Home.#-------------------------------------------------------------------------------ORACLE_HOME=/ups/oracle/12.2/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 OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.#-------------------------------------------------------------------------------oracle.install.asm.OSDBA=asmdba#-------------------------------------------------------------------------------# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.# The value to be specified for OSOPER group is optional.# Value should not be provided if configuring Client Cluster - i.e. storageOption=CLIENT_ASM_STORAGE.#-------------------------------------------------------------------------------oracle.install.asm.OSOPER=asmoper#-------------------------------------------------------------------------------# The OSASM_GROUP is the OS group which is to be granted SYSASM 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=orcl-scan#-------------------------------------------------------------------------------# Specify a unused port number for SCAN service#-------------------------------------------------------------------------------oracle.install.crs.config.gpnp.scanPort=1522################################################################################# ## SECTION D - CLUSTER & GNS ## ##################################################################################-------------------------------------------------------------------------------# Specify the required cluster configuration# Allowed values: STANDALONE, DOMAIN, MEMBERDB, MEMBERAPP#-------------------------------------------------------------------------------oracle.install.crs.config.ClusterConfiguration=STANDALONE#-------------------------------------------------------------------------------# Specify 'true' if you would like to configure the cluster as Extended, else# specify 'false'## Applicable only for STANDALONE and DOMAIN cluster configuration#-------------------------------------------------------------------------------oracle.install.crs.config.configureAsExtendedCluster=false#-------------------------------------------------------------------------------# Specify the Member Cluster Manifest file## Applicable only for MEMBERDB and MEMBERAPP cluster configuration#-------------------------------------------------------------------------------oracle.install.crs.config.memberClusterManifestFile=#-------------------------------------------------------------------------------# 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(_).## Applicable only for STANDALONE and DOMAIN cluster configuration#-------------------------------------------------------------------------------oracle.install.crs.config.clusterName=orcl-cluster#-------------------------------------------------------------------------------# Applicable only for STANDALONE, DOMAIN, MEMBERDB cluster configuration.# Specify 'true' if you would like to configure Grid Naming Service(GNS), else# specify 'false'#-------------------------------------------------------------------------------oracle.install.crs.config.gpnp.configureGNS=false#-------------------------------------------------------------------------------# Applicable only for STANDALONE and DOMAIN cluster configuration if you choose to configure GNS.# Specify 'true' if you would like to assign SCAN name VIP and Node VIPs by DHCP# , else specify 'false'#-------------------------------------------------------------------------------oracle.install.crs.config.autoConfigureClusterNodeVIP=false#-------------------------------------------------------------------------------# Applicable only if you choose to configure GNS.# Specify the type of GNS configuration for cluster# Allowed values are: CREATE_NEW_GNS and USE_SHARED_GNS# Only USE_SHARED_GNS value is allowed for MEMBERDB cluster configuration.#-------------------------------------------------------------------------------oracle.install.crs.config.gpnp.gnsOption=#-------------------------------------------------------------------------------# Applicable only if SHARED_GNS is being configured for cluster# Specify the path to the GNS client data file#-------------------------------------------------------------------------------oracle.install.crs.config.gpnp.gnsClientDataFile=#-------------------------------------------------------------------------------# Applicable only for STANDALONE and DOMAIN cluster configuration if you choose to# configure GNS for this cluster oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS# Specify the GNS subdomain and an unused virtual hostname for GNS service#-------------------------------------------------------------------------------oracle.install.crs.config.gpnp.gnsSubDomain=oracle.install.crs.config.gpnp.gnsVIPAddress=#-------------------------------------------------------------------------------# Specify the list of sites - only if configuring an Extended Cluster#-------------------------------------------------------------------------------oracle.install.crs.config.sites=#-------------------------------------------------------------------------------# Specify the list of nodes that have to be configured to be part of the cluster.## The list should a comma-separated list of tuples. Each tuple should be a# colon-separated string that contains# - 1 field if configuring an Application Cluster, or# - 3 fields if configuring a Flex Cluster# - 4 fields if configuring an Extended Cluster## The fields should be ordered as follows:# 1. The first field should be the public node name.# 2. The second field should be the virtual host name# (Should be specified as AUTO if you have chosen 'auto configure for VIP'# i.e. autoConfigureClusterNodeVIP=true)# 3. The third field indicates the role of node (HUB,LEAF). This has to# be provided only if Flex Cluster is being configured.# For Extended Cluster only HUB should be specified for all nodes# 4. The fourth field indicates the site designation for the node. To be specified only if configuring an Extended Cluster.# The 2nd and 3rd fields are not applicable if configuring an Application Cluster## Examples# For configuring Application Cluster: oracle.install.crs.config.clusterNodes=node1,node2# For configuring Flex Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip:HUB,node2:node2-vip:LEAF# For configuring Extended Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip:HUB:site1,node2:node2-vip:HUB:site2# You can specify a range of nodes in the tuple using colon separated fields of format# hostnameprefix:lowerbound-upperbound:hostnamesuffix:vipsuffix:role of node##-------------------------------------------------------------------------------oracle.install.crs.config.clusterNodes=orcl1:orcl1-vip:HUB,orcl2:orcl2-vip:HUB#-------------------------------------------------------------------------------# 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", "3", "4", or "5"# InterfaceType stand for the following values# - 1 : PUBLIC# - 2 : PRIVATE# - 3 : DO NOT USE# - 4 : ASM# - 5 : ASM & PRIVATE## 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=bond0:192.168.10.0:1,bond1:172.168.0.0:5#------------------------------------------------------------------------------# Create a separate ASM DiskGroup to store GIMR data.# Specify 'true' if you would like to separate GIMR data with clusterware data,# else specify 'false'# Value should be 'true' for DOMAIN cluster configurations# Value can be true/false for STANDALONE cluster configurations.#------------------------------------------------------------------------------oracle.install.asm.configureGIMRDataDG=false################################################################################# ## SECTION E - STORAGE ## ##################################################################################-------------------------------------------------------------------------------# Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting# Disks files# - FLEX_ASM_STORAGE# - CLIENT_ASM_STORAGE## Applicable only for MEMBERDB cluster configuration#-------------------------------------------------------------------------------oracle.install.crs.config.storageOption=################################################################################# ## 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 ## ##################################################################################-------------------------------------------------------------------------------# ASM Storage Type# Allowed values are : ASM and ASM_ON_NAS# ASM_ON_NAS applicable only if# oracle.install.crs.config.ClusterConfiguration=STANDALONE#-------------------------------------------------------------------------------oracle.install.asm.storageOption=ASM#-------------------------------------------------------------------------------# NAS location to create ASM disk group for storing OCR/VDSK# Specify the NAS location where you want the ASM disk group to be created# to be used to store OCR/VDSK files# Applicable only if oracle.install.asm.storageOption=ASM_ON_NAS#-------------------------------------------------------------------------------oracle.install.asmOnNAS.ocrLocation=#------------------------------------------------------------------------------# Create a separate ASM DiskGroup on NAS to store GIMR data# Specify 'true' if you would like to separate GIMR data with clusterware data, else# specify 'false'# Applicable only if oracle.install.asm.storageOption=ASM_ON_NAS#------------------------------------------------------------------------------oracle.install.asmOnNAS.configureGIMRDataDG=#-------------------------------------------------------------------------------# NAS location to create ASM disk group for storing GIMR data# Specify the NAS location where you want the ASM disk group to be created# to be used to store the GIMR database# Applicable only if oracle.install.asm.storageOption=ASM_ON_NAS# and oracle.install.asmOnNAS.configureGIMRDataDG=true#-------------------------------------------------------------------------------oracle.install.asmOnNAS.gimrLocation=#-------------------------------------------------------------------------------# Password for SYS user of Oracle ASM#-------------------------------------------------------------------------------oracle.install.asm.SYSASMPassword=p#ssw0rd123#-------------------------------------------------------------------------------# The ASM DiskGroup## Example: oracle.install.asm.diskGroup.name=data##-------------------------------------------------------------------------------oracle.install.asm.diskGroup.name=CRSDG#-------------------------------------------------------------------------------# Redundancy level to be used by ASM.# It can be one of the following# - NORMAL# - HIGH# - EXTERNAL# - FLEX# - EXTENDED (required if oracle.install.crs.config.ClusterConfiguration=EXTENDED)# 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# Example: oracle.install.asm.diskGroup.AUSize=4# size unit is MB##-------------------------------------------------------------------------------oracle.install.asm.diskGroup.AUSize=4#-------------------------------------------------------------------------------# Failure Groups for the disk group# If configuring for Extended cluster specify as list of "failure group name:site"# tuples.# Else just specify as list of failure group names#-------------------------------------------------------------------------------oracle.install.asm.diskGroup.FailureGroups=#-------------------------------------------------------------------------------# List of disks and their failure groups to create a ASM DiskGroup# (Use this if each of the disks have an associated failure group)# Failure Groups are not required if oracle.install.asm.diskGroup.redundancy=EXTERNAL# Example:# For Unix based Operating System:# oracle.install.asm.diskGroup.disksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName# For Windows based Operating System:# oracle.install.asm.diskGroup.disksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName##-------------------------------------------------------------------------------oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/mapper/asm_crs3,,/dev/mapper/asm_crs2,,/dev/mapper/asm_crs1,#-------------------------------------------------------------------------------# List of disks to create a ASM DiskGroup# (Use this variable only if failure groups configuration is not required)# 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/mapper/asm_crs3,/dev/mapper/asm_crs2,/dev/mapper/asm_crs1#-------------------------------------------------------------------------------# List of failure groups to be marked as QUORUM.# Quorum failure groups contain only voting disk data, no user data is stored# Example:# oracle.install.asm.diskGroup.quorumFailureGroupNames=FGName1,FGName2#-------------------------------------------------------------------------------oracle.install.asm.diskGroup.quorumFailureGroupNames=#-------------------------------------------------------------------------------# 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/mapper/*#-------------------------------------------------------------------------------# Password for ASMSNMP account# ASMSNMP account is used by Oracle Enterprise Manager to monitor Oracle ASM instances#-------------------------------------------------------------------------------oracle.install.asm.monitorPassword=p#ssw0rd123#-------------------------------------------------------------------------------# GIMR Storage data ASM DiskGroup# Applicable only when# oracle.install.asm.configureGIMRDataDG=true# Example: oracle.install.asm.GIMRDG.name=MGMT##-------------------------------------------------------------------------------oracle.install.asm.gimrDG.name=#-------------------------------------------------------------------------------# Redundancy level to be used by ASM.# It can be one of the following# - NORMAL# - HIGH# - EXTERNAL# - FLEX# - EXTENDED (only if oracle.install.crs.config.ClusterConfiguration=EXTENDED)# Example: oracle.install.asm.gimrDG.redundancy=NORMAL##-------------------------------------------------------------------------------oracle.install.asm.gimrDG.redundancy=#-------------------------------------------------------------------------------# Allocation unit size to be used by ASM.# It can be one of the following values# - 1# - 2# - 4# - 8# - 16# Example: oracle.install.asm.gimrDG.AUSize=4# size unit is MB##-------------------------------------------------------------------------------oracle.install.asm.gimrDG.AUSize=#-------------------------------------------------------------------------------# Failure Groups for the GIMR storage data ASM disk group# If configuring for Extended cluster specify as list of "failure group name:site"# tuples.# Else just specify as list of failure group names#-------------------------------------------------------------------------------oracle.install.asm.gimrDG.FailureGroups=#-------------------------------------------------------------------------------# List of disks and their failure groups to create GIMR data ASM DiskGroup# (Use this if each of the disks have an associated failure group)# Failure Groups are not required if oracle.install.asm.gimrDG.redundancy=EXTERNAL# Example:# For Unix based Operating System:# oracle.install.asm.gimrDG.disksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName# For Windows based Operating System:# oracle.install.asm.gimrDG.disksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName##-------------------------------------------------------------------------------oracle.install.asm.gimrDG.disksWithFailureGroupNames=#-------------------------------------------------------------------------------# List of disks to create GIMR data ASM DiskGroup# (Use this variable only if failure groups configuration is not required)# Example:# For Unix based Operating System:# oracle.install.asm.gimrDG.disks=/oracle/asm/disk1,/oracle/asm/disk2# For Windows based Operating System:# oracle.install.asm.gimrDG.disks=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1##-------------------------------------------------------------------------------oracle.install.asm.gimrDG.disks=#-------------------------------------------------------------------------------# List of failure groups to be marked as QUORUM.# Quorum failure groups contain only voting disk data, no user data is stored# Example:# oracle.install.asm.gimrDG.quorumFailureGroupNames=FGName1,FGName2#-------------------------------------------------------------------------------oracle.install.asm.gimrDG.quorumFailureGroupNames=#-------------------------------------------------------------------------------# Configure AFD - ASM Filter Driver# Applicable only for FLEX_ASM_STORAGE option# Specify 'true' if you want to configure AFD, else specify 'false'#-------------------------------------------------------------------------------oracle.install.asm.configureAFD=false#-------------------------------------------------------------------------------# Configure RHPS - Rapid Home Provisioning Service# Applicable only for DOMAIN cluster configuration# Specify 'true' if you want to configure RHP service, else specify 'false'#-------------------------------------------------------------------------------oracle.install.crs.configureRHPS=false################################################################################# ## SECTION H - UPGRADE ## ##################################################################################-------------------------------------------------------------------------------# Specify whether to ignore down nodes during upgrade operation.# Value should be 'true' to ignore down nodes otherwise specify 'false'#-------------------------------------------------------------------------------oracle.install.crs.config.ignoreDownNodes=false################################################################################# ## MANAGEMENT OPTIONS ## ##################################################################################-------------------------------------------------------------------------------# Specify the management option to use for managing Oracle Grid Infrastructure# Options are:# 1. CLOUD_CONTROL - If you want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.# 2. NONE -If you do not want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.#-------------------------------------------------------------------------------oracle.install.config.managementOption=NONE#-------------------------------------------------------------------------------# Specify the OMS host to connect to Cloud Control.# Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.config.omsHost=#-------------------------------------------------------------------------------# Specify the OMS port to connect to Cloud Control.# Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.config.omsPort=#-------------------------------------------------------------------------------# Specify the EM Admin user name to use to connect to Cloud Control.# Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.config.emAdminUser=#-------------------------------------------------------------------------------# Specify the EM Admin password to use to connect to Cloud Control.# Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.config.emAdminPassword=################################################################################# ## Root script execution configuration ## ##################################################################################-------------------------------------------------------------------------------------------------------# Specify the root script execution mode.## - true : To execute the root script automatically by using the appropriate configuration methods.# - false : To execute the root script manually.## If this option is selected, password should be specified on the console.#-------------------------------------------------------------------------------------------------------oracle.install.crs.rootconfig.executeRootScript=false#--------------------------------------------------------------------------------------# Specify the configuration method to be used for automatic root script execution.## Following are the possible choices:# - ROOT# - SUDO#--------------------------------------------------------------------------------------oracle.install.crs.rootconfig.configMethod=#--------------------------------------------------------------------------------------# Specify the absolute path of the sudo program.## Applicable only when SUDO configuration method was chosen.#--------------------------------------------------------------------------------------oracle.install.crs.rootconfig.sudoPath=#--------------------------------------------------------------------------------------# Specify the name of the user who is in the sudoers list.## Applicable only when SUDO configuration method was chosen.#--------------------------------------------------------------------------------------oracle.install.crs.rootconfig.sudoUserName=#--------------------------------------------------------------------------------------# Specify the nodes batch map.## This should be a comma separated list of node:batch pairs.# During upgrade, you can sequence the automatic execution of root scripts# by pooling the nodes into batches.# A maximum of three batches can be specified.# Installer will execute the root scripts on all the nodes in one batch before# proceeding to next batch.# Root script execution on the local node must be in Batch 1.# Only one type of node role can be used for each batch.# Root script execution should be done first in all HUB nodes and then, when# existent, in all the LEAF nodes.## Examples:# 1. oracle.install.crs.config.batchinfo=HUBNode1:1,HUBNode2:2,HUBNode3:2,LEAFNode4:3# 2. oracle.install.crs.config.batchinfo=HUBNode1:1,LEAFNode2:2,LEAFNode3:2,LEAFNode4:2# 3. oracle.install.crs.config.batchinfo=HUBNode1:1,HUBNode2:1,LEAFNode3:2,LEAFNode4:3## Applicable only for UPGRADE install option.#--------------------------------------------------------------------------------------oracle.install.crs.config.batchinfo=################################################################################# ## APPLICATION CLUSTER OPTIONS ## ##################################################################################-------------------------------------------------------------------------------# Specify the Virtual hostname to configure virtual access for your Application# The value to be specified for Virtual hostname is optional.#-------------------------------------------------------------------------------oracle.install.crs.app.applicationAddress=
5. 创建MGMT管理资料库
1 /oracle/app/12.2.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/.giinstall.rsp -silent
6. 创建DATA asm diskgroup
1 asmca -silent -sysAsmPassword password -createDiskGroup -diskString '/dev/raw/*' -diskGroupName DATA -diskList '/dev/raw/raw3' -redundancy EXTERNAL -au_size 4
7. 安装database 软件
1 unzip /ups/soft/linuxx64_12201_database.zip 2 cd /ups/soft/database3 ./runInstaller -silent -ignorePrereqFailure -responseFile ~/.db.rsp
~/.db.rsp 响应文件如下：
###################################################################### Copyright(c) Oracle Corporation 1998,2017. 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_v12.2.0#-------------------------------------------------------------------------------# Specify the installation option.# It can be one of the following:# - INSTALL_DB_SWONLY# - INSTALL_DB_AND_CONFIG# - UPGRADE_DB#-------------------------------------------------------------------------------oracle.install.option=INSTALL_DB_SWONLY#-------------------------------------------------------------------------------# Specify the Unix group to be set for the inventory directory. #-------------------------------------------------------------------------------UNIX_GROUP_NAME=oinstall#-------------------------------------------------------------------------------# Specify the location which holds the inventory files.# This is an optional parameter if installing on# Windows based Operating System.#-------------------------------------------------------------------------------INVENTORY_LOCATION=/ups/oracle/oraInventory#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Home. #-------------------------------------------------------------------------------ORACLE_HOME=/ups/oracle/database/product/12.2/db_1#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Base. #-------------------------------------------------------------------------------ORACLE_BASE=/ups/oracle/database#-------------------------------------------------------------------------------# Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # - SE2 : Standard Edition 2#-------------------------------------------------------------------------------oracle.install.db.InstallEdition=EE################################################################################ ## PRIVILEGED OPERATING SYSTEM GROUPS ## ------------------------------------------ ## Provide values for the OS groups to which SYSDBA and SYSOPER 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 OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.#-------------------------------------------------------------------------------oracle.install.db.OSDBA_GROUP=dba#------------------------------------------------------------------------------# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.# The value to be specified for OSOPER group is optional.#------------------------------------------------------------------------------oracle.install.db.OSOPER_GROUP=oper#------------------------------------------------------------------------------# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.#------------------------------------------------------------------------------oracle.install.db.OSBACKUPDBA_GROUP=backupdba#------------------------------------------------------------------------------# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.#------------------------------------------------------------------------------oracle.install.db.OSDGDBA_GROUP=dgdba#------------------------------------------------------------------------------# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.#------------------------------------------------------------------------------oracle.install.db.OSKMDBA_GROUP=kmdba#------------------------------------------------------------------------------# The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.#------------------------------------------------------------------------------oracle.install.db.OSRACDBA_GROUP=racdba################################################################################ ## Grid Options ## #################################################################################------------------------------------------------------------------------------# Specify the type of Real Application Cluster Database# # - ADMIN_MANAGED: Admin-Managed# - POLICY_MANAGED: Policy-Managed# # If left unspecified, default will be ADMIN_MANAGED #------------------------------------------------------------------------------oracle.install.db.rac.configurationType=#------------------------------------------------------------------------------# Value is required only if RAC database type is ADMIN_MANAGED# # Specify the cluster node names selected during the installation.# Leaving it blank will result in install on local server only (Single Instance)# # Example : oracle.install.db.CLUSTER_NODES=node1,node2#------------------------------------------------------------------------------oracle.install.db.CLUSTER_NODES=orcl1,orcl2#------------------------------------------------------------------------------# 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=false#------------------------------------------------------------------------------# Value is required only if oracle.install.db.isRACOneInstall is true.# # Specify the name for RAC One Node Service#------------------------------------------------------------------------------oracle.install.db.racOneServiceName=#------------------------------------------------------------------------------# Value is required only if RAC database type is POLICY_MANAGED# # Specify a name for the new Server pool that will be configured# Example : oracle.install.db.rac.serverpoolName=pool1#------------------------------------------------------------------------------oracle.install.db.rac.serverpoolName=#------------------------------------------------------------------------------# Value is required only if RAC database type is POLICY_MANAGED# # Specify a number as cardinality for the new Server pool that will be configured# Example : oracle.install.db.rac.serverpoolCardinality=2#------------------------------------------------------------------------------oracle.install.db.rac.serverpoolCardinality=0################################################################################ ## Database Configuration Options ## #################################################################################-------------------------------------------------------------------------------# Specify the type of database to create.# It can be one of the following:# - GENERAL_PURPOSE # - DATA_WAREHOUSE # GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.type=GENERAL_PURPOSE#-------------------------------------------------------------------------------# Specify the Starter Database Global Database Name. #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.globalDBName=#-------------------------------------------------------------------------------# Specify the Starter Database SID.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.SID=#-------------------------------------------------------------------------------# Specify whether the database should be configured as a Container database.# The value can be either "true" or "false". If left blank it will be assumed# to be "false".#-------------------------------------------------------------------------------oracle.install.db.ConfigureAsContainerDB=false#-------------------------------------------------------------------------------# Specify the Pluggable Database name for the pluggable database in Container Database.#-------------------------------------------------------------------------------oracle.install.db.config.PDBName=#-------------------------------------------------------------------------------# Specify the Starter Database character set.# # One of the following# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.characterSet=#------------------------------------------------------------------------------# This variable should be set to true if Automatic Memory Management # in Database is desired.# If Automatic Memory Management is not desired, and memory allocation# is to be done manually, then set it to false.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.memoryOption=false#-------------------------------------------------------------------------------# Specify the total memory allocation for the database. Value(in MB) should be# at least 256 MB, and should not exceed the total physical memory available # on the system.# Example: oracle.install.db.config.starterdb.memoryLimit=512#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.memoryLimit=#-------------------------------------------------------------------------------# This variable controls whether to load Example Schemas onto# the starter database or not.# The value can be either "true" or "false". If left blank it will be assumed# to be "false".#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.installExampleSchemas=false################################################################################ ## Passwords can be supplied for the following four schemas in the ## starter database: ## SYS ## SYSTEM ## DBSNMP (used by Enterprise Manager) ## ## Same password can be used for all accounts (not recommended) ## or different passwords for each account can be provided (recommended) ## #################################################################################------------------------------------------------------------------------------# This variable holds the password that is to be used for all schemas in the# starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.ALL=#-------------------------------------------------------------------------------# Specify the SYS password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYS=#-------------------------------------------------------------------------------# Specify the SYSTEM password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYSTEM=#-------------------------------------------------------------------------------# Specify the DBSNMP password for the starter database.# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.DBSNMP=#-------------------------------------------------------------------------------# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.PDBADMIN=#-------------------------------------------------------------------------------# Specify the management option to use for managing the database.# Options are:# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.# 2. DEFAULT -If you want to manage your database using the default Database Express option.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.managementOption=DEFAULT#-------------------------------------------------------------------------------# Specify the OMS host to connect to Cloud Control.# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.omsHost=#-------------------------------------------------------------------------------# Specify the OMS port to connect to Cloud Control.# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.omsPort=0#-------------------------------------------------------------------------------# Specify the EM Admin user name to use to connect to Cloud Control.# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.emAdminUser=#-------------------------------------------------------------------------------# Specify the EM Admin password to use to connect to Cloud Control.# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.emAdminPassword=################################################################################ ## SPECIFY RECOVERY OPTIONS ## ------------------------------------ ## Recovery options for the database can be mentioned using the entries below ## #################################################################################------------------------------------------------------------------------------# This variable is to be set to false if database recovery is not required. Else # this can be set to true.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.enableRecovery=false#-------------------------------------------------------------------------------# Specify the type of storage to use for the database.# It can be one of the following:# - FILE_SYSTEM_STORAGE# - ASM_STORAGE#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.storageType=#-------------------------------------------------------------------------------# Specify the database file location which is a directory for datafiles, control# files, redo logs. ## Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=#-------------------------------------------------------------------------------# Specify the recovery location.## Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=#-------------------------------------------------------------------------------# Specify the existing ASM disk groups to be used for storage.## Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE#-------------------------------------------------------------------------------oracle.install.db.config.asm.diskGroup=#-------------------------------------------------------------------------------# Specify the password for ASMSNMP user of the ASM instance. ## Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.asm.ASMSNMPPassword=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username.## Example : MYORACLESUPPORT_USERNAME=abc@oracle.com#------------------------------------------------------------------------------MYORACLESUPPORT_USERNAME=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username password.## Example : MYORACLESUPPORT_PASSWORD=password#------------------------------------------------------------------------------MYORACLESUPPORT_PASSWORD=#------------------------------------------------------------------------------# Specify whether to enable the user to set the password for# My Oracle Support credentials. The value can be either true or false.# If left blank it will be assumed to be false.## Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true#------------------------------------------------------------------------------SECURITY_UPDATES_VIA_MYORACLESUPPORT=false#------------------------------------------------------------------------------# 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 true.## Example : DECLINE_SECURITY_UPDATES=false#------------------------------------------------------------------------------DECLINE_SECURITY_UPDATES=true#------------------------------------------------------------------------------# Specify the Proxy server name. Length should be greater than zero.## Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------PROXY_HOST=#------------------------------------------------------------------------------# Specify the proxy port number. Should be Numeric and at least 2 chars.## Example : PROXY_PORT=25#------------------------------------------------------------------------------PROXY_PORT=#------------------------------------------------------------------------------# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD# blank if your proxy server requires no authentication.## Example : PROXY_USER=username#------------------------------------------------------------------------------PROXY_USER=#------------------------------------------------------------------------------# Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication.## Example : PROXY_PWD=password#------------------------------------------------------------------------------PROXY_PWD=#------------------------------------------------------------------------------# Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/#------------------------------------------------------------------------------COLLECTOR_SUPPORTHUB_URL=
8. dbca 创建实例
1 dbca -silent -ignorePreReqs -ignorePrereqFailure -createDatabase -responseFile ~/.dbca.rsp
~/.dbca.rsp
################################################################################ #### DBCA response file #### ------------------ #### Copyright(c) Oracle Corporation 1998,2017. 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. #-------------------------------------------------------------------------------responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0#-----------------------------------------------------------------------------# Name : gdbName# Datatype : String# Description : Global database name of the database# Valid values :. - when database domain isn't NULL# - when database domain is NULL# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------gdbName=orcl#-----------------------------------------------------------------------------# Name : sid# Datatype : String# Description : System identifier (SID) of the database# Valid values : Check Oracle12c Administrator's Guide# Default value : specified in GDBNAME# Mandatory : No#-----------------------------------------------------------------------------sid=orcl#-----------------------------------------------------------------------------# Name : databaseConfigType# Datatype : String# Description : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database# Valid values : SI\RAC\RACONENODE# Default value : SI# Mandatory : No#-----------------------------------------------------------------------------databaseConfigType=RAC#-----------------------------------------------------------------------------# Name : RACOneNodeServiceName# Datatype : String# Description : Service is required by application to connect to RAC One # Node Database# Valid values : Service Name# Default value : None# Mandatory : No [required in case DATABASECONFTYPE is set to RACONENODE ]#-----------------------------------------------------------------------------RACOneNodeServiceName=#-----------------------------------------------------------------------------# Name : policyManaged# Datatype : Boolean# Description : Set to true if Database is policy managed and # set to false if Database is admin managed# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------policyManaged=false#-----------------------------------------------------------------------------# Name : createServerPool# Datatype : Boolean# Description : Set to true if new server pool need to be created for database # if this option is specified then the newly created database # will use this newly created serverpool. # Multiple serverpoolname can not be specified for database# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------createServerPool=false#-----------------------------------------------------------------------------# Name : serverPoolName# Datatype : String# Description : Only one serverpool name need to be specified # if Create Server Pool option is specified. # Comma-separated list of Serverpool names if db need to use# multiple Server pool# Valid values : ServerPool name# Default value : None# Mandatory : No [required in case of RAC service centric database]#-----------------------------------------------------------------------------serverPoolName=#-----------------------------------------------------------------------------# Name : cardinality# Datatype : Number# Description : Specify Cardinality for create server pool operation# Valid values : any positive Integer value# Default value : Number of qualified nodes on cluster# Mandatory : No [Required when a new serverpool need to be created]#-----------------------------------------------------------------------------cardinality=#-----------------------------------------------------------------------------# Name : force# Datatype : Boolean# Description : Set to true if new server pool need to be created by force # if this option is specified then the newly created serverpool# will be assigned server even if no free servers are available.# This may affect already running database.# This flag can be specified for Admin managed as well as policy managed db.# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------force=false#-----------------------------------------------------------------------------# Name : pqPoolName# Datatype : String# Description : Only one serverpool name needs to be specified # if create server pool option is specified. # Comma-separated list of serverpool names if use# server pool. This is required to # create Parallel Query (PQ) database. Applicable to Big Cluster# Valid values : Parallel Query (PQ) pool name# Default value : None# Mandatory : No [required in case of RAC service centric database]#-----------------------------------------------------------------------------pqPoolName=#-----------------------------------------------------------------------------# Name : pqCardinality# Datatype : Number# Description : Specify Cardinality for create server pool operation.# Applicable to Big Cluster # Valid values : any positive Integer value# Default value : Number of qualified nodes on cluster# Mandatory : No [Required when a new serverpool need to be created]#-----------------------------------------------------------------------------pqCardinality=#-----------------------------------------------------------------------------# Name : createAsContainerDatabase # Datatype : boolean# Description : flag to create database as container database # Valid values : Check Oracle12c Administrator's Guide# Default value : false# Mandatory : No#-----------------------------------------------------------------------------createAsContainerDatabase=true#-----------------------------------------------------------------------------# Name : numberOfPDBs# Datatype : Number# Description : Specify the number of pdb to be created# Valid values : 0 to 252# Default value : 0# Mandatory : No#-----------------------------------------------------------------------------numberOfPDBs=1#-----------------------------------------------------------------------------# Name : pdbName # Datatype : String# Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------pdbName=orclpdb#-----------------------------------------------------------------------------# Name : useLocalUndoForPDBs # Datatype : boolean# Description : Flag to create local undo tablespace for all PDB's.# Valid values : TRUE\FALSE# Default value : TRUE# Mandatory : No#-----------------------------------------------------------------------------useLocalUndoForPDBs=true#-----------------------------------------------------------------------------# Name : pdbAdminPassword# Datatype : String# Description : PDB Administrator user password# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------pdbAdminPassword=holyP#ssw0rd123#-----------------------------------------------------------------------------# 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=orcl1,orcl2#-----------------------------------------------------------------------------# Name : templateName# Datatype : String# Description : Name of the template# Valid values : Template file name# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------templateName=/ups/oracle/database/product/12.2/db_1/assistants/dbca/templates/General_Purpose.dbc#-----------------------------------------------------------------------------# Name : sysPassword# Datatype : String# Description : Password for SYS user# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------sysPassword=holyP#ssw0rd123#-----------------------------------------------------------------------------# Name : systemPassword# Datatype : String# Description : Password for SYSTEM user# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------systemPassword=holyP#ssw0rd123 #-----------------------------------------------------------------------------# Name : serviceUserPassword# Datatype : String# Description : Password for Windows Service user# Default value : None# Mandatory : If Oracle home is installed with windows service user#-----------------------------------------------------------------------------serviceUserPassword=#-----------------------------------------------------------------------------# Name : emConfiguration# Datatype : String# Description : Enterprise Manager Configuration Type# Valid values : CENTRAL|DBEXPRESS|BOTH|NONE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------emConfiguration=#-----------------------------------------------------------------------------# Name : emExpressPort# Datatype : Number# Description : Enterprise Manager Configuration Type# Valid values : Check Oracle12c Administrator's Guide# Default value : NONE# Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable# or auto generates a free port between 5500 and 5599#-----------------------------------------------------------------------------emExpressPort=5500#-----------------------------------------------------------------------------# Name : runCVUChecks# Datatype : Boolean# Description : Specify whether to run Cluster Verification Utility checks# periodically in Cluster environment# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------runCVUChecks=true#-----------------------------------------------------------------------------# Name : dbsnmpPassword# Datatype : String# Description : Password for DBSNMP user# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : Yes, if emConfiguration is specified or# the value of runCVUChecks is TRUE#-----------------------------------------------------------------------------dbsnmpPassword=#-----------------------------------------------------------------------------# Name : omsHost# Datatype : String# Description : EM management server host name# Default value : None# Mandatory : Yes, if CENTRAL is specified for emConfiguration#-----------------------------------------------------------------------------omsHost=#-----------------------------------------------------------------------------# Name : omsPort# Datatype : Number# Description : EM management server port number# Default value : None# Mandatory : Yes, if CENTRAL is specified for emConfiguration#-----------------------------------------------------------------------------omsPort=0#-----------------------------------------------------------------------------# Name : emUser# Datatype : String# Description : EM Admin username to add or modify targets# Default value : None# Mandatory : Yes, if CENTRAL is specified for emConfiguration#-----------------------------------------------------------------------------emUser=#-----------------------------------------------------------------------------# Name : emPassword# Datatype : String# Description : EM Admin user password# Default value : None# Mandatory : Yes, if CENTRAL is specified for emConfiguration#-----------------------------------------------------------------------------emPassword=#-----------------------------------------------------------------------------# Name : dvConfiguration# Datatype : Boolean# Description : Specify "True" to configure and enable Oracle Database vault# Valid values : True/False# Default value : False# Mandatory : No#-----------------------------------------------------------------------------dvConfiguration=false#-----------------------------------------------------------------------------# Name : dvUserName# Datatype : String# Description : DataVault Owner# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : Yes, if DataVault option is chosen#-----------------------------------------------------------------------------dvUserName=#-----------------------------------------------------------------------------# Name : dvUserPassword# Datatype : String# Description : Password for DataVault Owner# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : Yes, if DataVault option is chosen#-----------------------------------------------------------------------------dvUserPassword=#-----------------------------------------------------------------------------# Name : dvAccountManagerName# Datatype : String# Description : DataVault Account Manager# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------dvAccountManagerName=#-----------------------------------------------------------------------------# Name : dvAccountManagerPassword# Datatype : String# Description : Password for DataVault Account Manager# Valid values : Check Oracle12c Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------dvAccountManagerPassword=#-----------------------------------------------------------------------------# Name : olsConfiguration# Datatype : Boolean# Description : Specify "True" to configure and enable Oracle Label Security# Valid values : True/False# Default value : False# Mandatory : No#-----------------------------------------------------------------------------olsConfiguration=false#-----------------------------------------------------------------------------# Name : datafileJarLocation # Datatype : String# Description : Location of the data file jar # Valid values : Directory containing compressed datafile jar# Default value : None# Mandatory : No#-----------------------------------------------------------------------------datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/#-----------------------------------------------------------------------------# 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=+DATADG/{DB_UNIQUE_NAME}/#-----------------------------------------------------------------------------# 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=ASM#-----------------------------------------------------------------------------# Name : diskGroupName# Datatype : String# Description : Specifies the disk group name for the storage# Default value : DATA# Mandatory : No#-----------------------------------------------------------------------------diskGroupName=+DATADG/{DB_UNIQUE_NAME}/#-----------------------------------------------------------------------------# Name : asmsnmpPassword# Datatype : String# Description : Password for ASM Monitoring# Default value : None# Mandatory : No#-----------------------------------------------------------------------------asmsnmpPassword=#-----------------------------------------------------------------------------# Name : recoveryGroupName# Datatype : String# Description : Specifies the disk group name for the recovery area# Default value : RECOVERY# Mandatory : No#-----------------------------------------------------------------------------recoveryGroupName=#-----------------------------------------------------------------------------# Name : characterSet# Datatype : String# Description : Character set of the database# Valid values : Check Oracle12c National Language Support Guide# Default value : "US7ASCII"# Mandatory : NO#-----------------------------------------------------------------------------characterSet=ZHS16GBK#-----------------------------------------------------------------------------# Name : nationalCharacterSet# Datatype : String# Description : National Character set of the database# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide# Default value : "AL16UTF16"# Mandatory : No#-----------------------------------------------------------------------------nationalCharacterSet=AL16UTF16#-----------------------------------------------------------------------------# Name : registerWithDirService# Datatype : Boolean# Description : Specifies whether to register with Directory Service.# Valid values : TRUE \ FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------registerWithDirService=false#-----------------------------------------------------------------------------# Name : dirServiceUserName# Datatype : String# Description : Specifies the name of the directory service user# Mandatory : YES, if the value of registerWithDirService is TRUE#-----------------------------------------------------------------------------dirServiceUserName=#-----------------------------------------------------------------------------# 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=#-----------------------------------------------------------------------------# 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=#-----------------------------------------------------------------------------# Name : listeners# Datatype : String# Description : Specifies list of listeners to register the database with.# By default the database is configured for all the listeners specified in the # $ORACLE_HOME/network/admin/listener.ora # Valid values : The list should be comma separated like "listener1,listener2".# Mandatory : NO#-----------------------------------------------------------------------------listeners=LISTENER#-----------------------------------------------------------------------------# Name : variablesFile # Datatype : String# Description : Location of the file containing variable value pair# Valid values : A valid file-system file. The variable value pair format in this file # is = . Each pair should be in a new line.# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------variablesFile=#-----------------------------------------------------------------------------# Name : variables# Datatype : String# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/ups/oracle/database,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/ups/oracle/database/product/12.2/db_1,SID=orcl#-----------------------------------------------------------------------------# Name : initParams# Datatype : String# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------initParams=orcl2.undo_tablespace=UNDOTBS2,family:dw_helper.instance_mode=read-only,processes=300,orcl2.instance_number=2,nls_language=AMERICAN,pga_aggregate_target=314MB,sga_target=940MB,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_block_size=8192BYTES,orcl1.undo_tablespace=UNDOTBS1,orcl2.thread=2,diagnostic_dest={ORACLE_BASE},cluster_database=true,orcl1.thread=1,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,db_create_file_dest=+DATADG/{DB_UNIQUE_NAME}/,nls_territory=AMERICA,local_listener=-oraagent-dummy-,compatible=12.2.0,db_name=orcl,audit_trail=db,orcl1.instance_number=1,remote_login_passwordfile=exclusive,open_cursors=300#-----------------------------------------------------------------------------# 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=false#-----------------------------------------------------------------------------# 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=false#-----------------------------------------------------------------------------# Name : totalMemory# Datatype : String# Description : total memory in MB to allocate to Oracle# Valid values : # Default value : # Mandatory : NO#-----------------------------------------------------------------------------totalMemory=0
三、配置PDB启动
# 命令配置启动pdb随cdb启动alter pluggable database [pdbname] save state;alter pluggable database ORCLPDB save state;-- 结果检查set lines 168 pages 999col CON_NAME for a18col INSTANCE_NAME for a18col RESTRICTED for a12select con_id,CON_NAME,INSTANCE_NAME,STATE,RESTRICTED from dba_pdb_saved_states; CON_ID CON_NAME INSTANCE_NAME STATE RESTRICTED---------- ------------------ ------------------ -------------- ------------ 3 ORCLPDB orcl2 OPEN NO 3 ORCLPDB orcl1 OPEN NOSQL># 禁用pdb随cdb启动alter pluggable database ORCLPDB discard state ;SQL> alter pluggable database ORCLPDB discard state;Pluggable database altered.SQL> select con_id,CON_NAME,INSTANCE_NAME,STATE,RESTRICTED from dba_pdb_saved_states; CON_ID CON_NAME INSTANCE_NAME STATE RESTRICTED---------- ------------------ ------------------ -------------- ------------ 3 ORCLPDB orcl2 OPEN NOSQL> alter pluggable database ORCLPDB save state;Pluggable database altered.SQL> select con_id,CON_NAME,INSTANCE_NAME,STATE,RESTRICTED from dba_pdb_saved_states; CON_ID CON_NAME INSTANCE_NAME STATE RESTRICTED---------- ------------------ ------------------ -------------- ------------ 3 ORCLPDB orcl2 OPEN NO 3 ORCLPDB orcl1 OPEN NOSQL>