How To Test Connection to Oracle RAC Using Hvrtestlistener

Environment

HVR 5

Steps

To ensure connectivity to the HVR listeners installed in a RAC cluster, there are two things you should test.

Test connection to the listener of each of individual nodes. For each node, run the hvrtestlistener as normal:
```
 $ hvrtestlistener node1 4343
content_copy
```
Test the RAC redirection (and a random listener), the way HVR does internally:
```
 $ hvrtestlistener rac://scan/SERVICE 4343
content_copy
```

This second method uses the same redirection that HVR uses when you configure an Oracle location using the RAC radio button. The full syntax of the URL is:

rac://<scan-hostname>\[:<tnsport>\]/<service-name>` 
content_copy

After the redirection has determined which node to connect to (one of the cluster nodes that the service is running on), the regular hvrtestlistener action continues its connection to that node.

NOTE: Be wary of only running the RAC redirect test: you might end up at a correctly configured node1, and miss that node2 is not working, due to some configuration inconsistency.