####################启动######################################
11g R2的RAC手工启动按照HAS,,cluster, database的顺序启动,具体命令如下:
1、启动HAS(High Availability Services),必须以root用户
/u01/app/11.2.0/grid/bin/crsctl start has
has启动命令需要在每个节点分别执行
2、启动集群cluster
#所有节点启动
/u01/app/11.2.0/grid/bin/crsctl start cluster -all
#或指定节点启动
/u01/app/11.2.0/grid/bin/crsctl start cluster -n rac1 rac2
3、启动数据库
#登录
sqlplus system/123456 as sysdba
#启动,默认是开机启动
startup
4、启动em
emctl start dbconsole
5、查看集群监听状态
#状态
srvctl status listener
#监听端口
srvctl config listener
srvctl config scan_listener
#修改集群监听端口命令
#并且修改scan监听端口命令
srvctl modify listener -l LISTENER -p "TCP:20001"
srvctl modify scan_listener -p 20001
#进数据库查看连接端口
SQL> show parameter listener
#查看服务名
SQL> SHOW PARAMETER service_names
####################停止单节点 验证#######################
#停止rac1节点
/u01/app/11.2.0/grid/bin/crsctl stop cluster -n rac1
#验证
/u01/app/11.2.0/grid/bin/crsctl check cluster -all
#查看VIP是否漂移
ip a
#scan IP 、rac1-vip、rac2-vip都在另一台节点上
#恢复停止的rac1节点
/u01/app/11.2.0/grid/bin/crsctl stop cluster -n rac1
#验证
/u01/app/11.2.0/grid/bin/crsctl check cluster -all
#查看VIP是否回归
ip a
################启动Oracle EM############################
将Oracle EM 网站由https 转换为http 模式命令:
https 变成 http
emctl unsecure dbconsole
emctl start dbconsole
http 变成 https
emctl secure dbconsole
emctl start dbconsole
##################Plsql连接集群配置#######################
#修改oracle客户端tnsnames.ora,配置oracle集群两节点vip地址
oracleRAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
##################其他问题###############################
#故障
重启 HAC 报错,是11.2.0.1的一个典型的bug
/u01/app/11.2.0/grid/bin/crsctl start has
#故障解决
同时另开一个窗口,执行语句,直到窗口卡住
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
#结果
/u01/app/11.2.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
#查看集群配置
/u01/app/11.2.0/grid/bin/srvctl config database
#重装后未在集群删除数据库实例orcl命令
/u01/app/11.2.0/grid/bin/srvctl remove database -d orcl
########################################################
下一篇 Linux 系统部署 oracle RAC 集群 四 数据库表空间表数据导出导入