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
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.
CHM signifie Cluster Health Monitor. C'est ce qui gère en temps réel les mesures du cluster.
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]
olsnodes oradb1 oradb2
crsctl query crs activeversion CRS active version on the cluster is [10.2.0.4.0]
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
crsctl query css votedisk 0. 0 /dev/ora_vot1 1. 0 /dev/ora_vot2 2. 0 /dev/ora_vot3
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--
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
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.
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
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 |
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.
./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.
srvctl config nodeapps -n sxqorr71 -a -g -s -l
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
./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.