管理11g RAC之Cluster实验

最新推荐文章于 2022-04-04 03:24:08 发布
最新推荐文章于 2022-04-04 03:24:08 发布
阅读量603 收藏
点赞数
分类专栏： Oracle High Availability--RAC 文章标签： resources manager 集群 server
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dbcommando/article/details/7678898
版权

实验内容如下：

检查集群状态：

[grid@rac122 ~]$ crsctl check cluster -all
**************************************************************
rac121:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac122:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

查看资源状态：

[grid@rac122 ~]$ crsctl status resource  -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.FRA.dg
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.NEW_RACDB_LISTENER.lsnr
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.RACDB_DATA.dg
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.RACDB_LISTENER.lsnr
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.asm
               ONLINE  ONLINE       rac121                   Started             
               ONLINE  ONLINE       rac122                   Started             
ora.gsd
               ONLINE  OFFLINE      rac121                                       
               ONLINE  OFFLINE      rac122                                       
ora.net1.network
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.ons
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
ora.registry.acfs
               ONLINE  ONLINE       rac121                                       
               ONLINE  ONLINE       rac122                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac122                                       
ora.cvu
      1        ONLINE  ONLINE       rac122                                       
ora.oc4j
      1        ONLINE  ONLINE       rac122                                       
ora.rac121.vip
      1        ONLINE  ONLINE       rac121                                       
ora.rac122.vip
      1        ONLINE  ONLINE       rac122                                       
ora.racdb.db
      1        ONLINE  ONLINE       rac121                   Open                
      2        ONLINE  ONLINE       rac122                   Open                
ora.scan1.vip
      1        ONLINE  ONLINE       rac122   


停止集群【要用root用户执行】：-all 停止所以，不加只停止本地。

[root@rac121 ~]# /oradata/oracleapp/11.2.0/grid/bin/crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'rac121'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac122'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac122'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac122'
CRS-2673: Attempting to stop 'ora.NEW_RACDB_LISTENER.lsnr' on 'rac122'
CRS-2673: Attempting to stop 'ora.RACDB_LISTENER.lsnr' on 'rac122'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac122'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac122'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac122'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac122'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'rac122'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac122'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac121'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac121'
CRS-2673: Attempting to stop 'ora.NEW_RACDB_LISTENER.lsnr' on 'rac121'
CRS-2673: Attempting to stop 'ora.RACDB_LISTENER.lsnr' on 'rac121'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac121'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'rac121'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac121'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac122' succeeded
CRS-2677: Stop of 'ora.NEW_RACDB_LISTENER.lsnr' on 'rac122' succeeded
CRS-2677: Stop of 'ora.RACDB_LISTENER.lsnr' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.rac122.vip' on 'rac122'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac122'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac121' succeeded
CRS-2677: Stop of 'ora.NEW_RACDB_LISTENER.lsnr' on 'rac121' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac122' succeeded
CRS-2677: Stop of 'ora.rac122.vip' on 'rac122' succeeded
CRS-2677: Stop of 'ora.RACDB_LISTENER.lsnr' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.rac121.vip' on 'rac121'
CRS-2677: Stop of 'ora.rac121.vip' on 'rac121' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac122' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac121' succeeded
CRS-2677: Stop of 'ora.racdb.db' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac122'
CRS-2673: Attempting to stop 'ora.RACDB_DATA.dg' on 'rac122'
CRS-2677: Stop of 'ora.racdb.db' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac121'
CRS-2673: Attempting to stop 'ora.RACDB_DATA.dg' on 'rac121'
CRS-2677: Stop of 'ora.FRA.dg' on 'rac122' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac121' succeeded
CRS-2677: Stop of 'ora.RACDB_DATA.dg' on 'rac122' succeeded
CRS-2677: Stop of 'ora.RACDB_DATA.dg' on 'rac121' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac122' succeeded
CRS-2677: Stop of 'ora.cvu' on 'rac122' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac121'
CRS-2677: Stop of 'ora.asm' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac121'
CRS-2677: Stop of 'ora.ons' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac121'
CRS-2677: Stop of 'ora.net1.network' on 'rac121' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac121' has completed
CRS-2677: Stop of 'ora.DATA.dg' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac122'
CRS-2677: Stop of 'ora.asm' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac122'
CRS-2677: Stop of 'ora.ons' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac122'
CRS-2677: Stop of 'ora.net1.network' on 'rac122' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac122' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac121'
CRS-2677: Stop of 'ora.crsd' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'rac121'
CRS-2673: Attempting to stop 'ora.asm' on 'rac121'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac122'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac122'
CRS-2673: Attempting to stop 'ora.asm' on 'rac122'
CRS-2677: Stop of 'ora.evmd' on 'rac121' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac122' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac121'
CRS-2677: Stop of 'ora.asm' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac122'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac122' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac121' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac121' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac121'
CRS-2677: Stop of 'ora.ctssd' on 'rac122' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac122'
CRS-2677: Stop of 'ora.cssd' on 'rac121' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac122' succeeded
[root@rac121 ~]# 


起动集群【要用root用户执行】：-all 停止所以；不加只停止本地；也可指定启动几个：crsctl start cluster -n rac121 rac122

[root@rac121 ~]# /oradata/oracleapp/11.2.0/grid/bin/crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac121'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac122'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac122' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac122'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac122'
CRS-2676: Start of 'ora.diskmon' on 'rac122' succeeded
CRS-2676: Start of 'ora.cssdmonitor' on 'rac121' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac121'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac121'
CRS-2676: Start of 'ora.diskmon' on 'rac121' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac122' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rac122'
CRS-2676: Start of 'ora.cssd' on 'rac121' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rac121'
CRS-2676: Start of 'ora.ctssd' on 'rac122' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'rac122'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac122'
CRS-2676: Start of 'ora.ctssd' on 'rac121' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'rac121'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac121'
CRS-2676: Start of 'ora.evmd' on 'rac122' succeeded
CRS-2676: Start of 'ora.evmd' on 'rac121' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac122' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac122'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac121' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac121'
CRS-2676: Start of 'ora.asm' on 'rac121' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac121'
CRS-2676: Start of 'ora.crsd' on 'rac121' succeeded
CRS-2676: Start of 'ora.asm' on 'rac122' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac122'
CRS-2676: Start of 'ora.crsd' on 'rac122' succeeded





dbcommando
关注
专栏目录
【Oracle 11G RAC 零基础搭建】
weixin_45031409的博客
04-23 8146
redhat6.9+oracle 11g rac 搭建过程
Oracle 11g RAC集群日常运维与管理
qq_41141058的博客
06-26 2713
01-RAC基本维护命令 查看环境：/etc/hosts #cat /etc/hosts [root@ouzy01 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 ::1 localhost localhost.localdomain localhost6 # Public 192...
[Oracle] RAC实验
12-22 83
拓扑图 后端的iSCSI服务器可以选openfiler或FreeNASMetalink: RAC Assurance Support Team: RAC / CRS Starter Kit and...
10g,11gRAC CRS集群
cf7923的博客
06-22 639
关闭过程（CRS集群关闭－>关闭数据库） 1.关闭数据库：  用oracl用户执行srvctl命令  语法：srvctl stop database -d dbname ［-o immediate］  作用：可以一次性关闭dbname的所有实例 [Oracle@rac1 ~]$ srvctl stop database -d racdb  -停止所有节点上的实例  然后查看状态： [
rac集群简介(原创)
weixin_34199335的博客
05-24 198
什么是集群　 集群（Cluster）是由两台或多台节点机（服务器）构成的一种松散耦合的计算节点集合，为用户提供网络服务或应用程序(包括数据库、Web服务 和文件服务等)的单一客户视图。集群系统一般通过两台或多台节点服务器系统通过相应的硬件及软件互连，每个群集节点都是运行其自己进程的独立服务器。这些 进程可以彼此通信，对网络客户机来说就像是形成了一个单一...
RAC 手动创建cluster resource
jnrjian的博客
04-04 490
Oracle 11gR2 CRS资源配置手册 目 录 1 文档简介 3 1.1 编写目的 3 1.2 适用范围 3 1.3 名词解释 3 1.4 格式约定 3 2 安装Oracle软件及创建数据库 4 2.1 安装前环境配置 4 2.2 配置ASM存储 4 2.3 安装Oracle软件 4 2.4 创建数据库 4 3 配置数据库应用的资源 4 3.1 资源说明 4 3.1.1 由CRS自动创建的资源 4 3.1.2 需用户自行创建的资源 5 3.2 资源依赖关系图 6 3.3 禁用资源ora.testdb
Oracle 11G RAC ASM 实验环境搭建步骤
"Oracle 11G RAC ASM搭建教程" 在Oracle数据库系统中，Real Application Clusters (RAC) 和 Automatic Storage Management (ASM) 是两个关键的技术，它们提供了高可用性和资源管理。本教程将详细介绍如何在Oracle ...
有关于Oracle11g RAC技术应用基于VBox实验的官方文档（英文版）
02-13
Oracle 11g RAC (Real Application Clusters) 是一种高级数据库技术，它允许多个服务器节点共享同一数据库实例，从而提供高可用性和可扩展性。在虚拟环境中实现Oracle 11g RAC可以极大地降低成本，特别是对于测试和...
Oracle 11g RAC 安装指南：VMware 实验环境
"这是一份详细的11g RAC (Real Application Clusters) 安装教程，虽然原文是英文的，但理解起来并不困难。该文档由Jeremy Schneider编写，并有其他贡献者的帮助。文档提供了安装Oracle 11g RAC所需的各种资源链接，...
Oracle RAC的不错的实验指导文章
11-28
Oracle RAC的不错的实验指导文章
随笔：Crs,Has和Cluster在RAC环境里的区别
czystc的博客
11-21 1537
随笔：Crs,Has和Cluster在RAC环境里的区别 crsctl start/stop crs crsctl start/stop has crsctl start/stop cluster 这三个是在oracle集群里常用的命令，他们的使用也有一些区别 Has是在11g里新出的概率，10g里只有Crs. 以下测试都是在12c的环境里进行的： 1.单机环境里只能使用crsctl start/...
Oracle RAC(Cluster)的重构(整理)（1）
cqhiabc50405的博客
07-14 198
Oracle Cluster的重构包括两部分： 一是clusterware层： 所有节点的Clusterware组成一个集群，并构成一 个集群成员列表（Cluster membership list）第个节点会分配一...
oracle rac cluster服务进程介绍
charels
01-06 996
集群服务堆栈 1.Cluster Ready Services(CRS) --crsd.bin (r) --r表示root权限才能启停 # ps -ef|grep crsd root 3803 1 0 Dec 15 ? 6490:10 /u01/app/11.2.0/grid/bin/crsd.bin reboot root 29745 1129
Oracle集群检测命令
weixin_30879169的博客
07-22 2897
select inst_id, count(inst_id) from gv$session group by inst_id order by inst_id; srvctl stop database -d racdb(数据库名) -o immediate 关闭数据库关闭集群中的实例所有节点 su - grid 查看所有节点状态olsnodes -s 检查集群中各组件状态 每个组件都应...
ORACLE 11g RAC 集群的管理与维护（4） —— crsctl 命令之（四） ：管理 Oracle Cluster
睿思达DBA
09-19 1194
ORACLE 11g RAC 集群的管理与维护（4） —— crsctl 命令之（四） ：管理 Oracle Cluster Crsctl start/stop crs 管理本地节点 Clusterware stack 的启停，包含启动 ohasd 进程，只能用来管理本地节点。crsctl strat/stop cluster 既可以管理本地 Clusterware stack，也可以管理整个集群。 一、crsctl check cluster 检查 Oracle Clusterware stack 的状
crsctl相关命令
weixin_39568073的博客
11-24 2236
crsctl -help crsctl query crs activeversion：显示本地节点上Oracle Clusterware软件的活动版本或二进制版本 Oracle Clusterware active version on the cluster is [12.1.0.2.0] 集群上的Oracle Clusterware活动版本是[12.1.0.2.0] crsctl que...
oracle 19c crsctl相关命令（一）
weixin_39568073的博客
06-28 3513
./crsctl query has releaseversion 显示存储在本地节点上的二进制文件中的Oracle Clusterware软件的发行版本 ./crsctl query has softwareversion 在本地节点上显示软件版本 HAS高可用性服务 High Availability Services ./crsctl config has 显示服务器上Oracle High Availability Services堆栈的自动启动配置。 已启用Oracle高可用性服务 ./c
oracle 12c 集群安装后的检查
kadwf123的专栏
11-02 1719
安装配置gi、安装数据库软件、dbca建库见下： http://blog.csdn.net/kadwf123/article/details/78429961 1、检查集群节点及状态： [root@rac2 ~]# olsnodes -s rac1 Active rac2 Active rac3 Active rac4 Active [root@rac2 ~]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值