安装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