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

最新推荐文章于 2021-04-15 21:31:00 发布

cuilian2013

最新推荐文章于 2021-04-15 21:31:00 发布

阅读量135

点赞数

文章标签：数据库 shell 运维

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

In this Document

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:

OS kernel parameters
OS packages
Many other OS configuration settings important to RAC.
CRS/Grid Infrastructure
RDBMS
ASM
Database parameters
Many other database configuration settings important to RAC
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.

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.
Stage the appropriate raccheck.zip kit in its own directory the node on which the tool will be executed
Unzip raccheck.zip kit, leaving the script. and driver files together in the same directory
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
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

. . . . . . . . . . . . . . .
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
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

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)