Oracle 11.2.0.3在非Exadata环境禁掉了diskmon服务
今天装了个Oracle 11.2.0.3的环境,结果发现diskmon总是处于offline状态:由于在之前的版本中ora.diskmon和ora.cssd服务是互相依
今天装了个Oracle 11.2.0.3的环境,结果发现diskmon总是处于offline状态:
[root@osdbso ~]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE osdbso
ora....ER.lsnr ora....er.type ONLINE ONLINE osdbso
ora.asm ora.asm.type ONLINE ONLINE osdbso
ora.cssd ora.cssd.type ONLINE ONLINE osdbso
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE osdbso
ora.oemrep.db ora....se.type ONLINE ONLINE osdbso
ora.ons ora.ons.type OFFLINE OFFLINE
由于在之前的版本中ora.diskmon和ora.cssd服务是互相依赖的,及这两个服务中随便停止那个两个都会停止,同样的随便启动那个两个都会启动。
可是在上面的案例中,我发现cssd服务是起来的。查看一下这两个服务的属性
[root@osdbso ~]# crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=3
DESCRIPTION="Resource type for Diskmon"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=10
SCRIPT_TIMEOUT=60
START_TIMEOUT=600
STOP_TIMEOUT=60
UPTIME_THRESHOLD=5s
[root@osdbso ~]# crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
发现两者的随has自动启动属性都是never,以为和这个有关,然后都修改为随has自动启动:
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
crsctl modify resource "ora.cssd^C-attr "AUTO_START=1"
然后从其cssd或者diskmon的服务:
[root@osdbso ~]# crsctl stop resource ora.cssd
CRS-2673: Attempting to stop 'ora.cssd' on 'osdbso'
CRS-2677: Stop of 'ora.cssd' on 'osdbso' succeeded
[root@osdbso ~]# crsctl start resource ora.diskmon
CRS-2672: Attempting to start 'ora.diskmon' on 'osdbso'
CRS-2672: Attempting to start 'ora.cssd' on 'osdbso'
CRS-2676: Start of 'ora.diskmon' on 'osdbso' succeeded
CRS-2676: Start of 'ora.cssd' on 'osdbso' succeeded
启动的时候也提示diskmon服务成功启动,但是查依然是offline状态,,并且cssd服务的日志里面存着如下信息:
2012-05-01 10:46:43.735: [ default][3976595200]CELL communication is configured to use 0 interface(s):2012-05-01 10:46:43.735: [ default][3976595200]Kgzf_ini_begin: diskmon is disabled
2012-05-01 10:46:43.735: [ CSSD][3976595200]clssscSAGEInitFencing: kgzf fence initialization successfully started
直接就误解了,没办法还是上MOS把,结果不查不知道一查吓一跳,原来在11.2.0.3版本的非Exadata数据库上,diskmon的服务是被disable掉的。
请看官文:
11.2.0.3 Grid Infrastructure diskmon Will be Offline by Default in Non-Exadata Environment [ID 1346881.1]
修改时间 26-SEP-2011 类型 ANNOUNCEMENT 状态 PUBLISHED
In this Document
Prior to 11.2.0.3:
ps -ef| grep diskmon.bin
grid 3361 3166 0 22:57 ? 00:00:00 /ocw/grid/bin/diskmon.bin -d -f
On 11.2.0.3:
ps -ef| grep diskmon.bin
>> no more diskmon.bin

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
