Find hostname from SCAN name
Hi,
Recently I was working with one of the client for RAC database connectivity issue and he shared me a connect details (TNS entry) for database.
And that TNS entry was pointing to SCAN name (Got to know later, as was not able to connect to that host, nslookup return 3 IPS resolving in round robin).
This database was newly added support for my team , so I didn't had info about on which server this database was running. Luckily I check few project documents and there found host details.
So, my question here is that, is there any way to find out on which servers database is running if we have SCAN name with us (most of the time, as clients connect with SCAN name)?