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

Modified on 2025-06-10 21:43:57 +0200

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

Article Comments

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

Feb, 2017 - Permalink

OraClient 11g

Feb, 2017 - Permalink

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

Feb, 2017 - Permalink

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.

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

Article Comments

Search

Attention

Related Articles