Database Reference
In-Depth Information
ODA Configuration Audit Tool
Part of the proactive checks portfolio is ODA Configuration Audit Toolkit (odachk). Oracle has been building best
practices in their engineered and nonengineered systems portfolio for a while, and these checks include racchk,
exachk, and now for ODA—odachk.
The odachk utility is a complete auditing and assessment tool developed by Oracle's RAC Assurance team to
provide best-practice checks for RAC and Clusterware. The tool also provides various OS-specific checks. While every
version of the check can add more options and features., the following categories are key:
OS kernel parameters
OS packages
Many other OS configuration settings important to RAC
CRS/grid infrastructure
RDBMS
ASM
Database parameters
This list is pretty comprehensive, and these .checks are updated every 90 days to ensure freshness of the tests.
The updates also provide the addition of newer best practices, and solutions to known problems. The odachk
utility should be run at least on a monthly basis, and also before and after any change to the system, to ensure that
no problems have arisen in the environment. The utility also provides pre- and post-upgrade checks that allow for
upgrading to 11.2.0.3 from 11.2.0.2 to ensure that all best practices are met.
Listing 7-15 provides an example of getting the version of the odachk, as well as getting help from the odachk
utility. The odachk is updated very frequently and each version of the ODA software can contain a new version
of the utility.
Listing 7-15. ODA Checks
[root@odax32 odachk]# ./odachk -v
ODACHK VERSION: 2.2.1_20130415
[root@odax32 odachk]# ./odachk -h
Usage : ./odachk [-abvhpfmsuSo:c:rt:]
-a All (Perform best practice check and recommended patch check)
-b Best Practice check only. No recommended patch check
-h Show usage
-v Show version
-p Patch check only
...
The odachk .packs a lot of information into its output, and due to the volatile nature of checks, it is independent
on the OAK framework. The command executable is typically found at /opt/oracle/oak/odachk . You should only run
the utility as the Oracle RDBMS software owner. Running as any other user will net a message like the following:
odachk found that oracle software owner exists and its being run by root.
Let's look at a typical run of odachk. Listing 7-16 shows such a run, along with its output.
 
Search WWH ::




Custom Search