ORACLE之RAC搭建过程17-Grid Infrastructure安装后任务

ORACLE之RAC搭建过程17-Grid Infrastructure安装后任务

验证 Oracle Clusterware 安装

安装 Oracle Grid Infrastructure 后，可以运行几个测试来验证安装是否成功。
以 grid 用户身份在 RAC 集群的两个节点上运行以下命令。

1、检查 CRS 状态
[grid@rac1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

2、检查 Clusterware 资源
注：在 Oracle Clusterware 11g 第 2 版 (11.2) 中不再使用 crs_stat 命令。

[grid@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora.FRA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE rac1
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type 0/5 0/0 OFFLINE OFFLINE
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1

3、检查集群节点

[grid@rac1 ~]$ olsnodes -n
rac1 1
rac2 2

检查两个节点上的 Oracle TNS 监听器进程

[grid@rac1 ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER_SCAN1
LISTENER

确认针对 Oracle Clusterware 文件的 Oracle ASM 功能

[grid@rac1 ~]$ srvctl status asm -a
ASM is running on rac1,rac2
ASM is enabled.

检查 Oracle 集群注册表 (OCR)

[grid@rac1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2292
Available space (kbytes) : 259828
ID : 1483920655
Device/File Name : +CRS
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check bypassed due to non-privileged user

检查表决磁盘

[grid@rac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 288fe01fa3c04fcbbf1ef81875adc8b8 (ORCL:CRS1) [CRS]
Located 1 voting disk(s).

注：要管理 Oracle ASM 或 Oracle Net 11g 第 2 版 (11.2) 或更高安装版本，
请使用集群的 Oracle Grid Infrastructure 主目录（网格主目录）中的 srvctl 程序。
当我们安装 Oracle Real Application Clusters（Oracle 数据库软件）时，
不能使用数据库主目录下的 srvctl 程序来管理 Oracle Grid Infrastructure 主目录中的 Oracle ASM 或 Oracle Net。

备份 root.sh 脚本
以 root 身份在两个 Oracle RAC 节点上备份 root.sh 文件：

[root@rac1 ~]# cd /oracle/app/11.2.0/grid
[root@rac1 grid]# cp root.sh root.sh.20190128
[root@rac1 grid]# ll root.sh*
-rwxr-x--- 1 grid oinstall 729 1月 28 00:38 root.sh
-rwxr-x--- 1 root root 729 1月 28 01:18 root.sh.20190128