Linux 系统部署 oracle RAC 集群三初始化配置和集群启动停止

电玩女神 2023-02-13 05:51 9阅读 0赞

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#启动\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

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 集群 四  数据库表空间表数据导出导入