New Question

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

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

Your Vote:

Up

Down

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 by John Kerr (55) ●1 ●1



3 Replies

Accepted Answer

Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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 by Thomas Dorn (0)



Votes:

0

Your Vote:

Up

Down

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



Please log in or register to enter your reply.


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.