Problem Summary

When we connect to a RAC source with a SCAN name – how do we get the exact node name?

Environment

Local Data Processing

Answer

We first go to the SCAN listener with the DB port and then the preferred node via the HVR agent port and then to the actual SID/Service using the DB port again with the local connection.