This documentation is for an older version of HVR.

How To Test Connection to Oracle RAC Using Hvrtestlistener

Question

How can I test the connection to Oracle RAC using hvrtestlistener?

Environment

HVR 5

Answer

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
```
Test the RAC redirection (and a random listener), the way HVR does internally:
```
 $ hvrtestlistener rac://scan/SERVICE 4343
```

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>`

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.