Check if oracle report/form server are running properly

[Massimo Bianchi]

Hi all,
one of my customer wants to check daily if the form and report server are working properly.

We already have ITO to check for the existance of

tnslsnr
oracleSID
ora_
f60srvm
rwmts60
httpd
Xvnc

Now, the problem is that sometimes they hung, even if they are active.

The customer gave us a test page on http, that start a java applet with the JIniziator 1.1.8.16.

We have ias1.0.2, oracle 8.1.7

how can this check be done automatically ?

Thanks !
Massimo

[Sanjay Kumar Suri]

Hello

Will CRON do the job for you.

[Volker Borowski]

Hi,
sounds like a perl-job to me.
Just did a short ride on google:

This one might be too simple
http://www.webreference.com/perl/tutorial/6/

This one sounds better
http://www.robzazueta.com/resume/code/sitechecker.php

Did not dig too deep into it, but I am sure the soulution is out there. We use Nagios to monitor sites (tons of modules includable).
http://www.nagios.org/

Hope this helps
Volker

[Steven E. Protter]

An off beat approach:

1)forms=$(ps -ef | grep f60 | wc -l)

check the count on that variablbe for the forms server

Similar for rw to track down that the run time of the reports server is running.

Something similar can be done with oracle, plus you can use scripted sqlplus to ascertain database status.

As to the status of the process, thats a little harder, because hangs are tough to pick up.

The best thing you can do is build a display form in the motif version of forms and a display report in the motif version of reports. Include no data connections because that will require a login.

Then you can run it to a file with the f60gen and reports equivalment.

I have a command line at work which I will get and post Monday. Then you run the compiled forms direct the output to a file. The return code $? will be 0 for success and 1 for failure in a hung situation. You pick up that code and take appropriate action to restart the servers.

Do you need a full blown script from me?

SEP

[Yogeeraj_1]

hi massimo,

we use the following command (in a script+cron) to check if our reports server is running:

$ORACLE_IASHOME/bin/rwrqv60 server=repserver

hope this helps too!

regards
Yogeeraj

[Massimo Bianchi]

Hi,
thank you to all for the replies.


unfortunatly the customer asked me a solution (that i didn't have) so he arranged to have one of his person to do daily check.

All of your ideas looks good, but i had only a hpux server to run the checks, and the jinitiator only runs on windows...


Thankyou anyway, and please consider this thread as closed.

Massimo

[Massimo Bianchi]

Closing....