6、安装完成!
八、安装oracle数据库软件注意事项(rac1)
九、创建asm盘组注意事项(acc1)
十、建库注意事项(rac1)
1、 如果此处无法找到“ASM DISKGROUP”,执行
chmod +s oracle /01/grid/11.2.0/bin
十一、数据库管理工作(rac1)
1、 RAC的启停,以下命令需以 root用户执行
a) 关闭
crsctl stop cluster 停止本节点集群服务 crsctl stop cluster –all 停止所有节点服务
b) 开启
crsctl start cluster 开启本节点集群服务 crsctl stop cluster –all 开启所有节点服务
2、 RAC检查运行状况,以下命令用grid用户执行
a) 查看rac服务
crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
3、 查看和配置database,以下命令用Oracle用户执行
a) Database检查例状态
srvctl status database -d orcl
Instance rac1 is running on node rac1 Instance rac2 is running on node rac2
b) 检查节点应用状态及配置
srvctl status nodeapps VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1 VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2 Network is enabled
Network is running on node: rac1 Network is running on node: rac2 GSD is disabled
GSD is not running on node: rac1 GSD is not running on node: rac2 ONS is enabled
ONS daemon is running on node: rac1 ONS daemon is running on node: rac2 eONS is enabled
eONS daemon is running on node: rac1 eONS daemon is running on node: rac2
srvctl config nodeapps -a -g -s –l
-l homeion has been deprecated and will be ignored. VIP exists.:rac1
VIP exists.: /rac1-vip/10.160.1.106/255.255.255.0/eth0 VIP exists.:rac2
VIP exists.: /rac2-vip/10.160.1.107/255.255.255.0/eth0 GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
Name: LISTENER Network: 1, Owner: grid Home:
/oracle/11.2.0/grid on node(s) rac2,rac1 End points: TCP:1521
c) 查看数据库配置
srvctl config database -d orcl –a Database unique name: orcl Database name: orcl.lottemart.cn
Oracle home: /oracle/oracle/product/11.2.0/dbhome_1 Oracle user: oracle
Spfile: +ORCL_DATA/orcl/spfileorcl.ora Domain: idevelopment.info Start homeions: open Stop homeions: immediate Database role: PRIMARY
Management policy: AUTOMATIC Server pools: orcl
Database instances: rac1,rac2 Disk Groups: DATA,FLASH Services:
Database is enabled
Database is administrator managed
d) 检查 ASM状态及配置
srvctl status asm
ASM is running on rac1,rac2
srvctl config asm –a
ASM home: /oracle/11.2.0/grid ASM listener: LISTENER ASM is enabled.
e) 检查 TNS的状态及配置
srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2
srvctl config listener -a Name: LISTENER Network: 1, Owner: grid
Home: /oracle/11.2.0/grid on node(s) rac2,rac1 End points: TCP:1521
f) 检查 SCAN 的状态及配置
srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac1
srvctl config scan
SCAN name: rac-cluster-scan.rac.localdomain, Network: 1/192.168.1.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /rac-cluster-scan.rac.localdomain
g) 检查 VIP的状态及配置
h) 十二、 十三、 十四、
srvctl status vip -n rac1 VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
srvctl config vip -n rac1 VIP exists.:rac1
VIP exists.: /rac1-vip/192.168.11.14/255.255.255.0/eth0
如果要配置rac2 指明节点即可