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

How can I monitor text returned from a Oralce query?

Votes:

0

I have an oracle query that returns "OK" when a test is correct but I want to be able to display the text that is output if my query has an error. Is this possible?

oracle prtg query

Created on May 11, 2010 4:19:45 AM



3 Replies

Accepted Answer

Votes:

0

I'm afraid that isn't possible.

Created on May 11, 2010 10:46:47 AM by Patrick Hutter [Paessler Support] (7,225) ●3 ●3



Votes:

0

Hi, I'm facing a similar Problem right now. I want to monitor if a database instance is accessible so i thought i should query the instance_name from v$instance. But PRTG Shows me the value of the query is 0. How can I monitor that value. Or is there an other value that would make sense to monitor?

sry I'm a DB noob ...

Her is my SQL query.

select instance_name from v$instance

Created on Dec 14, 2012 10:19:10 AM



Votes:

0

Do you have the option "Process Text Result" turned on in the sensor settings?

Created on Dec 23, 2012 8:21:30 PM by Patrick Hutter [Paessler Support] (7,225) ●3 ●3




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.