1 / 15

Diagnosing Oracle Clusterware and RAC Components

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:

unity
Download Presentation

Diagnosing Oracle Clusterware and RAC Components

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related