Can't connect to Oracle database

Hello David,

Please update to the latest version of PRTG and readd the Oracle v2 Sensors in order to see if the issue still remains, using the Auto-Update. Alternatively you can download the software from our Paessler Service Center using your registered email and password:

Once you have downloaded the latest version, you can install it directly over the version currently running. The configuration and database will not be affected by installing the newer version over the old and the configuration is automatically backed up before this process.

Thanks for the reply. I upgraded to 15.2.17.2804 and re-added the sensor, but unfortunately it still does the same thing:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Hello David,

Are the SID´s using the same Port and user account? Is there something different (Encryption, protocol, etc.) between the third SID and the others? Please verify that in the SID name a special character is used. Can you please reenter the System ID in the sensors settings again to avoid invisible characters?

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.

Hello,

Please use the Utility tool TNSping (included with Oracle Client) and check if all three SID´s are connectable. (Run it on the PRTG Host (or host of the Remote Probe))

Use the following command to test connectivity tnsping <server>:<port>/<sid>

Which results do you get?

tnsping connects successfully to all three SIDs:

D:\>tnsping bandev:1521/pprd

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-AUG-2 015 12:01:53

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files: D:\sqlnet.ora

Used EZCONNECT adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=pprd))(ADDRESS=(P ROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))) OK (30 msec)

Hello David,

in the tnsping result we can see that the service name was used and not the SID´s. Could you please forward us the results using the SID in the tnsping to [email protected]. Please refer to this article.