Oracle RAC学习笔记

安装oracleasm，
配置ASM模块，root用户

/etc/init.d/oracleasm configure -i

根据提示输入默认用户grid 默认组 asmdba 设置开机启动y 设置开机搜索y
判断是否ASM磁盘，-p查看的是设备路径名，-d用来查看设备号

[root@node1 node1]# oracleasm querydisk -v -p VOL1
Disk "VOL1" is a valid ASM disk
/dev/sdb1: LABEL="VOL1" TYPE="oracleasm" 
[root@node1 node1]# oracleasm querydisk -v -p /dev/sdb1
Device "/dev/sdb1" is marked an ASM disk with the label "VOL1"
[root@node1 node1]# oracleasm querydisk -v -d -p VOL1
Disk "VOL1" is a valid ASM disk on device /dev/sdb1[8,17]
/dev/sdb1: LABEL="VOL1" TYPE="oracleasm" 

查看集群节点ip信息
以grid用户登录sqlplus,

SQL> set linesize 400
SQL> select name,ip_address from v$cluster_interconnects;

NAME					      IP_ADDRESS
--------------------------------------------- ------------------------------------------------
eth1					      192.168.100.111

跟ifconfig显示的eth1网卡地址一样。

[grid@node1 ~]$ oifcfg iflist
eth0  192.168.78.0
eth1  192.168.100.0
[grid@node1 ~]$ oifcfg getif
eth0  192.168.78.0  global  public
eth1  192.168.100.0  global  cluster_interconnect

也可以从gv$cluster_interconnects视图进行查找。

SQL> select * from gv$cluster_interconnects;

   INST_ID NAME 					 IP_ADDRESS						      IS_PUBLIC  SOURCE
---------- --------------------------------------------- ------------------------------------------------------------ ---------- ----------------------------------------
	 1 eth1 					 192.168.100.111					      NO Oracle Cluster Repository
	 2 eth1 					 192.168.100.222					      NO Oracle Cluster Repository

安装asm

yum install oracleasm-support oracleasmlib oracleasm-`uname -r`

查看数据库实例

srvctl status database -d devdb

启动或者关闭，把status改成start|stop

同理，监听的相关信息、启动、关闭

srvctl status|stop|start listener -l listenername

查询节点

[root@node2 disks]# su - grid
[grid@node2 ~]$ olsnodes -s
node1	Inactive
node2	Active

查看集群的名称

[grid@node2 ~]$ cemutlo -n
scan-cluster

查看集群状态

crsctl check cluster // 也可以加上-all参数，查询所有节点
[grid@node2 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@node2 ~]$ crsctl check cluster -all
Still waiting for replies from: node1
Still waiting for replies from: node1
**************************************************************
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
CRS-4404: The following nodes did not reply within the allotted time:
node1

节点应用程序状态

grid@node2 ~]$ srvctl status nodeapps
VIP node1-vip is enabled
VIP node1-vip is not running
VIP node2-vip is enabled
VIP node2-vip is running on node: node2
Network is enabled
Network is not running on node: node1
Network is running on node: node2
GSD is disabled
GSD is not running on node: node1
GSD is not running on node: node2
ONS is enabled
ONS daemon is not running on node: node1
ONS daemon is running on node: node2
eONS is enabled
eONS daemon is not running on node: node1
eONS daemon is running on node: node2

asm状态查看

srvctl status asm  // 也可以带-a参数
[grid@node2 ~]$ srvctl status asm
ASM is running on node2

查看asm配置

[grid@node2 ~]$ srvctl config asm -a
ASM home: /u01/app/11.2.0/grid
ASM listener was not found
PRCA-1032 : ASM listener LISTENER does not exist
ASM is enabled.

查看监听配置

[grid@node2 ~]$ srvctl config listener -a
PRCN-2044 : No listener exists

查看scan监听器的状态

srvctl status scan_listener
srvctl status scan

查看vip节点运行状态

[grid@node2 ~]$ srvctl  status vip -n node2
VIP node2-vip is enabled
VIP node2-vip is running on node: node2

数据库状态查询

srvctl status database -d devdb 

查看数据库配置

RAC集群管理命令

crs_start -all    // 启动
crs_start -t      // 查看
crs_stop -all    // 关闭

crsctl启停单节点RAC

crsctl stop cluster -all  // 停止所有节点集群服务
crsctl stop cluster    // 停止本节点集群服务

从OCR中删除已有的数据库

srvctl remove database -d devdb

向OCR中添加一个数据库实例

srvctl add instance -d -i -n 

通过srvctl命令管理一个节点的RAC

srvctl start|stop|status  nodeapps -n rac_node

使用sqlplus查看实例名称和状态

select instance_name, status from v$instance;

12c下重启RAC数据库

关闭顺序：
关闭PDB---->关闭数据库—>关闭集群服务

启动顺序：
开机自启动集群服务—>查看集群服务是否正常—>打开数据库—>打开PDB

查看PDB状态

SQL> select name,open_mode from v$pdbs ;
NAME OPEN_MODE
---------- --------------------
PDB$SEED READ ONLY
GNNT_PDB READ WRITE //状态是开启

关闭

SQL> alter pluggable database GNNT_PDB close;  // 打开的话，把close改成open
Pluggable database altered.
SQL> select name,open_mode from v$pdbs ;
NAME OPEN_MODE
---------- --------------------
GNNT_PDB MOUNTED //状态变为了关闭

也可以切换到PDB下操作

SQL> alter session set container=gnnt_pdb;
Session altered.
SQL> shutdown;
Pluggable Database closed.
SQL> startup;
Pluggable Database closed.

关闭数据库

[oracle@swnode1 ~]$ srvctl stop database -d orcl
[oracle@swnode1 ~]$ srvctl status database -d orcl
实例 gnnt1 没有在 swnode1 节点上运行
实例 gnnt2 没有在 swnode2 节点上运行

关闭集群RAC

[root@swnode1 ~]# /u01/app/12.2.0/grid/bin/crsctl stop cluster -all

正常情况下RAC会随操作系统自动启动，启动进程为/etc/rc.d/ohasd
以root用户运行所有RAC节点

# /u01/app/12.1.0/grid/bin/crsctl start crs

列出RAC实例

select instance_name,host_name,archiver,thread#,status from gv$instance;

结合关闭实例来进行验证

srvctl stop instance -d devdb -i devdb1