Test Oracle Grid Infrastructure and Oracle RAC Deployment

The following steps describe how to test your Oracle Grid Infrastructure and Oracle RAC deployment.

1. Connect to the database using sqlplus and see if the connection successfully validates database connectivity.
2. Verify the SCAN and VIP names are online.
3. Use the crsctll stat res -t command to verify all resources are online.
4. Create a new database service for the new RAC database to check for database connections.
   To ensure connections from other applications or non-sys users, check and correct the entry in tnsnames.ora under RDBMS_Home/network/admin.
5. Run cluvfy to validate the configurations.

   GI_HOME/bin/cluvfy -post crsinst -n node1, node2

6. Run oracheck to validate the score.
7. If connecting the database from another server in another subnet, ensure to copy the tnsnames entry in your client server.