06 Nov RAC : Cluvfy DB Healthcheck option starting in 18.104.22.168
So the other day I was doing an install of the 22.214.171.124 Clusterware binaries and came around that with the cluvfy tool in 126.96.36.199 comes now with a health check option for the Database. For this option to work you have to install or setup the cvusys user as well as the cvusapp role, a script for this, is in the CLUVFY_HOME/cv/admin directory
As the oracle user run the $CLUVFY_HOME/cv/admin/cvusys.sql script to setup the mentioned user and role as well as the grants needed. This user will use the Database default tablespace, so if you want to set it up in a different tablespace you would need to modify this script.
Once you have setup the cluvfy healthcheck user, as the grid user, verify that your environment is setup for the correct $GRID_HOME.
As I came up that if the $GRID_HOME is setup incorrectly or that you pass the database name in the wrong letter case you can receive the following error PRVG-11005, even though that you will see that in the $CLUVFY_HOME/cv/log the srvctl config database is finishing successfully.
Also you can run this against all the Databases in the cluster by leaving out the out, but just take in mind that you will need to setup the cvusys user for all the Databases in the cluster, as well you can verify the best practices or what is mandatory for the Database and how does your Database deviates from this [-bestpractice|-mandatory] [-deviations].
So in this case I run it with the lower case name and with the option of deviations from the best practice, and it finished successfully.
Now just head over to the location where you saved your report and see the deviations from Oracle’s best practice, now here is where I would have to say that you need to verify before doing some of these changes as a recommendation I got was that I was running in ARCHIVELOG_MODE vs recommended NONARCHIVELOG mode, I hope you see the irony here. But if you are not doing a health check of your databases after you do a fresh install, this is a great start and will get you thinking how I can make my environment better.