When I Connect to a RAC Source With a SCAN Name, How Can I Get the Exact Node Name?

Question

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

Environment

DSS 6

Answer

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