11.2.0.3 cluvfy comp healthcheck

Starting with Oracle Grid Infrastructure 11g release 2 (11.2.0.3) and later, 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.  In addition, If you want to perform best practices checks on these databases, then 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. The SQL script is cvusys.sql 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.

-rw-r--r-- 1 oracle oinstall 2841 Apr 27  2011 cvusys.sql
-rwxr-xr-x 1 oracle oinstall 1011 Apr 27  2011 cvu_config*

SQL> @cvusys.sql
DROP USER cvusys
          *
ERROR at line 1:
ORA-01918: user 'CVUSYS' does not exist

DROP ROLE cvusapp
          *
ERROR at line 1:
ORA-01919: role 'CVUSAPP' does not exist

Enter password for user cvusys
'Creating user cvusys...'
User created.

Grant succeeded.

Role created.

Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
................
................
................
................
Grant succeeded.


Usage:

cluvfy comp healthcheck [-collect {cluster|database}] [-db db_unique_name] [-bestpractice|-mandatory] [-deviations] [-html] [-save [-savedir directory_path]
cluvfy comp healthcheck
Verifying OS mandatory requirements
Verifying OS Best Practice
Verifying Clusterware mandatory requirements
Verifying Clusterware Best Practice
Verifying Database "wesbdr"
Please specify password for user "cvusys" : 

******************************************************************************************
Summary of environment
******************************************************************************************
System recommendations
******************************************************************************************
******************************************************************************************
Clusterware requirements
******************************************************************************************
******************************************************************************************
Clusterware recommendations
******************************************************************************************
Database recommendation checks for "wesbdr"
******************************************************************************************