Yes, some port and user account. As far as I can find, there's nothing different between the three SIDs, but something has got to be! There are no special characters in any of the SIDs. Outside of PRTG, I can log in with sqlplus and query any of the SIDs with the same user and password.
Here are two examples, both of which are accessible with sqlplus. Both examples show the correct SID and the correct username (which is the same for both). Both hostnames are CNAME records for the same database server:
1.
$ sqlplus [email protected]
SQL> select sys_context('userenv','instance_name') from dual;
SYS_CONTEXT('USERENV','INSTANCE_NAME')
--------------------------------------------------------------------------------
PRCT
SQL> select user from dual;
USER
------------------------------
SNS_Q
2.
$ sqlplus [email protected]
SQL> select sys_context('userenv','instance_name') from dual;
SYS_CONTEXT('USERENV','INSTANCE_NAME')
--------------------------------------------------------------------------------
PPRD
SQL> select user from dual;
USER
------------------------------
SNS_Q
But in PRTG, I set up two identical Oracle SQL v2 BETA sensors, but only the first one works:
1.
DNS Name: prct.foo.com
System ID: PRCT
SQL Query FIle: test.sql
Result: sensor OK
2.
DNS Name: pprd.foo.com
System ID: PPRD
SQL Query File: test.sql
Result: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
I get the same results whether I set up the sensors on different devices (as I've shown here) or on the same device (which used to work). Both SIDs are actually on the same device.
Add comment