Problem Summary: When we connect to a RAC source with a SCAN name – how do we get the exact node name?
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