What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Could not connect to database: ORA-12505: TNS:listener does not currently know of SID given in conne

Votes:

0

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

I am getting above mentioned error message which trying to create a SQL sensor.

the sql is simple select count(*) from table name and group by column A. I am using: Port is 1521 Use direct mode (TCP/IP) Do not count number of records Ignore result set

oracle-sql-sensor sql sqlsensor

Created on Feb 8, 2017 5:40:44 PM



3 Replies

Votes:

0

What version of Oracle Database are you using? Older ones are not supported anymore by that sensor :(

Created on Feb 9, 2017 6:20:19 AM by  Stephan Linke [Paessler Support]



Votes:

0

OraClient 11g

Created on Feb 9, 2017 3:43:01 PM



Votes:

0

Okay - are you sure that the given SID is indeed correct? Was the SERVICE_NAME identifier already tried?

Created on Feb 10, 2017 1:30:34 PM by  Stephan Linke [Paessler Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.