FAQ cluster Oracle OCR

Mise à jour: 28 septembre 2014
Version: 1.0
Author: Jean-Louis Bicquelet-Salaün
Location: http://jlbicquelet.free.fr
Copyright: (c) 2014 Jean-Louis BICQUELET-SALAÜN

OCR Frequently-Asked Questions

Cette FAQ concerne les cluster oracle 10.2

Pour plus d'information au sujet de cette faq, contactez Jean-Louis BICQUELET


FAQ Revised: Sunday 28 September 2014 10:55:29


Table of Contents

1. definition
2. configuration
3. vote
4. status
5. debug

1. definition

1.1. Qu'est ce qu'un voting disk ?

Un Voting Disk (disque de vote) gère les membre d'un cluster oracle grace à un health check et arbitre les problème d'appartenance des instances dans le cas de coupure réseau.

RAC utilise les @b(voting disk) pour déterminer quelles instances sont membre d'un luster.

Les voting disk doivent appartenir à un lot de disques partagés.

Pour des raisons de haute disponibilité, il est recommandé d'avoir plusieurs voting disk. must reside on shared disk. For high availability, Oracle recommends that you have multiple voting disks.

1.2. Que signifie CHM?

CHM signifie Cluster Health Monitor. C'est ce qui gère en temps réel les mesures du cluster.


2. configuration

2.1. Comment connaitre le numéro de version de CRS?
 crsctl query crs softwareversion
CRS software version on node [oradb01] is [10.2.0.4.0]

On peut aussi interroger la version pour un autre noeud du cluster.

 crsctl query crs softwareversion oradb02
CRS software version on node [oradb02] is [10.2.0.4.0]


2.2. Comment lister les membres d'un cluster?
olsnodes
oradb1
oradb2


2.3. Comment connaitre le numéro de la version active de CRS?
crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.4.0]


2.4. Comment vérifier le backup de la configuration OCR?
ocrconfig -showbackup

oradb01     2014/09/26 06:53:43     /apps/crs/10.2.0/cdata/crs_sora1

oradb01     2014/09/26 02:53:42     /apps/crs/10.2.0/cdata/crs_sora1

La log générée se trouve dans ORACLE_HOME/crs/10.2.0/log SERVEUR/client/ocrconfig_PID.log


3. vote

3.1. Comment verifier les disques de vote ?
crsctl query css votedisk
 0.     0    /dev/ora_vot1
 1.     0    /dev/ora_vot2
 2.     0    /dev/ora_vot3



4. status

4.1. Comment lister les ressources du cluster ?
crs_stat -ls
Name           Owner          Primary PrivGrp          Permission
-----------------------------------------------------------------
ora....A1.inst oracle         oinstall                 rwxrwxr--
ora....A2.inst oracle         oinstall                 rwxrwxr--
ora....PA1.srv oracle         oinstall                 rwxrwxr--
ora....4A_P.cs oracle         oinstall                 rwxrwxr--
ora.ORRXPA.db  oracle         oinstall                 rwxrwxr--
ora....B1.inst oracle         oinstall                 rwxrwxr--
ora....B2.inst oracle         oinstall                 rwxrwxr--
ora....PB2.srv oracle         oinstall                 rwxrwxr--
ora....4B_P.cs oracle         oinstall                 rwxrwxr--
ora.ORRXPB.db  oracle         oinstall                 rwxrwxr--
ora....I1.inst oracle         oinstall                 rwxrwxr--
ora....I2.inst oracle         oinstall                 rwxrwxr--
ora....PI2.srv oracle         oinstall                 rwxrwxr--
ora....5A_P.cs oracle         oinstall                 rwxrwxr--
ora....PI1.srv oracle         oinstall                 rwxrwxr--
ora....5B_P.cs oracle         oinstall                 rwxrwxr--
ora....PI1.srv oracle         oinstall                 rwxrwxr--
ora....PI2.srv oracle         oinstall                 rwxrwxr--
ora....5D_P.cs oracle         oinstall                 rwxrwxr--
ora.ORRXPI.db  oracle         oinstall                 rwxrwxr--
ora....SM1.asm oracle         oinstall                 rwxrwxr--
ora....A1.lsnr oracle         oinstall                 rwxrwxr--
ora....rg1.gsd oracle         oinstall                 rwxr-xr--
ora....rg1.ons oracle         oinstall                 rwxr-xr--
ora....rg1.vip root           oinstall                 rwxr-xr--
ora....M2.asm oracle          oinstall                 rwxrwxr--
ora....A2.lsnr oracle         oinstall                 rwxrwxr--
ora....ra2.gsd oracle         oinstall                 rwxr-xr--
ora....ra2.ons oracle         oinstall                 rwxr-xr--
ora....ra2.vip root           oinstall                 rwxr-xr--


4.2. Comment vérifier l'état du cluster ?
crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora....G1.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....G2.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....PG1.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg1
ora....4A_P.cs application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora.ORRXPG.db  application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora....H1.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....H2.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....PH2.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg2
ora....4B_P.cs application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora.ORRXPH.db  application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora....I1.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....I2.inst application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....PI2.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg2
ora....5A_P.cs application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora....PI1.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg1
ora....5B_P.cs application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora....PI1.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg1
ora....PI2.srv application    0/0    0/0    ONLINE    ONLINE    sxporrg2
ora....5D_P.cs application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora.ORRXPI.db  application    0/0    0/1    ONLINE    ONLINE    sxporrg2
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....G1.lsnr application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....rg1.gsd application    0/5    0/0    ONLINE    ONLINE    sxporrg1
ora....rg1.ons application    0/3    0/0    ONLINE    ONLINE    sxporrg1
ora....rg1.vip application    0/0    0/0    ONLINE    ONLINE    sxporrg1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....G2.lsnr application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....rg2.gsd application    0/5    0/0    ONLINE    ONLINE    sxporrg2
ora....rg2.ons application    0/3    0/0    ONLINE    ONLINE    sxporrg2
ora....rg2.vip application    0/0    0/0    ONLINE    ONLINE    sxporrg2


4.3. Comment vérifier l'état de CRS ?
cluvfy comp crs -n all

Verifying CRS integrity

Checking CRS integrity...

Checking daemon liveness...
Liveness check passed for "CRS daemon".

Checking daemon liveness...
Liveness check passed for "CSS daemon".

Checking daemon liveness...
Liveness check passed for "EVM daemon".

Checking CRS health...
CRS health check passed.

CRS integrity check passed.

Verification of CRS integrity was successful.

Un exemple d'erreur:

Verifying CRS integrity
Unable to retrieve nodelist from Oracle clusterware.

Verification cannot proceed.


4.4. quelles sont les processus qui tournent pour le cluster oracle ?
 ps -ef|grep d.bin
  oracle  667786 1269960   2   Feb 24      - 3590:11 /apps/crs/10.2.0/bin/ocssd.bin
  oracle  790744 1167384   0 11:36:27  pts/0  0:00 grep d.bin
  oracle 1200132       1   0   Feb 24      - 62:55 /apps/crs/10.2.0/bin/evmd.bin
    root 1335506  782526   1   Feb 24      - 8881:56 /apps/crs/10.2.0/bin/crsd.bin reboot


4.5. quelles sont les vérifications possibles ?

Vérification de l'intégrité CRS cluvfy comp crs
Vérification de l'intégrité de l'OCR cluvfy comp ocr
Vérification des shared raw devices cluvfy comp ssa -n all


4.6. Comment vérifier l'intégrité de l'OCR ?
cluvfy comp ocr

Verifying OCR integrity

Checking OCR integrity...

Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations.

ERROR:
Unable to obtain OCR integrity details from any of the nodes.

OCR integrity check failed.

Verification of OCR integrity was unsuccessful on all the nodes.


4.7. Comment vérifier l'intégrité de CRS ?
./cluvfy comp crs

Verifying CRS integrity

Checking CRS integrity...

Checking daemon liveness...
Liveness check failed for "CRS daemon".
Check failed on nodes:
        oradb01

Checking daemon liveness...
Liveness check failed for "CSS daemon".
Check failed on nodes:
        oradb01

Checking daemon liveness...
Liveness check failed for "EVM daemon".
Check failed on nodes:
        oradb01

CRS integrity check failed.

Verification of CRS integrity was unsuccessful on all the nodes.




5. debug

5.1. Comment vérifier la configuration VIP d'un cluster ?
srvctl config nodeapps -n sxqorr71 -a -g -s -l


5.2. Comment lister les modules disponibles pour debugger CRS ?
crsctl lsmodules crs
The following are the CRS modules ::
    CRSUI
    CRSCOMM
    CRSRTI
    CRSMAIN
    CRSPLACE
    CRSAPP
    CRSRES
    CRSCOMM
    CRSOCR
    CRSTIMER
    CRSEVT
    CRSD
    CLUCLS
    CSSCLNT
    COMMCRS
    COMMNS


5.3. Comment connaitre l'état d'un cluster CRS ?
./crsctl debug statedump crs
Dumping State for crs objects

crsctl debug statedump crs
error 9 encountered when connecting to CRSD

Dans le deuxième cas on rencontre une erreur.