显示概览,默认不变,点击 next
点击finish
45
出现安装概要
点击ok,开始安装过程
46
等待一段时间后,安装结束,弹出如下界面
至此,数据库创建完毕。
47
9 数据库管理工作
9.1RAC的启停
oracle rac默认会开机自启动,如需维护时可使用以下命令: 3.1 关闭:
crsctl stop cluster 停止本节点集群服务
crsctl stop cluster –all 停止所有节点服务 3.2 开启
crsctl start cluster 开启本节点集群服务
crsctl start cluster –all 开启所有节点服务 注:以上命令需以 root用户执行
9.2 RAC检查运行状况
以grid 用户运行
[grid@rac1 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online CRS-
Database检查例状态
[oracle@rac1 ~]$ srvctl status database -d orcl Instance rac1 is running on node rac1 Instance rac2 is running on node rac2 检查节点应用状态及配置
[oracle@rac1 ~]$ srvctl status nodeapps
[oracle@rac1 ~]$ srvctl config nodeapps -a -g -s -
查看数据库配置
[oracle@rac1 ~]$ srvctl config database -d orcl -a 检查 ASM状态及配置
[oracle@rac1 ~]$ srvctl status asm ASM is running on rac1,rac2
[oracle@rac1 ~$ srvctl config asm -a ASM home: /oracle/11.2.0/grid ASM listener: LISTENER ASM is enabled.
检查 TNS的状态及配置
[oracle@rac1 ~]$ srvctl status listener Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2 [oracle@rac1 ~]$ srvctl config listener -a Name: LISTENER
Network: 1, Owner: grid
Home: /oracle/11.2.0/grid on node(s) rac2,rac1
48