rac启停

On 2022年10月16日2022年10月16日By 去哪儿

关闭服务器

1、在rac1和rac2查询实例及DB NAME

db_name：oracl

instance_name：orcl1

SQL> show parameter name

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert		     string
db_name 			     string	 orcl
db_unique_name			     string	 orcl
global_names			     boolean	 FALSE
instance_name			     string	 orcl1
lock_name_space 		     string
log_file_name_convert		     string
service_names			     string	 orcl

2、停监听

查看当前监听状态

[rac1:grid]:/home/grid>srvctl status listenerListener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2

停止指定节点监听

[rac1:grid]:/home/grid>srvctl stop listener -n rac1 [rac1:grid]:/home/grid>srvctl status listenerListener LISTENER is enabled
Listener LISTENER is running on node(s): rac2

停止所有监听

[rac1:grid]:/home/grid>srvctl stop listener

3、停止数据库/实例

查看数据库运行状态
[rac2:grid]:/home/grid>srvctl status database -d orclInstance orcl1 is running on node rac1
Instance orcl2 is running on node rac2

查看实例运行状态

[rac2:grid]:/home/grid>srvctl status instance -d orcl -i orcl1Instance orcl1 is running on node rac1

[rac2:grid]:/home/grid>srvctl status instance -d orcl -i orcl2Instance orcl1 is running on node rac2

停掉orcl1实例的状态变化

[rac2:grid]:/home/grid>srvctl status instance -d orcl -i orcl1Instance orcl1 is not running on node rac1

#停掉前，rac1
[rac2:grid]:/home/grid>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.orcl.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        
#停掉后，rac2
[rac2:grid]:/home/grid>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------     
ora.orcl.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    rac2

停掉数据库

[rac2:grid]:/home/grid>srvctl stop database -d orcl

[rac2:grid]:/home/grid>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------     
ora.orcl.db    ora....se.type 0/2    0/1    OFFLINE   OFFLINE

4、停止集群（ROOT权限）

查看单个集群状态

[rac2:grid]:/home/grid>crsctl status server rac1

[rac2:grid]:/home/grid>crsctl status server rac1 
NAME=rac1
STATE=ONLINE

查看所有集群状态

[rac2:grid]:/home/grid>crsctl status server

[rac2:grid]:/home/grid>crsctl status server 
NAME=rac1
STATE=ONLINE

NAME=rac2
STATE=ONLINE

停掉rac1节点的集群状态

[root@rac1 ~]# /u01/app/11.2.0.4/grid/bin/crsctl stop crs

#此时查询rac1状态
[rac1:grid]:/home/grid>crsctl status server
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[rac1:grid]:/home/grid>crs_stat -t -v
CRS-0184: Cannot communicate with the CRS daemon.

#在rac2查询正常
[rac2:grid]:/home/grid>crsctl status server 
NAME=rac2
STATE=ONLINE

停掉整个集群

[root@rac1 ~]# /u01/app/11.2.0.4/grid/bin/crsctl stop cluster -all

注意：crsctl stop resources 只停止了所操作节点的CRS resources，但是crs的相关进程并未停止 crsctl stop crs 不但停止了所操作节点的CRS resources，crs的相关进程也停止

5、停止HAS的Oracle 高可用服务（ROOT权限）

查询has状体

[rac2:grid]:/home/grid>crsctl check hasCRS-4638: Oracle High Availability Services is online

由于之前rac1的集装状体停止，所以rac1是not contact状态

[rac1:grid]:/home/grid>crsctl check hasCRS-4639: Could not contact Oracle High Availability Services

停止has

[rac2:grid]:/home/grid>crsctl stop has

开启服务

6、服务器开机，服务自动启动

也可通过crsctl start crs，在两个节点操作启动

关闭也可通过这个命令，但同样需要两个节点上都操作crsctl stop crs

报错解决：CRS-4124: Oracle High Availability Services startup failed.

[root@rac1 ~]# /u01/app/11.2.0.4/grid/bin/crsctl start crs
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.

一样是BUG，输入crsctl start crs，直接开启新会话输入如下命令
[root@rac1 ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1

srvctl：管理服务

crsctl：管理集群