Oracle11g RAC集群启动关闭、各种资源检查、配置信息查看汇总

最新推荐文章于 2023-05-02 18:56:07 发布
最新推荐文章于 2023-05-02 18:56:07 发布
阅读量2.5k 收藏 13
点赞数
分类专栏： Oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sssfff155/article/details/116811662
版权

一：集群的启动与关闭

1. rac集群的手动启动
[root@node1 bin]# ./crsctl start cluster -all
2. 查看rac集群的状态
[root@node1 bin]# ./crsctl stat res -t
3. rac集群的关闭
[root@node1 bin]# ./crscrl stop cluster -all

————————————————————————————————

二：集群的各种资源状态的检查

1. 检查集群的运行状况
[root@node1 bin]# ./crsctl check cluster
2. 检查集群的数据库实例运行状态 
[root@node1 bin]# ./srvctl status database -d orcldb
3. 检查节点asm实例运行状态
[root@node1 bin]# ./srvctl status asm
4. 检查节点应用程序运行状态
[root@node1 bin]# ./srvctl status nodeapps
5. 检查节点监听运行状态
[root@node1 bin]# ./srvctl status listener
6. 检查scan监听运行状态
[root@node1 bin]# ./srvctl status scan
7. 检查所有集群节点间的时钟同步（非root用户执行）
[oracle@node1 ~]$ cluvfy comp clocksync -verbose

—————————————————————————————————

三： 集群的各种配置信息查看

1. 查看数据库配置信息。
[root@node1 bin]# ./srvctl config database -d orcldb
2. 查看应用程序配置信息
[root@node1 bin]# ./srvctl config nodeapps
3. 查看asm配置信息 
[root@node1 bin]# ./srvctl config asm
4. 查看监听配置信息 
[root@node1 bin]# ./srvctl config listener
5. 查看scan配置信息
[root@node1 bin]# ./srvctl config scan
6. 查看RAC注册表磁盘配置信息
[root@node1 bin]# ./ocrcheck
7. 查看RAC仲裁磁盘配置信息
[root@node1 bin]# ./crsctl query css votedisk
————————————————————-————————
下面是详细操作输出信息
11g rac r2启动（默认开机会自动启动）关闭需要用root用户维护。
--执行命令的路径
[root@node1 bin]# pwd 
/u01/app/11.2.0/grid/bin

一： 11g rac集群的正常启动与关闭。

--rac集群的手动启动
[root@node1 bin]# ./crsctl start cluster -all 
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node2'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'
CRS-2676: Start of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node2'
CRS-2672: Attempting to start 'ora.diskmon' on 'node2'
CRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node1'
CRS-2672: Attempting to start 'ora.diskmon' on 'node1'
CRS-2676: Start of 'ora.diskmon' on 'node2' succeeded
CRS-2676: Start of 'ora.diskmon' on 'node1' succeeded
CRS-2676: Start of 'ora.cssd' on 'node2' succeeded
CRS-2676: Start of 'ora.cssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node2'
CRS-2672: Attempting to start 'ora.ctssd' on 'node1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node1'
CRS-2676: Start of 'ora.ctssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node2'
CRS-2676: Start of 'ora.evmd' on 'node2' succeeded
CRS-2676: Start of 'ora.evmd' on 'node1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node2'
CRS-2672: Attempting to start 'ora.asm' on 'node1'
CRS-2676: Start of 'ora.asm' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node1'
CRS-2676: Start of 'ora.crsd' on 'node1' succeeded
CRS-2676: Start of 'ora.asm' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node2'
CRS-2676: Start of 'ora.crsd' on 'node2' succeeded

-- 查看rac集群的状态
[root@node1 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS 
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.FLASH.dg
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.GRIDDG.dg
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.ORCLDB.lsnr
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.asm
ONLINE ONLINE node1 Started 
ONLINE ONLINE node2 Started 
ora.gsd
OFFLINE OFFLINE node1 
OFFLINE OFFLINE node2 
ora.net1.network
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.ons
ONLINE ONLINE node1 
ONLINE ONLINE node2 
ora.registry.acfs
ONLINE ONLINE node1 
ONLINE ONLINE node2 
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1 
ora.cvu
1 ONLINE ONLINE node1 
ora.node1.vip
1 ONLINE ONLINE node1 
ora.node2.vip
1 ONLINE ONLINE node2 
ora.oc4j
1 ONLINE ONLINE node1 
ora.orcldb.db
1 ONLINE ONLINE node1 Open 
2 ONLINE ONLINE node2 Open 
ora.scan1.vip
1 ONLINE ONLINE node1

--rac集群的关闭
[root@node1 bin]# ./crscrl stop cluster -all
-bash: ./crscrl: No such file or directory
[root@node1 bin]# ./crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'node1'
CRS-2673: Attempting to stop 'ora.cvu' on 'node1'
CRS-2673: Attempting to stop 'ora.ORCLDB.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node1'
CRS-2673: Attempting to stop 'ora.orcldb.db' on 'node1'
CRS-2677: Stop of 'ora.cvu' on 'node1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'node1'
CRS-2677: Stop of 'ora.ORCLDB.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node1'
CRS-2677: Stop of 'ora.scan1.vip' on 'node1' succeeded
CRS-2677: Stop of 'ora.orcldb.db' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node1'
CRS-2677: Stop of 'ora.node1.vip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'node2'
CRS-2677: Stop of 'ora.registry.acfs' on 'node1' succeeded
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node2'
CRS-2673: Attempting to stop 'ora.orcldb.db' on 'node2'
CRS-2673: Attempting to stop 'ora.ORCLDB.lsnr' on 'node2'
CRS-2677: Stop of 'ora.FLASH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.ORCLDB.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2677: Stop of 'ora.node2.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'node1' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'node2' succeeded
CRS-2677: Stop of 'ora.orcldb.db' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node2'
CRS-2677: Stop of 'ora.DATA.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node2'
CRS-2677: Stop of 'ora.ons' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node2'
CRS-2677: Stop of 'ora.net1.network' on 'node2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node2' has completed
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node2'
CRS-2673: Attempting to stop 'ora.evmd' on 'node2'
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.evmd' on 'node2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node2'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'node2' succeeded
———————————————————————————
飞鱼ge
关注
  • 0
    点赞
  • 踩
  • 13
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle 11g RAC 检查各部分运行状态
Tiny speck
02-20 1万+
检查RAC运行状况 [grid@rac1 ~]$ crsctl check cluster  CRS-4537: Cluster Ready Services is online  CRS-4529: Cluster Synchronization Services is online  CRS-4533: Event Manager is online 检查Database实例
Oracle11g RAC集群启动关闭管理
lt53130640688的博客
11-05 9590
简单的Oracle11g RAC集群启动关闭管理1.切换到集群用户grid[root@rac1 ~]# su - grid2.查看集群资源状态（黄色标注11G不使用此资源 所以OFFLINE为正常状态）[grid@rac1 ~]$ crs_stat -t Name Type Target State Host ora.CRSDG.
oracle rac集群关闭和启动操作命令
热门推荐
故年的城
07-21 1万+
一、关闭数据库的顺序 1. 关闭数据库 oracle用户执行srvctl命令： $ srvctl stop/status database -d orcl #停止/查看所有节点上的实例 2. 停止集群服务，必须以root用户执行crsctl命令 # cd /u01/app/grid/11.2.0/bin # ./crsctl stop cluster -all 或者./cr...
Oracle 数据库集群常用巡检命令
u010483330的博客
07-27 2153
Oracle Rac数据库集群常用巡检命令
安装与配置 Oracle 11g RAC（20）—— 使用 crs_stat 命令查看集群信息
睿思达DBA
08-28 2084
安装与配置 Oracle 11g RAC（20）—— 使用 crs_stat 命令查看集群信息 使用 crs_stat 命令可以查看 RAC 中各资源的状态，该命令的帮助信息如下： [grid@rac2 bin]$ crs_stat -h This command is deprecated and has been replaced by 'crsctl status resource' This command remains for backward compatibility only Usage
oracle rac查看节点及宕库
qq_39395596的博客
07-07 4243
1.oracle rac查看节点状态 通过sqlplus连入数据库，执行命令查看节点及状态： select instance_number,instance_name,host_name,status,version from gv$instance; 注意：oracle rac的使用是配置vip进行连接。(具体如何配置自行百度) 2.oracle rac启动与关闭节点并查看实例状态 ①启动与关闭节点(vip账户登录服务器，不接入数据库)： srvctl stop instance -d 数据库名字 -i
Oracle：查看自己当前在RAC的哪个节点上
weixin_34150224的博客
04-07 2572
Oracle：查看自己当前在RAC的哪个节点上 SQL> select * from v$instance; 1 RAC1 rac1.localdomain 11.2.0.1.0 07-APR-12 OPEN YES 1 STOPPED ALLOWED NO AC...
Oracle 11g RAC+DG安装配置
08-09
Oracle 11g RAC (Real Application Clusters) 和 Data Guard 是两个重要的 Oracle 数据库高可用性和灾难恢复解决方案。RAC 允许多个实例在同一个数据库上并行工作，提供故障切换和负载均衡，而 Data Guard 提供了...
Oracle 11g RAC集群日常运维与管理实战视频教程
06-12
Oracle RAC 11g是Oracle公司推出的集群数据库版本，在企业中使用相当广泛，本套课程从实用的角度出发详细介绍了RAC的日常维护管理方法，尽管RAC的功能非常强大，但是RAC的安装和管理却是非常困难，而且这方面的资料...
oracle11g rac+redhat5.5集群配置
10-17
Oracle 11g RAC（Real Application Clusters）是一种高可用性和可伸缩性的数据库解决...通过遵循这些步骤并参考《oracle11g rac+redhat5.5集群配置2.0.doc》文档，可以为你的企业构建一个强大且高度可用的数据库环境。
centos7安装oracle11g rac集群文档
07-18
亲测跟着文档可以顺利安装
Oracle 11g RAC数据库集群搭建实战视频
06-11
Oracle 11g RAC（Real Application Clusters）数据库集群是一种强大的数据库解决方案，它提供了高可用性和性能优化，使得多个数据库实例可以在多台服务器上共享同一个物理数据库。Oracle RAC在企业级应用中广泛使用...
如何查看oracle数据库集群哪个节点正在使用,windows oracle 怎么查看集群状态
weixin_39972019的博客
04-14 881
匿名用户1级2016-12-23 回答参看集群状态[11:34:11oracle@node1 ~]crs_stat -tName Type Target State Host------------------------------------------------------------ora.dba.db application...
Oracle RAC asm磁盘管理--添加--删除--扩容
freelove_2005的专栏
03-09 1076
SQL> select group_number,mount_status,name,path from v$asm_disk; GROUP_NUMBER MOUNT_STATUS NAME PATH ------------ -------------- ------------------------------------------------------------ ---.
oracle 查询多少方案,Oracle RAC实施方案详细说明-安装后的检查06
weixin_39669982的博客
04-04 93
Oracle RAC实施方案详细说明-安装后的检查06查看数据库版本SQL> select * from v$version;查看集群名称[root@rac01 bin]# ./cemutlo --help[root@rac01 bin]# ./cemutlo -nrac-cluster[root@rac01 bin]# ./cemutlo -w2:1:查看集群状态[root@rac01 ~...
oracle集群基本查询命令
kevinyu998的博客
05-02 1607
查询主节点-grid用户执行 oclumon manage -get MASTER REPLICA。Vote disks配置 crsctl query css votedisk。OCR自动备份: ocrconfig -showbackup。集群资源状态crsctl check crs。集群OCR配置情况:ocrcheck。
11g RAC集群启动关闭、各种资源检查、配置信息查看汇总。
weixin_33767813的博客
12-25 253
简要：一：集群的启动与关闭 1. rac集群的手动启动[root@node1 bin]# ./crsctl start cluster -all2. 查看rac集群的状态[root@node1 bin]# ./crsctl stat res -t3. rac集群的关闭[root@node1 bin]# ./crscrl stop cluster -all——————————————————...
Oracle杂记总结
安浅66的博客
05-21 346
Oracle杂记总结 Linux安装11g、exp命令导出、imp命令导入、RAC、Scheduler、sqlplus
ArubaInstant-Hercules-8.10.0.12-89862
最新发布
07-10
Aruba 318 Series Hardened Access Points Aruba 370 Series Outdoor Access Points Aruba 387 Series Outdoor Access Points Aruba 320 Series Campus Access Points Aruba 310 Series Campus Access Points
Centos_6.4安装oracle_11g_RAC集群.
11-01
Centos_6.4安装oracle_11g_RAC集群，用于指导Linux环境下rac的安装配置

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值