ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RACcheck - RAC Configuration Audit Tool (文档 ID 1268927.1)

RACcheck - RAC Configuration Audit Tool (文档 ID 1268927.1)

原创 Linux操作系统 作者:rongshiyuan 时间:2013-10-30 00:26:42 0 删除 编辑

RACcheck - RAC Configuration Audit Tool (文档 ID 1268927.1)

In this Document

Purpose
Requirements
Configuring
Instructions
 Quick Start Guide
Script
 Download RACcheck 2.2.3 Production
 Troubleshooting
 Obtaining Support
Sample Output
 Community Discussions
References

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]
IBM AIX on POWER Systems (64-bit)
Linux x86-64
Oracle Solaris on x86-64 (64-bit)
Oracle Solaris on SPARC (64-bit)
HP-UX PA-RISC (64-bit)
HP-UX Itanium
RACcheck is a tool developed by the RAC Assurance development team for use by customers to automate the assessment of RAC systems for known configuration problems and best practices.

Purpose

RACcheck is a RAC Configuration Audit tool  designed to audit various important configuration settings within a Real Application Clusters (RAC), Oracle Clusterware (CRS), Automatic Storage Management (ASM) and Grid Infrastructure environment. The tool audits configuration settings within the following categories:

  1. OS kernel parameters
  2. OS packages
  3. Many other OS configuration settings important to RAC.
  4. CRS/Grid Infrastructure
  5. RDBMS
  6. ASM
  7. Database parameters
  8. Many other database configuration settings important to RAC
  9. 11.2.0.3 Upgrade Readiness assessment
Note: Refer to Document 1457357.1 (RACcheck 11.2.0.3 Upgrade Readiness Assessment) for more information on RACcheck Upgrade Readiness feature.

 

Requirements

Supported Platforms

  • Linux x86-64* (Enterprise Linux, RedHat and SuSE 9, SuSE 10 & SuSE 11)
  • Oracle Solaris SPARC (Solaris 10 and 11)
  • Oracle Solaris x86-64 (Solaris 10 and 11)
  • AIX **
  • HPUX**

* 32-bit platforms not supported, no planned support for Linux Itanium
**Requires BASH Shell 3.2 or higher to be installed


Supported Oracle Releases

  • 10gR2
  • 11gR1
  • 11gR2
  • 12cR1

Note:  As of version 2.2.0, RACcheck supports Single Instance, Oracle Restart as well as RAC (including RAC One)

Configuring

Please download and review the RACcheck Users Guide for specific instructions on how to configure and run RACcheck.  A Quick Start Guide is provided in the Instructions section of this Note.

FAST TRACK:  For those already familiar with RACcheck - The RACcheck utility is available for download in the SCRIPT section of this document.

Note:  To obtain the most out of RACcheck, root access (via password or SUDO) is recommended.  However RACcheck does provide an option to skip these checks (not recommended).  The listing of checks requiring root (which will be skipped if root access is unavailable) can be found in Platform-wiseChecksWhichRequiresRoot.

 

Instructions

Whats New?

While we certainly can not list out all of the RACcheck enhancements for every new release we do want to bring attention to key new features in the latest version(s) of RACcheck.

v. 2.2.3

  • GoldenGate Best Practice checks (applicable only for databases running GoldenGate)
  • Consolidation Best Practices in MAA Score Card
  • RACcheck Daemon enhancement allowing for execution at specific scheduled dates/times in addition to interval option
  • RACcheck Daemon diff check of current and current-1 reports and emails if differences are found
  • Ability to exclude checks based on the check name
  • Excluded checks are listed in html report
  • Visual progress indicators have been added to confirm script. progression at key points
  • New checks and bug fixes

v. 2.2.2

  • Execution as the root user for sysadmin profile is now possible, e.g. ./raccheck -profile sysadmin
  • RACcheck daemon feature to automate execution of RACcheck non-interactively at predefined interval
  • Support for Solaris Sparc 11
  • Upgrade best practices for 11.2.0.3, 11.2.0.4 (not yet released) and 12c
  • RACcheck output directory restructure
  • Standard health check is now included in post upgrade
  • New checks and bug fixes

v. 2.2.1

  • Execution performed in parallel on all nodes (OS expect utility or SUDO is REQUIRED to enable root checks with this functionality)
  • Use of profiles to execute a subset of checks, e.g. DBA, Sysadmin, ASM
  • Ability to compare two RACcheck reports
  • New checks and bug fixes

v. 2.2.0

  • Support for Single Instance, Oracle Restart and RAC One Configurations
  • High Availability (HA) Best Practices using the new -r flag (raccheck -r).  This mode of operation includes the standard health checks as well as HA Best Practices. Only HA Best Practices can be validated with the -c flag (raccheck -c).
  • New checks and bug fixes

v. 2.1.6

  • New Supported Platforms:
    • OEL and RHEL 6
    • HP-UX (BASH shell 3.2 or higher required)
    • AIX 7 (BASH shell 3.2 or higher required)
  • HTML Report ADA Compliance
  • New checks and bug fixes

v. 2.1.5

  • Pre-11.2.0.3 (GI and RDBMS) Best Practice Validation - see Document 1457357.1 RACcheck 11.2.0.3 Upgrade Readiness Assessment
  • Post-11.2.0.3 (GI and RDBMS) Best Practice Validation - see Document 1457357.1 RACcheck 11.2.0.3 Upgrade Readiness Assessment
  • MAA Scorecard is now the default execution method (-m option now will DISABLE the MAA Scorecard)
  • Reporting enhancements

v. 2.1.4

  • Remote database support RACcheck will check database best practices even database instance is not running on the node where its being run.
  • Solaris X86-64 support.
  • Support for Multiple Database Versions on the Same Cluster.
  • Reporting enhancements

v. 2.1.3

  • MAA Scorecard - RACcheck now provides you with the ability to perform. MAA Best Practice checks.  The MAA Scorecard will be produced when RACcheck is executed with the "-m" option:
    [oracle@ratlnx01 raccheck]$ ./raccheck -m

    Note: For more information on the MAA Scorecard see the full RACcheck Users Guide.

v. 2.1.2

  • HTML Report - The HTML based report allows for ease of reading and navigation through the report.

Quick Start Guide

Note:   For details instructions on how to run RACcheck including troubleshooting steps, available options, etc; please download and review the latest RACcheck Users Guide.  For an interactive walk through of the execution of RACcheck please review the RACcheck Viewlet found within the Sample Output section of this note. 

Running RACcheck Interactively


Note:  If problems are encountered either at runtime or if there are questions about the content of the findings of the tool, please post your issues/questions/concerns to the RACcheck Thread of the Scalability RAC My Oracle Support Community.

  1. Log in to the system as the Oracle RDBMS software installation owner (if Oracle products installed, otherwise log in as root) -- See Usage Considerations in the RACcheck Users Guide for details.
  2. Stage the appropriate raccheck.zip kit in its own directory the node on which the tool will be executed
  3. Unzip raccheck.zip kit, leaving the script. and driver files together in the same directory
  4. Validate the permissions for raccheck are 755 (-rwxr-xr-x). If the permissions are not currently set to 755, set the permissions on raccheck as follows:
    $ chmod 755 raccheck
  5. Invoke the tool as follows:
    $ ./raccheck

    Note:  The MAA Scorecard is now (as of v. 2.1.5) the default execution method, this can be disabled with the "-m" option.

    Follow the prompts while reading and understanding all messages. The Q&A process of RACcheck will be similar to that shown below:
    CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /oragi/11.2.0.3/grid?[y/n][y]y

    Checking ssh user equivalency settings on all nodes in cluster

    Node ratlnx02 is configured for ssh user equivalency for oracle user


    Searching for running databases . . . . .

    .
    List of running databases registered in OCR
    1. maadb
    2. None

    Select respective number to choose database for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
    . .

    Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

    . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
    -------------------------------------------------------------------------------------------------------
    Oracle Stack Status
    -------------------------------------------------------------------------------------------------------
    Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
    -------------------------------------------------------------------------------------------------------
    ratlnx01    Yes         Yes      Yes              Yes    Yes    Yes         maadb1
    ratlnx02    Yes         Yes      Yes              Yes    Yes    Yes         maadb2
    -------------------------------------------------------------------------------------------------------

    9 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which  require root privileged data collection can be skipped.


    1. Enter 1 if you will enter root password for each  host when prompted

    2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script

    3. Enter 3 to skip the root privileged collections

    4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later.

    Please indicate your selection from one of the above options[1-4][1]:-
    Note: If you chose option 1, to provide root password when prompted, you will be prompted once for each node during the data collection phase for the nodes (unless expect is installed). If you do not enter the root password in a timely way (within RACCHECK_TIMEOUT) then the root privileged collections and audit checks for that node will be skipped.  For functionality of parallel execution of RACcheck on all cluster nodes, the expect utility MUST be installed.  For this reason it is highly recommended that the expect utility be installed on the systems.


    Please indicate your selection from one of the above options[1-4][1]:- 1Is root password same on all nodes?[y/n][y]y


    Enter root password :-



    *** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***


    Log file for collections and audit checks are at
    /home/oracle/raccheck/raccheck_120211_112221/raccheck.log


    . . . . . . . . . . . . . . .
  6. Upon completion, the following (or similar) will be displayed:

    Detailed report (html) - /home/oracle/raccheck/raccheck_ratlnx01_120211_114104/raccheck_ratlnx01_120211_114104.html


    UPLOAD(if required) - /home/oracle/raccheck/raccheck_ratlnx01_120211_114104.zip
  7. At this point you may view the HTML output in the file shown in the output above. If there is an active SR which RACcheck was recommended as part of its resolution, upload the raccheck_*.zip to that SR.

Caution

This sample code is provided for educational purposes only, and is not supported by Oracle Support. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Script

Download RACcheck 2.2.3 Production

Current Production Version: 2.2.3_20131007 - released on October 7th 2013.  It is recommended to always be running the latest version of RACcheck.  The latest version of RACcheck is attached to this note and can be downloaded below.

  
 Download RACcheck  Download RACcheck  Download RACcheck 

 

Note:  Users of later versions of IE report that the raccheck.zip file is corrupt.  If you are experiencing such issues with the raccheck.zip please try downloading the utility with different web browser.

The checksum of the RACcheck.zip file can be verified with any checksum utility and should match the checksum output below (example is on Linux):

[oracle@ratlnx01 ~]$ cksum raccheck.zip
1986236595 3379414 raccheck.zip


 

The installed version of RACcheck can be validated as follows:

[oracle@ratlnx01 raccheck]$ ./raccheck -v
RACCHECK  VERSION: 2.2.3_20131007

 

Troubleshooting

Refer to Document 1509746.1 RACcheck Known Issues for troubleshooting information.

Obtaining Support

RACcheck is supported via the RAC/Scalability MOS Community Forums (See the Community Discussions below). 

Sample Output

Once RACcheck execution has completed, the HTML report will be very much similar to that of in this RACcheck Sample Report.

 

 

Community Discussions

Still have questions? Use the communities window below to search for similar discussions or start a new discussion on this subject.

Note: Window is the LIVE community not a screenshot.

Click here to open in main browser window.

 



References

NOTE:1457357.1 - RACcheck Upgrade Readiness Assessment
NOTE:810394.1 - RAC and Oracle Clusterware Best Practices and Starter Kit (Platform. Independent)
 

附件

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-775303/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3200715