SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Diagnosing Oracle Clusterware and RAC Components

unity avatar
unity
15 diapositives · 378 Views · Oct 20, 2014

Diagnosing Oracle Clusterware and RAC Components. Objectives. After completing this lesson, you should be able to: Collect Oracle Clusterware diagnostic files Use Cluster Verify. One Golden Rule in RAC Debugging. Always make sure that your nodes have exactly the same system time to:

Diagnosing Oracle Clusterware and RAC Components - slide 1
01 / 15Diagnosing Oracle Clusterware and RAC Components
1 / 17

Télécharger la présentation

Diagnosing Oracle Clusterware and RAC Components
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Diagnosing Oracle Clusterware and RAC Components

  2. Objectives • After completing this lesson, you should be able to: • Collect Oracle Clusterware diagnostic files • Use Cluster Verify

  3. One Golden Rule in RAC Debugging • Always make sure that your nodes have exactly the same system time to: • Facilitate log information analysis • Ensure accurate results when reading GV$ views • Avoid untimely instance evictions • The best recommendation is to synchronize nodes using Network Time Protocol.

  4. Oracle Clusterware Main Log Files /etc ORA_CRS_HOME ORACLE_HOME oracle log log <nodename>.oprocd.log <hostname> <hostname> cssd crsd racg client evmd racg client racgeut racgmain racgevtf alert<nodename>.log racgimon racgmdb racgeut racgmain

  5. Diagnostics Collection Script • Script to collect all important log files: • Must be executed as root • Is located in $ORA_CRS_HOME/bin/ • Is called diagcollection.pl • Generates the following files in the local directory: • basData_<hostname>.tar.gz • crsData _<hostname>. tar.gz • ocrData _<hostname>. tar.gz • oraData _<hostname>. tar.gz # export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 # export ORA_CRS_HOME=/u01/crs1020 # export ORACLE_BASE= =/u01/app/oracle # cd $ORA_CRS_HOME/bin # ./diagcollection.pl -collect

  6. Managing Diagnostic Data in RAC Support Workbench DIAGNOSTIC_DEST ADRBase SharedADR base diag asm rdbms DBName +asm ADRHome +ASMn +ASM1 SID1 SIDn ADRCI GV$DIAG_INFO

  7. Cluster Verify: Overview • To verify that you have a well-formed cluster for Oracle Clusterware and RAC: • Installation • Configuration • Operation • Full stack verification • Nonintrusive verification • Diagnostic mode seeks to establish a reason for the failure of any verification task. • Easy-to-use interface: • Stage commands • Component commands

  8. Cluster Verify Stages -pre dbcfg $ cluvfy stage -list Configures RAC DB -pre dbinst Installs RAC -pre crsinst Installs CRS -pre cfs -post crsinst Sets up OCFS (OPT) -post cfs User sets up thehardware,network, & storage -post hwos

  9. Cluster Verify Components • An individual subsystem or a module of the RAC cluster is known as a component in CVU. • The availability and integrity of a cluster component can be verified. • Components can be simple like a specific storage device, or complex like the Oracle Clusterware stack: • Space availability • Shared storageaccessibility • Node connectivity • Cluster File System integrity • Oracle Clusterware integrity • Cluster integrity • Administrative privileges • Peer compatibility • System requirements $ cluvfy comp -list

  10. Cluster Verify Locations • Download it from OTN: • Create a local directory. • Copy and extract cvu_<OS>.zip. • Oracle software DVD: • Disk1 directory • runcluvfy.sh • Oracle Clusterware home: • $ORA_CRS_HOME/bin/cluvfy • Oracle Home: • $ORACLE_HOME/bin/cluvfy

  11. Cluster Verify Configuration File $ cat cvu_config # Configuration file for CVU # Version: 011405 # #CV_ORACLE_RELEASE=11gR1 #CV_NODE_ALL= CV_RAW_CHECK_ENABLED=TRUE CV_ASSUME_DISTID=Taroon #CV_XCHK_FOR_SSH_ENABLED=TRUE #ORACLE_SRVM_REMOTESHELL=/usr/bin/ssh #ORACLE_SRVM_REMOTECOPY=/usr/bin/scp

  12. Cluster Verify: Examples $ cluvfy comp sys -n node1,node2 -p crs -verbose 1 $ cluvfy comp ssa -n all -s /dev/sda1 2 $ cluvfy comp space -n all -l /home/product -z 5G 3 $ cluvfy comp nodereach -n node2 -srcnode node1 4 $ cluvfy comp nodecon -n node1,node2 –i eth0 -verbose 5 $ cluvfy comp admprv -n all -o user_equiv -verbose 6 $ cluvfy comp nodeapp -n all -verbose 7 $ cluvfy comp peer -n all –verbose | more 8

  13. Cluster Verify Output: Example $ cluvfy comp crs -n all -verbose Verifying CRS integrity Checking CRS integrity... Checking daemon liveness... … Liveness of all the daemons Node Name CRS daemon CSS daemon EVM daemon ------------ ------------- --------------- ---------- atlhp9 yes yes yes atlhp8 yes yes yes Checking CRS health... Check: Health of CRS Node Name CRS OK? ---------------------------------- ------------------------ atlhp9 yes atlhp8 yes Result: CRS health check passed. CRS integrity check passed. Verification of CRS integrity was successful.

  14. Summary • In this lesson, you should have learned how to: • Collect Oracle Clusterware diagnostic files • Use Cluster Verify

  15. Practice 10: Overview • This practice covers the following topics: • Identifying Oracle Clusterware log files • Fixing voting disk corruptions