how to check up/down status of oracle reports server?

oracle status oraclereports
ssr532 picture ssr532 · Jul 14, 2010 · Viewed 12.6k times · Source

To check the status of database servers, I use tnsping utility. Is there any similar utility for checking reports server? Thanks.

Answer

Jim Hudson picture Jim Hudson · Jul 14, 2010

Without access to the ReportServer admin console, that can be tough. But a call to /reports/rwservlet/showjobs?server= might do the trick for you. If you get a response, it confirms the server is up and running, and it'll show you any jobs that are running.

I've also implemented a procedure in the past that periodically runs a minimal report using utl_http and looks for a reasonable response. Then emails if it timesout or gets an HTTP error or report server error.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More