Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, June 27, 2012

cluvfy Healthcheck

Normally we run cluvfy in preparation of the installation of Grid Infrastructure or a set of RAC binaries to ensure everything is ready for the next step in the RAC install process. Beginning with 11.2.0.3, there is another option  "healthcheck" 
Part of the “comp” checks, it takes the following options:
cluvfy comp healthcheck [-collect {cluster|database}] [-db db_unique_name] [-bestpractice|-mandatory] [-deviations] [-html] [-save [-savedir directory_path]

The most extensive report is run without any options, as shown in the appendix (the output is too long to display at this stage of the post) You have the following options:
  • collect: you can either specify to collect information about the cluster, or the database. Don’t specify the collect option and the health check will collect information about both.
  • db: database unique name to collect information for. Before you can use this option, you need to run the script cvusys.sql in $GRID_HOME/cv/admin. It will create a user the healthcheck tool will connect against to find recommendations. If omitted, all cluster databases registered in the OCR will be probed.
  • bestpractice, mandatory, deviations are self explanatory.
  • html: Creates a HTML report in savedir, see below. If not used, a text based output is created
  • save, savedir: save the report in savedir
Examples:
Run to check for cluster health only
D:\app\11.2.0.3\grid\BIN>cluvfy comp healthcheck -collect cluster -html -save -savedir d:\temp
C:\Windows\system32\cmd.exe  /K D:\app\11.2.0\grid\bin\cluvfy  comp health -_format
Run to check for database health only  
SQL>@D:\app\11.2.0.3\grid\cv\admin\cvusys.sql -- run before healthcheck
D:\app\11.2.0.3\grid\BIN>cluvfy comp healthcheck -collect database -db dbrac -html
 -save -savedir d:\temp
Run to check both (-html not specified so report will be in text format)
D:\app\11.2.0.3\grid\BIN>cluvfy comp healthcheck -save -savedir d:\temp 

Note: If you want to see other options for cluvfy , you can use below command
D:\app\11.2.0.3\grid\BIN>cluvfy comp -list  [will display all valid components]

No comments: