Hello, I have Oracle RAC Cluster and I'm trying to query it using PRTG. I would like to test connectivity to the Oracle database using PRTG Oracle SQL Sensor. The SQL Expression: select count(*) from sys.v_$session. The Connection mode: Use Direct Mode (TCP/IP) For direct mode I using the service name as defined in "tnsnames.ora".
The error that I get: Could not connect to database: NET: Invalid SID
As far as I know the connection method to RAC DB is through service and no SID.