4.2.4 About Using CVU Cluster Healthchecks After Installation

You can use the CVU healthcheck command to check your Oracle Clusterware and Oracle Database installations for their compliance with mandatory requirements and best practices guidelines, and to ensure that they are functioning properly.

Syntax

cluvfy comp baseline -collect {all|cluster|database|asm} [-n node_list|-allnodes][-d oracle_home|-db db_unique_name]
[-bestpractice|-mandatory][-binlibfilesonly]
[-reportname reportname][-savedir directory_path]

Options

Option Description
-collect [cluster | database]

Use this option to specify that you want to perform checks for Oracle Clusterware (cluster) or Oracle Database (database). If you do not use the collect flag with the healthcheck command, then cluvfy comp healthcheck performs checks for both Oracle Clusterware and Oracle Database.

-db db_unique_name

Use this flag to specify checks on the database unique name that you enter after the —db option.

CVU uses JDBC to connect to the database as the user CVUSYS to verify various database parameters. For this reason, if you want checks to be performed for the database you specify with the -db option, then you must first create the CVUSYS user on that database, and grant that user the CVU-specific role, CVUSAPP. You must also grant members of the CVUSAPP role SELECT permissions on system tables. The SQL script cvusys.sql is included in the CVU_home\cv\admin directory to facilitate the creation of this user. Use this SQL script to create the CVUSYS user on all the databases that you want to verify using CVU.

If you use the -db option but do not provide a database unique name, then CVU discovers all the Oracle databases on the cluster. To perform best practices checks on these databases, you must create the CVUSYS user on each database, and grant that user the CVUSAPP role with the SELECT privileges needed to perform the best practice checks.

[-bestpractice | -mandatory] [-deviations]
  • Use the -bestpractice option to specify best practice checks

  • Use the -mandatory option to specify mandatory checks

  • Add the -deviations option to specify that you want to see only the deviations from either the best practice recommendations or the mandatory requirements

  • If you specify neither -bestpractice or -mandatory, then both best practices and mandatory requirements are displayed.

You can specify either the -bestpractice or -mandatory option, but not both options.

-html

Use the -html option to generate a detailed report in HTML format.

If you specify the -html option, and a browser that is recognized by CVU is available on the system, then the browser is started and the report is displayed on the browser when the checks are complete.

If you do not specify the -html option, then the detailed report is generated in a text file.

-save [-savedir dir_path]

Use the -save or -save -savedir options to save validation reports (cvuchecdkreport_timestamp.txt and cvucheckreport_timestamp.htm), where timestamp is the time and date of the validation report.

If you use the -save option by itself, then the reports are saved in the path CVU_home\cv\report, where CVU_home is the location of the CVU executable files.

If you use the options -save -savedir, and enter a path where you want the CVU reports saved, then the CVU reports are saved in the path you specify.

Example 4-1 Running a Cluster Healthcheck After the Software Installation

To run a healthcheck for your Oracle Grid Infrastructure cluster, to check for any deviations from best practices, and display the results in HTML format, use the following command:

C:\> cd app\19.0.0\grid\bin
C:\..bin> cluvfy comp healthcheck -html -bestpractice -deviations

Example 4-2 Running a Healthcheck for Oracle RAC Database

To run a healthcheck for your Oracle RAC cluster, to check best practices recommendations and mandatory requirements, and display the results in HTML format, use the following command:

C:\> cd app\19.0.0\grid\bin
C:\..bin> cluvfy comp healthcheck -html