We have an Oracle Database cluster running as a RAC on 2 servers. Currently we have only managed to get Oracle v2 SQL sensors to work when connecting directly to one database node and using the SID of the database instance running on that specific node.
We'd like to use the Oracle scan address or similar so that the database can load balance requests and failover properly should there be a node failure.
Do you have any information on best practise when connecting to Oracle Databases using RAC or scan addresses?
Any information greatly appreciated