- 浏览: 4370757 次
- 性别:
- 来自: 厦门
文章分类
- 全部博客 (634)
- Oracle日常管理 (142)
- Oracle体系架构 (45)
- Oracle Tuning (52)
- Oracle故障诊断 (35)
- RAC/DG/OGG (64)
- Oracle11g New Features (48)
- DataWarehouse (15)
- SQL, PL/SQL (14)
- DB2日常管理 (9)
- Weblogic (11)
- Shell (19)
- AIX (12)
- Linux/Unix高可用性 (11)
- Linux/Unix日常管理 (66)
- Linux桌面应用 (37)
- Windows (2)
- 生活和工作 (13)
- 私人记事 (0)
- Python (9)
- CBO (15)
- Cognos (2)
- ORACLE 12c New Feature (2)
- PL/SQL (2)
- SQL (1)
- C++ (2)
- Hadoop大数据 (5)
- 机器学习 (3)
- 非技术 (1)
最新评论
-
di1984HIT:
xuexilee!!!
Oracle 11g R2 RAC高可用连接特性 – SCAN详解 -
aneyes123:
谢谢非常有用那
PL/SQL的存储过程和函数(原创) -
jcjcjc:
写的很详细
Oracle中Hint深入理解(原创) -
di1984HIT:
学习了,学习了
Linux NTP配置详解 (Network Time Protocol) -
avalonzst:
大写的赞..
AIX内存概述(原创)
crsctl语法
$./crsctl
Usage: crsctl check crs - checks the viability of the CRS stack
crsctl check cssd - checks the viability of CSS
crsctl check crsd - checks the viability of CRS
crsctl check evmd - checks the viability of EVM
crsctl set css <parameter> <value> - sets a parameter override
crsctl get css <parameter> - gets the value of a CSS parameter
crsctl unset css <parameter> - sets CSS parameter to its default
crsctl query css votedisk - lists the voting disks used by CSS
crsctl add css votedisk <path> - adds a new voting disk
crsctl delete css votedisk <path> - removes a voting disk
crsctl enable crs - enables startup for all CRS daemons
crsctl disable crs - disables startup for all CRS daemons
crsctl start crs - starts all CRS daemons.
crsctl stop crs - stops all CRS daemons. Stops CRS resources in case of cluster.
crsctl start resources - starts CRS resources.
crsctl stop resources - stops CRS resources.
crsctl debug statedump evm - dumps state info for evm objects
crsctl debug statedump crs - dumps state info for crs objects
crsctl debug statedump css - dumps state info for css objects
crsctl debug log css [module:level]{,module:level} ...
- Turns on debugging for CSS
crsctl debug trace css - dumps CSS in-memory tracing cache
crsctl debug log crs [module:level]{,module:level} ...
- Turns on debugging for CRS
crsctl debug trace crs - dumps CRS in-memory tracing cache
crsctl debug log evm [module:level]{,module:level} ...
- Turns on debugging for EVM
crsctl debug trace evm - dumps EVM in-memory tracing cache
crsctl debug log res <resname:level> turns on debugging for resources
crsctl query crs softwareversion [<nodename>] - lists the version of CRS software installed
crsctl query crs activeversion - lists the CRS software operating version
crsctl lsmodules css - lists the CSS modules that can be used for debugging
crsctl lsmodules crs - lists the CRS modules that can be used for debugging
crsctl lsmodules evm - lists the EVM modules that can be used for debugging
If necesary any of these commands can be run with additional tracing by
adding a "trace" argument at the very front.
Example: crsctl trace check css
使用案例
检查crs状态
$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
检查单个状态
$ crsctl check css
CSS appears healthy
启动crs栈,必须使用root用户
# ./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
停止crs栈,必须使用root用户
# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
# ./crsctl disable crs
# ./crsctl enable crs
这个命令实际是修改了/etc/oracle/scls_scr/raw/root/crsstart这个文件里的内容。
查看votedisk磁盘位置
$ crsctl query css votedisk
0. 0 /dev/raw/raw2
located 1 votedisk(s).
增加votedisk
# ./crsctl add css votedisk /dev/raw/raw3 -force
Now formatting voting disk: /dev/raw/raw3
successful addition of votedisk /dev/raw/raw3.
删除votedisk
# ./crsctl delete css votedisk /dev/raw/raw4 -force
successful deletion of votedisk /dev/raw/raw4.
关于维护votedisk的相关内容可以查看笔者的如下博客
http://czmmiao.iteye.com/admin/blogs/1758360
查看crs参数
$crsctl get css misscount
60
修改crs参数,必须为root用户
# ./crsctl set css miscount 60
跟踪crs模块,提供辅助功能
CRS由CRS,CSS,EVM三个服务组成,每个服务又是由一系列module组成,crsctl允许对每个module进行跟踪,并把跟踪内容记录到日志中。
$ crsctl lsmodules css
The following are the CSS modules ::
CSSD
COMMCRS
COMMNS
$ crsctl lsmodules evm
The following are the EVM modules ::
EVMD
EVMDMAIN
EVMCOMM
EVMEVT
EVMAPP
EVMAGENT
CRSOCR
CLUCLS
CSSCLNT
COMMCRS
COMMNS
跟踪CSSD模块,需要root用户执行:
# ./crsctl debug log css "CSSD:1"
Configuration parameter trace is now set to 1.
Set CRSD Debug Module: CSSD Level: 1
查看跟踪日志
# pwd
/u01/app/oracle/product/crs/log/rac1/cssd
# more ocssd.log
[ CSSD]2013-01-05 16:32:38.533 [98499472] >TRACE: clssgmClientConnectMsg: Connect from con(0x92d9248) proc(0x92def28) pid() proto(10:2:1:1)
[ CSSD]2013-01-05 16:33:39.309 [98499472] >TRACE: clssgmClientConnectMsg: Connect from con(0x92df0f0) proc(0x92d9e78) pid() proto(10:2:1:1)
[ CSSD]2013-01-05 16:33:39.481 [98499472] >TRACE: clssgmClientConnectMsg: Connect from con(0x92df488) proc(0x92def08) pid() proto(10:2:1:1)
[ CSSD]2013-01-05 16:34:27.955 [88009616] >TRACE: clssscSetDebugLevel: The logging level is set to 1 ,the cache level is set to 2
[ CSSD]2013-01-05 16:34:40.508 [98499472] >TRACE: clssgmClientConnectMsg: Connect from con(0x92df0f0) proc(0x92defa8) pid() proto(10:2:1:1)
[ CSSD]2013-01-05 16:34:40.929 [98499472] >TRACE: clssgmClientConnectMsg: Connect from con(0x92dad28) proc(0x92db440) pid() proto(10:2:1:1)
参考至:《大话Oracle Rac》张晓明著
本文原创,转载请注明出处、作者
如有错误,欢迎指正
邮箱:czmcj@163.com
发表评论
-
Duplicate a Database Using RMAN in Oracle Database 11g Release 2
2016-11-03 15:38 937Duplicate a Database Using RMA ... -
grid control 安装总结 (三)之EMD upload error: uploadXMLFiles skipped或忘记OMS密码
2014-11-17 17:16 2770[oracle@anbob agent10g]$ bin/e ... -
Grid Control服务端看不到Agent相关信息,同时OMS状态为unknown处理
2014-11-17 17:14 2145一次Grid Control的agent是启动的,但是在GC ... -
给11gR2 RAC添加LISTENER监听器并静态注册
2014-10-22 17:52 3152之前有同学想要给11gR2的RAC添加LISTENER监听器 ... -
HOW TO REMOVE CRS AUTO START AND RESTART FOR A RAC INSTANCE
2014-10-12 20:08 1460Subject: HOW TO REMOVE CRS AU ... -
How To Enable Archive Logging In RAC Environment [ID 1186764.1]
2014-10-12 19:45 1010How To Enable Archive Logging ... -
Oracle 11g RAC使用Manual和Policy Managed方法配置
2014-10-12 17:25 8855软件环境: 操作系统:Red Hat Enterpris ... -
Moving OCR and Voting Disk to Oracle ASM Online
2014-10-12 16:35 2625Prior Oracle 11gR2, it was only ... -
Oracle 11g R2的启动与关闭(原创)
2014-10-10 15:04 27182概述 Oracle 11gR2 中对CRSD资源进行了重新 ... -
重新配置与卸载11gR2 Grid Infrastructure
2014-10-10 08:24 2289概述Oracle 11g R2 Grid Infrastru ... -
Data Guard Broker Properties
2014-10-07 16:15 962Data Guard Broker Properties ... -
Data Guard - Snapshot Standby Database配置
2014-10-07 07:39 932概述一般情况下,物理standby数据库处于mount状态 ... -
Active Data Guard
2014-10-06 19:27 866Oracle Active Data Guard is a ... -
Data Guard Broker系列之六:Fast-Start Failover
2014-10-06 18:29 3064Fast-Start Failover 基本概念 Fa ... -
Data Guard Broker系列之五:数据库角色转换
2014-10-06 18:28 1226数据库转换的基本概 ... -
Data Guard Broker系列之四:数据库管理
2014-10-06 18:27 1192数据库状态管理 数据 ... -
Data Guard Broker系列之三:Data Guard Broker配置管理
2014-10-06 16:56 1258配置data guard broker配置文件基本参数 ... -
Data Guard Broker系列之二:Data Guard Broker配置实战
2014-10-05 16:16 1571配置之前DG环境状态 测试的DG环境安装在同一个机器上, ... -
Data Guard broker系列之一:Data Guard Broker基础
2014-10-05 16:13 2269Data Guard broker概览 Data ... -
Dataguard切换保护模式(从MAXIMUM PERFORMANCE 到 maximize availability)
2014-10-05 14:52 12371. 首先查看主库当前保护模式(主库操作)SQL> s ...
相关推荐
CRSCTL命令的用法举例 CRSCTL命令的用法举例 CRSCTL命令的用法举例
linux服务器安装oracleRAC集群使用CRSCTL指令检查各个节点是否正常,确保数据库正常运行
Oracle 10G RAC 日常管理 CRS的管理 CRSCTL命令控制着本地节点的CRS服务(Oracle clusterware processes) SRVCTL命令介绍 SRVCTL命令可以控制RAC数据库中的instance,listener以及services。
linux中oracle的日常维护命令 操作命令以及问题分析
oracle_rac管理基本命令 rac oracle clusterware 命令集 按不同层次划分 1.节点层次,olsnodes 2.网络层,oifcfg 3.集群层,crsctl,ocrcheck,ocrdump,ocrconfig 4.应用层,srvctl ,onsctl,crs_stat ……
cvn check crsctl check crs
使用crsctl disable/enable crs命令可以禁用/启用crs的自启动,但没有命令去查看当前自启动状态,虽然命令可以反复执行,但看不到实际状态总归还是让人不放心。 我在Linux测试环境下试了几个Oracle RAC版本: ...
ORACLE RAC 节点有关的操作 srvctl crs_stop crs_stat crsctl
root@oeltan1 ~]# crsctl stop crs 启动: 代码如下: [root@oeltan1 ~]# crsctl start crs [oracle@oeltan1 ~]$srvctl start asm -n node_name 上述开机一般已经启动 代码如下: [oracle@oeltan1 ~]$ srvctl start ...
1)、检查集群状态: [grid@rac02 ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online 2)、所有 ...
[oracle@racdb1 ogg]$ crsctl stat res -t ... Cluster Resources -------------------------------------------------------------------------------- ggvip 1 ONLINE ONLINE racdb1 oggapp 1 ONLINE ON...
在自己的虚拟机的做实验,突然发现使用PL/SQL ...使用crsctl查看资源状态:发现监听的状态确实是OFFLINE状态 [root@rhel7 .oracle]# crsstat ----------------------------------------------------------------------
通过操作系统命令top topas glance等查看top进程号,确认是系统进程还是oracle应用进程,查询当前top进程执行的操作和sql语句进行分析。 根据进程号获取正在执行的sql SELECT a.osuser, a.username,b.address,...
10.2.2 CRSCTL工具 10.2.3 SRVCTL工具 10.2.4 OIFCFG接口配置工具 10.3验证工具CVU 10.3.1基于阶段的验证 10.3.2 Grid Infrastructure安装阶段验证 10.3.3基于组件的验证 10.3.4共享存储组件验证 10.3.5遇到...