CNDBA社区
Oracle 12cR2 rac for oracle linux 7.3
一、相关文档及连接
Oracle Database 12c Release 2 Install and Upgrade
http://docs.oracle.com/database/122/nav/install-and-upgrade.htm
Grid Infrastructure Installation and Upgrade Guide
http://docs.oracle.com/database/122/CWLIN/toc.htm
Requirements for Installing Oracle 12.2 for linux 7.x
Requirements for Installing Oracle 12.2 RDBMS on OL7 or RHEL7 64-bit (x86-64) (文档 ID 2197176.1)
安装博客
http://www.cnblogs.com/hftian/p/6598788.html
oracle-database-server-12cR2-preinstall
http://docs.oracle.com/database/122/CWLIN/installing-a-new-oracle-linux-installation-from-dvds-or-images.htm#CWLIN-GUID-A686DF5E-8F3D-4697-88F5-DFA4C2B7DB07
oracle 12.2 for linux 安装内存需求
http://docs.oracle.com/database/122/LADBI/server-hardware-checklist-for-oracle-database-installation.htm#LADBI-GUID-D311E770-9444-45D0-A122-6491D1B66B8A
oracle 12.2 for linux 安装包的需求如下
http://docs.oracle.com/database/122/LADBI/operating-system-requirements-for-x86-64-linux-platforms.htm#LADBI-GUID-3F647617-7FF5-4EE4-BBA8-9A5E3EEC888F
for oracle linux 7.X
http://docs.oracle.com/database/122/LADBI/supported-oracle-linux-7-distributions-for-x86-64.htm#LADBI-GUID-3E82890D-2552-4924-B458-70FFF02315F7
for oracle linux 6.X
http://docs.oracle.com/database/122/LADBI/supported-oracle-linux-6-distributions-for-x86-64.htm#LADBI-GUID-77B9C8E1-D094-4C32-AA18-B91646247D33
for redhat linux 7.X
http://docs.oracle.com/database/122/LADBI/supported-red-hat-enterprise-linux-7-distributions-for-x86-64.htm#LADBI-GUID-2E11B561-6587-4789-A583-2E33D705E498
for redhat linux 6.X
http://docs.oracle.com/database/122/LADBI/supported-red-hat-enterprise-linux-6-distributions-for-x86-64.htm#LADBI-GUID-3B53A308-3EC2-4173-98A0-0FFD68994E90
内核参数
http://docs.oracle.com/database/122/LADBI/configuring-kernel-parameters-for-linux.htm#BEGIN
内核版本要求
Oracle Linux 7
http://docs.oracle.com/database/122/CWLIN/supported-oracle-linux-7-distributions-for-x86-64.htm#CWLIN-GUID-3E82890D-2552-4924-B458-70FFF02315F7
Red Hat Enterprise Linux 7
http://docs.oracle.com/database/122/CWLIN/supported-red-hat-enterprise-linux-7-distributions-for-x86-64.htm#CWLIN-GUID-2E11B561-6587-4789-A583-2E33D705E498
Red Hat Enterprise Linux 6
http://docs.oracle.com/database/122/CWLIN/supported-red-hat-enterprise-linux-6-distributions-for-x86-64.htm#CWLIN-GUID-3B53A308-3EC2-4173-98A0-0FFD68994E90
配置ASMFD
https://docs.oracle.com/database/122/OSTMG/administer-filter-driver.htm#OSTMG95908
二、安装前操作系统检查和相关包的安装
2.1.修改主机名
[root@lxtrac03 rules.d]# hostnamectl —static
lxtrac03
[root@lxtrac03 rules.d]# hostnamectl —transient
lxtrac03
[root@lxtrac03 rules.d]# hostnamectl —pretty
[root@lxtrac03 rules.d]#
如果不对可以使用如下命令修改
[root@lxtrac03 rules.d]# hostnamectl —static set-hostname lxtrac03
重启后也会生效，与linux 6和linux 5 相比不能直接修改/etc/sysconfig/network 然后使用hostname 来修改主机名
========================================================================
2.2.配置/etc/hosts
vim /etc/hosts
ens32 - PUBLIC
172.32.231.234 lxtrac03.iris.cl.sh.cos lxtrac03
172.32.231.235 lxtrac03.iris.cl.sh.cos lxtrac04
VIP
172.32.231.236 lxtrac03-vip.iris.cl.sh.cos lxtrac03-vip
172.32.231.237 lxtrac04-vip.iris.cl.sh.cos lxtrac04-vip
ens33 - PRIVATE
192.168.0.1 lxtrac03-priv.iris.cl.sh.cos lxtrac03-priv
192.168.0.2 lxtrac04-priv.iris.cl.sh.cos lxtrac04-priv
scan
172.32.231.238 12cdb-scan.iris.cl.sh.cos 12cdb-scan
注意：最多可以设置三个scan ip
2.3.关闭防火墙
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
========================================================================
2.4.关闭selinux
vim /etc/selinux/config
将SELINUX=enforcing改为SELINUX=disabled
注意：此动作重启后才生效
快速关闭SElinux（立即生效），使用如下命令就可以：
/usr/sbin/setenforce 0 立刻关闭 SELINUX
/usr/sbin/setenforce 1 立刻启用 SELINUX
========================================================================
2.5.关闭NTP服务(使用CTSS)
systemctl status chronyd.service
systemctl stop chronyd.service
systemctl disable chronyd.service
删除相关文件
2.6安装系统包
以下是在redhat linux 7.x 中需要安放的系统包
binutils-2.23.52.0.1-12.el7 (x86_64)
compat-libcap1-1.10-3.el7 (x86_64)
compat-libstdc++-33-3.2.3-71.el7 (i686) ——>
compat-libstdc++-33-3.2.3-71.el7 (x86_64)
glibc-2.17-36.el7 (i686) ——->
glibc-2.17-36.el7 (x86_64)
glibc-devel-2.17-36.el7 (i686) ——>
glibc-devel-2.17-36.el7 (x86_64)
ksh —->
libaio-0.3.109-9.el7 (i686) ——>
libaio-0.3.109-9.el7 (x86_64)
libaio-devel-0.3.109-9.el7 (i686) ——>
libaio-devel-0.3.109-9.el7 (x86_64)
libgcc-4.8.2-3.el7 (i686)
libgcc-4.8.2-3.el7 (x86_64)
libstdc++-4.8.2-3.el7 (i686)
libstdc++-4.8.2-3.el7 (x86_64)
libstdc++-devel-4.8.2-3.el7 (i686) ——>
libstdc++-devel-4.8.2-3.el7 (x86_64)
libxcb-1.9-5.el7 (i686) ——>
libxcb-1.9-5.el7 (x86_64)
libX11-1.6.0-2.1.el7 (i686) ——->
libX11-1.6.0-2.1.el7 (x86_64)
libXau-1.0.8-2.1.el7 (i686)
libXau-1.0.8-2.1.el7 (x86_64)
libXi-1.7.2-1.el7 (i686) ——->
libXi-1.7.2-1.el7 (x86_64)
libXtst-1.2.2-1.el7 (i686)
libXtst-1.2.2-1.el7 (x86_64)
make-3.82-19.el7 (x86_64)
net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware)
nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS)
smartmontools-6.2-4.el7 (x86_64)
sysstat-10.1.5-1.el7 (x86_64)
unixODBC-2.3.1-11.el7.i686 ——->
unixODBC-2.3.1-11.el7.x86_64 ——->
unixODBC-devel-2.3.1-11.el7.i686 ——->
unixODBC-devel-2.3.1-11.el7.x86_64 ——->
========================================================================
2.7.用户权限
创建相关组
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 asmadmin
groupadd -g 504 asmdba
groupadd -g 505 racdba
groupadd -g 506 asmoper
groupadd -g 507 oper
groupadd -g 508 backupdba
groupadd -g 509 dgdba
groupadd -g 510 kmdba
创建相关用户
useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper grid
创建相关目录
mkdir -p /u01/app/12.2.0.1/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
chown -R grid:oinstall /u01
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
========================================================================
2.8.修改用户环境变量
修改oracle的环境变量
su- oracle
[oracle@lxtrac03 ~]$ vim /home/oracle/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=ora12c1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export PATH=.:${PATH}:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS”
export LD_LIBRARY_PATH=/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
修改grid的环境变量
su - grid
[grid@lxtrac03 ~]$ vim /home/grid/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=+ASM1
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/12.2.0.1/grid
export PATH=.:${PATH}:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS”
export LD_LIBRARY_PATH=/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
========================================================================
2.9.修改资源限制
修改/etc/security/limits.conf，并添加如下信息
[root@rac1 ~]# vim /etc/security/limits.conf
for grid
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 2047
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
for oracle
oracle soft nproc 2047
oracle hard nproc 65536
oracle soft nofile 2047
oracle hard nofile 16384
oracle soft stack 10240
oracle hard stack 32768
2.10.配置NOZEROCONF
编辑 /etc/sysconfig/network文件增加以下内容
[root@rac1 ~]# vim /etc/sysconfig/network
加入：NOZEROCONF=yes
========================================================================
2.11.修改内核参数
[root@rac1 ~]# vim /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104 #N10241024*1024
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
立即生效：sysctl -p
2.12.配置/etc/pam.d/login
加入如下行
vim /etc/pam.d/login
session required pam_limits.so
========================================================================
2.13.对磁盘分区
fdisk -l /dev/sdd
省略…
注意：在使用fdisk 分区完成之后，要使用partprobe 刷新内核信息
2.14.创建ASMFD磁盘
2.14.1.解压相关文件
将12c 的grid 软件上传并解压到/u01/app/12.2.0.1/grid/目录下
[grid@lxtrac03 ~]$ cd /u01/software/
[grid@lxtrac03 ~]$ unzip /u01/software/linuxx64_12201_grid_home.zip -d $ORACLE_HOME
2.14.2.配置 ASMFD （只需要在一个节点上操作）
su - root
export ORACLE_HOME=/u01/app/12.2.0.1/grid
set ORACLE_BASE=/tmp
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label OCR01 /dev/sdd1 —init
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label OCR02 /dev/sdd2 —init
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label OCR03 /dev/sdd3 —init
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label DATA01 /dev/sdd5 —init
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label DATA02 /dev/sdd6 —init
2.14.3.验证设备被标记为ASMFD
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lslbl /dev/sdd1
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lslbl /dev/sdd2
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lslbl /dev/sdd3
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lslbl /dev/sdd5
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lslbl /dev/sdd6
unset ORACLE_BASE
2.14.4.关于ASMFD的相关问题处理
如果在标记后发现标签名写错了或者其他的问题，可以使用下面的命令进行修改（先格式化磁盘头然后再次打ASMFD标签）
/u01/app/12.2.0.1/grid/bin/asmcmd afd_unlabel FRA01 （好像没有作用）
1,直接格式化磁盘头
dd if=/dev/zero of=/dev/sdd1 bs=100M count=10
2,重新打标签
/u01/app/12.2.0.1/grid/bin/asmcmd afd_label OCR01 /dev/sdd1 —init
—检查asmfd是否创建完成（注意：只有在asm实例启动之后下面的命令执行才有结果）
1,扫描ASMFD磁盘
/u01/app/12.2.0.1/grid/bin/asmcmd afd_scan
2,显示ASMFD磁盘
/u01/app/12.2.0.1/grid/bin/asmcmd afd_lsdsk
3,查看ASMFD磁盘的状态
/u01/app/12.2.0.1/grid/bin/asmcmd afd_state
========================================================================
三、安装GI
3.1安装前检查
[grid@lxtrac03 software]$ cd grid
[grid@lxtrac03 ~]$ cd /u01/software/
[oracle@lxtrac03 grid]$ ./runcluvfy.sh stage -pre crsinst -n lxtrac03,lxtrac04 -fixup -verbose> /tmp/cluvfy.log
3.2如果tmp空间不够的处理
export TMP=/tmp
export TEMP=${TMP}
export TMPDIR=${TMP}
export TEMPDIR=${TMP}
========================================================================
3.3开始安装
[oracle@lxtrac03 grid]$ export DISPLAY=10.134.12.24:0.0
[oracle@lxtrac03 grid]$ xhost +
[oracle@lxtrac03 grid]$ ./gridSetup.sh
注意：
cluster name不能使用数字开头，也不是超过15个字符
scan name不能以数字开头
创建存放OCR和 Voting disk 的磁盘组（OCR磁盘组有3*15G=45G>38860M）
选择:Yes,然后继续安装
报错！！！
看见这个报错如果直接点击Yes，那么就会忽略在xtrac03节点上配置GI，因为节点lxtrac03的$GRID_HOME目录下不为空。所有记住一定不能直接点击Yes，要不然之后在一个节点上安装和配置GI。
处理：直接将已经存在的目录重命名，然后再重新创建一个同名的文件夹
mv /u01/app/12.2.0.1/grid /u01/app/12.2.0.1/grid_old
mkdir -p /u01/app/12.2.0.1/grid
如果勾选了Automatically run configuration scripts 那么在最后就不用手工执行在每个节点上执行root.sh脚本
在两个节点上执行下面的脚本
/tmp/GridSetupActions2017-05-17_03-58-30PM/CVU_12.2.0.1.0_grid/runfixup.sh
[root@lxtrac03 ~]# /tmp/GridSetupActions2017-05-17_03-58-30PM/CVU_12.2.0.1.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@lxtrac04 ~]# /tmp/GridSetupActions2017-05-17_03-58-30PM/CVU_12.2.0.1.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
点击OK ，然后继续安装，会重新检查一遍，如下图
选择：Yes 继续安装
选择：Yes 表示允许自动执行root.sh脚本
安装完成了但是报错！！！
[INS-20802] Oracle Cluster Verification Utility failed
日志文件如下：
/tmp/GridSetupActions2017-05-17_04-54-58PM/gridSetupActions2017-05-17_04-54-58PM.log
报错信息如下：
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Post-check for cluster services setup was unsuccessful.
INFO: [May 17, 2017 6:02:17 PM] Post-check for cluster services setup was unsuccessful.
INFO: [May 17, 2017 6:02:17 PM] Read: Checks did not pass for the following nodes:
INFO: [May 17, 2017 6:02:17 PM] Checks did not pass for the following nodes:
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac04,lxtrac03
INFO: [May 17, 2017 6:02:17 PM] lxtrac04,lxtrac03
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Failures were encountered during execution of CVU verification request “stage -post crsinst”.
INFO: [May 17, 2017 6:02:17 PM] Failures were encountered during execution of CVU verification request “stage -post crsinst”.
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying Single Client Access Name (SCAN) …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying Single Client Access Name (SCAN) …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying DNS/NIS name service ‘ora12cdb-scan’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying DNS/NIS name service ‘ora12cdb-scan’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: PRVG-1101 : SCAN name “ora12cdb-scan” failed to resolve
INFO: [May 17, 2017 6:02:17 PM] PRVG-1101 : SCAN name “ora12cdb-scan” failed to resolve
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying Clock Synchronization …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying Clock Synchronization …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying Network Time Protocol (NTP) …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying Network Time Protocol (NTP) …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying ‘/var/run/ntpd.pid’ …WARNING
INFO: [May 17, 2017 6:02:17 PM] Verifying ‘/var/run/ntpd.pid’ …WARNING
INFO: [May 17, 2017 6:02:17 PM] Read: PRVG-1019 : The NTP configuration file “/var/run/ntpd.pid” does not exist
INFO: [May 17, 2017 6:02:17 PM] PRVG-1019 : The NTP configuration file “/var/run/ntpd.pid” does not exist
INFO: [May 17, 2017 6:02:17 PM] Read: on nodes “lxtrac04,lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] on nodes “lxtrac04,lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying ‘/var/run/chronyd.pid’ …WARNING
INFO: [May 17, 2017 6:02:17 PM] Verifying ‘/var/run/chronyd.pid’ …WARNING
INFO: [May 17, 2017 6:02:17 PM] Read: PRVG-1019 : The NTP configuration file “/var/run/chronyd.pid” does not
INFO: [May 17, 2017 6:02:17 PM] PRVG-1019 : The NTP configuration file “/var/run/chronyd.pid” does not
INFO: [May 17, 2017 6:02:17 PM] Read: exist on nodes “lxtrac04,lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] exist on nodes “lxtrac04,lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying Daemon ‘ntpd’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying Daemon ‘ntpd’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: PRVG-1024 : The NTP daemon or Service was not running on any of the cluster
INFO: [May 17, 2017 6:02:17 PM] PRVG-1024 : The NTP daemon or Service was not running on any of the cluster
INFO: [May 17, 2017 6:02:17 PM] Read: nodes.
INFO: [May 17, 2017 6:02:17 PM] nodes.
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac04: PRVF-7590 : “ntpd” is not running on node “lxtrac04”
INFO: [May 17, 2017 6:02:17 PM] lxtrac04: PRVF-7590 : “ntpd” is not running on node “lxtrac04”
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac04: Liveness check failed for “ntpd”
INFO: [May 17, 2017 6:02:17 PM] lxtrac04: Liveness check failed for “ntpd”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac03: PRVF-7590 : “ntpd” is not running on node “lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] lxtrac03: PRVF-7590 : “ntpd” is not running on node “lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac03: Liveness check failed for “ntpd”
INFO: [May 17, 2017 6:02:17 PM] lxtrac03: Liveness check failed for “ntpd”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: Verifying Daemon ‘chronyd’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Verifying Daemon ‘chronyd’ …FAILED
INFO: [May 17, 2017 6:02:17 PM] Read: PRVG-1024 : The NTP daemon or Service was not running on any of the cluster
INFO: [May 17, 2017 6:02:17 PM] PRVG-1024 : The NTP daemon or Service was not running on any of the cluster
INFO: [May 17, 2017 6:02:17 PM] Read: nodes.
INFO: [May 17, 2017 6:02:17 PM] nodes.
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac04: PRVF-7590 : “chronyd” is not running on node “lxtrac04”
INFO: [May 17, 2017 6:02:17 PM] lxtrac04: PRVF-7590 : “chronyd” is not running on node “lxtrac04”
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac04: Liveness check failed for “chronyd”
INFO: [May 17, 2017 6:02:17 PM] lxtrac04: Liveness check failed for “chronyd”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac03: PRVF-7590 : “chronyd” is not running on node “lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] lxtrac03: PRVF-7590 : “chronyd” is not running on node “lxtrac03”
INFO: [May 17, 2017 6:02:17 PM] Read: lxtrac03: Liveness check failed for “chronyd”
INFO: [May 17, 2017 6:02:17 PM] lxtrac03: Liveness check failed for “chronyd”
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read:
INFO: [May 17, 2017 6:02:17 PM] Read: CVU operation performed: stage -post crsinst
INFO: [May 17, 2017 6:02:17 PM] CVU operation performed: stage -post crsinst
INFO: [May 17, 2017 6:02:17 PM] Read: Date: May 17, 2017 5:54:15 PM
INFO: [May 17, 2017 6:02:17 PM] Date: May 17, 2017 5:54:15 PM
INFO: [May 17, 2017 6:02:17 PM] Read: CVU home: /u01/app/12.2.0.1/grid/
INFO: [May 17, 2017 6:02:17 PM] CVU home: /u01/app/12.2.0.1/grid/
INFO: [May 17, 2017 6:02:17 PM] Read: User: grid
INFO: [May 17, 2017 6:02:17 PM] User: grid
INFO: [May 17, 2017 6:02:17 PM] Completed Plugin named: Oracle Cluster Verification Utility
发现主要是因为SCAN,DNS,NTP(linux6) chronyd(linux 7中时间同步服务) 的问题
对于scan ，可能是在/etc/hosts中配置了scan的地址，尝试ping这个地址信息，如果可以成功，则这个报错可以忽略。
对于DNS的问由于是直接使用/etc/hosts 文件，这个问题也可以忽略。
对于NTP 时间同步服务，在操作系统检查的时候已经将chronyd 关闭了，这种情况下oracle会使用crs 自带的CTSS 服务进行时间同步。
最后发现以上报错可以忽略，就选择:Yes 继续执行
选择：Yes 继续安装
点击close 关闭安装界面！！！！！！
3.4检查集群状态
[grid@lxtrac03 dev]$ crsctl status res -t
Name Target State Server State details
Local Resources
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.OCR.dg
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.chad
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.net1.network
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.ons
ONLINE ONLINE lxtrac03 STABLE
ONLINE ONLINE lxtrac04 STABLE
ora.proxy_advm
OFFLINE OFFLINE lxtrac03 STABLE
OFFLINE OFFLINE lxtrac04 STABLE
Cluster Resources
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE lxtrac04 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE lxtrac04 169.254.161.167 192.
168.0.2,STABLE
ora.asm
1 ONLINE ONLINE lxtrac04 Started,STABLE
2 ONLINE ONLINE lxtrac03 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE lxtrac04 STABLE
ora.lxtrac03.vip
1 ONLINE ONLINE lxtrac03 STABLE
ora.lxtrac04.vip
1 ONLINE ONLINE lxtrac04 STABLE
ora.mgmtdb
1 ONLINE ONLINE lxtrac04 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE lxtrac04 STABLE
ora.scan1.vip
1 ONLINE ONLINE lxtrac04 STABLE
[grid@lxtrac04 ~]$ crs_stat -t
Name Type Target State Host
ora….SM.lsnr ora….er.type ONLINE ONLINE lxtrac03
ora….ER.lsnr ora….er.type ONLINE ONLINE lxtrac03
ora….AF.lsnr ora….er.type OFFLINE OFFLINE
ora….N1.lsnr ora….er.type ONLINE ONLINE lxtrac04
ora.MGMTLSNR ora….nr.type ONLINE ONLINE lxtrac04
ora.OCR.dg ora….up.type ONLINE ONLINE lxtrac03
ora.asm ora.asm.type ONLINE ONLINE lxtrac04
ora.chad ora.chad.type ONLINE ONLINE lxtrac03
ora.cvu ora.cvu.type ONLINE ONLINE lxtrac04
ora….03.lsnr application ONLINE ONLINE lxtrac03
ora….c03.ons application ONLINE ONLINE lxtrac03
ora….c03.vip ora….t1.type ONLINE ONLINE lxtrac03
ora….04.lsnr application ONLINE ONLINE lxtrac04
ora….c04.ons application ONLINE ONLINE lxtrac04
ora….c04.vip ora….t1.type ONLINE ONLINE lxtrac04
ora.mgmtdb ora….db.type ONLINE ONLINE lxtrac04
ora….network ora….rk.type ONLINE ONLINE lxtrac03
ora.ons ora.ons.type ONLINE ONLINE lxtrac03
ora.proxy_advm ora….vm.type OFFLINE OFFLINE
ora.qosmserver ora….er.type ONLINE ONLINE lxtrac04
ora.scan1.vip ora….ip.type ONLINE ONLINE lxtrac04
注意点：
注意点1：
ora.proxy_advm
OFFLINE OFFLINE lxtrac03 STABLE
OFFLINE OFFLINE lxtrac04 STABLE
注意：Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes
由于没有使用ASM Dynamic Volume Manager，由于没有创建卷，所以这个服务处于offline可以不用管
注意点2：
ora.asm
1 ONLINE ONLINE lxtrac04 Started,STABLE
2 ONLINE ONLINE lxtrac03 Started,STABLE
3 OFFLINE OFFLINE STABLE
为什么两节点集群会出现三个asm instance ，而且多出的那么是offline 状态？
可能与启用flex asm 有关，该offline 可以忽略。
注意点3：
使用crs_stat -t 查看到有一个ora.LISTENER_LEAF.lsnr 服务处于offline 状态
NAME=ora.LISTENER_LEAF.lsnr
TYPE=ora.leaf_listener.type
TARGET=OFFLINE
STATE=OFFLINE
这种情况可能是与启用了flex asm有关，属于正常情况，该offline可以忽略
四、创建ASM磁盘组
创建磁盘组DATA
注意这步选择的是external（外部冗余），没有选择flex，但是最后好像默认会启用flex asm
五、安装数据库软件
点击test：（注意如果没有手工配置节点之间的互信这步会报错，那么就直接点击setup就可以了，忽略这步）
点击setup
[root@lxtrac03 ~]# /tmp/CVU_12.2.0.1.0_oracle/runfixup.sh
All Fix-up operations were completed successfully.
[root@lxtrac04 ~]# /tmp/CVU_12.2.0.1.0_oracle/runfixup.sh
All Fix-up operations were completed successfully.
执行完成之后点击ok
与安装GI 出现的failed 一样，可以勾选ignore all 全部忽略，然后点击Next
点击Yes 继续安装
[root@lxtrac03 ~]# /u01/app/oracle/product/12.2.0.1/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.2.0.1/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.
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.
[root@lxtrac04 ~]# /u01/app/oracle/product/12.2.0.1/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.2.0.1/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.
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.
点击ok 之后
点击close 关闭安装界面！！！ 数据库软件安装成功
六、DBCA建库
注意12c的新特性：local undo tablespace
注意：如果在这里设置FRA，那么fra的大小不能小于3896M*3=11688M，不然会在后面的安装过程中报错。此处我的大小是10240M<11688M,所以在开始建库的时候就报错了。
注意：这里选择的是Use Automatic Shared Memory Management ,由于主机的物理内存大于4G，如果选择Use Automatic Memory Management，会在开始建库的时候也会报错。
与之前版本的process 默值150比较640 要大了很多
默认字符集已经变成了AL32UTF8
点击Yes 继续安装
上面的几个filed 可以忽略，选择ignore all 点击next
点击Yes 继续安装
点击Close DBCA建库完成！！！！
七、检查集群及数据的状态
su - grid
crs_stat -t
crsctl status res -t
srvctl stautus database -db test12c
srvctl status instance -db test12c -node lxtrac03
srvctl status instance -db test12c -node lxtrac04
asmcmd
showclustermode
showclustermode
ocrcheck
crsctl check crs status
备注说明：此文档由我好友康师傅撰写
版权声明：本文为博主原创文章，未经博主允许不得转载。
