By Ravi.Sharma-Oracle on Nov 16, 2015
ORAChk (formerly ODAChk) is a handy script tool included on Oracle Database Appliance to facilitate quick checking and validation of configuration, best practices, and patches on the system. ORAChk is integrated with OAKCLI, the Oracle Database Appliance command-line interface, and should be run as the root user.
ORAChk is a handy configuration validation tool. Over time, users may knowingly or unknowingly make changes to Oracle Database Appliance configuration or the environment growth may have led to intentional or unintentional changes. ORAChk is typically used to validate Oracle Database Appliance configuration periodically (say after each upgrade or patching event, or every 3 or 6 months, etc.) and to quickly identify any deviations.
The ORAChk script tool can be accessed as “oakcli orachk” from either Oracle Database Appliance server node. The tool can be run against any of the available database environments currently running on the servers and the output is displayed on the screen as well as captured in an HTML file (and zip file) located within the /opt/oracle/oak/orachk directory for easier viewing (and upload to Oracle Support, if needed).
Among other things, such as verifying that Oracle Database Appliance adheres to the best practices and that any customizations have not have resulted in a configuration deviation from those best practices, ORAChk also checks and validates the operation of the Oracle software stack on both servers in the Oracle Database Appliance cluster.
Some of the checks that are carried out by ORAChk are as follows:
- Checks against Oracle Database Appliance Best Practices reference set
- ASM Disk Group attributes and ASM initialization parameters
- Database standard and undocumented parameters’ settings
- Kernel parameters and shared memory configuration
- OS packages installed and patches for Grid Infrastructure and for RDBMS home
The ORAChk output highlights actionable items and upon reviewing ORAChk output, action may be planned for addressing any anomalies to re-align the Oracle Database Appliance configuration as originally intended.