General
cancel
Showing results for 
Search instead for 
Did you mean: 

Check if oracle report/form server are running properly

Massimo Bianchi
Honored Contributor

Check if oracle report/form server are running properly

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
6 REPLIES
Sanjay Kumar Suri
Honored Contributor

Re: Check if oracle report/form server are running properly

Hello

Will CRON do the job for you.
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Volker Borowski
Honored Contributor

Re: Check if oracle report/form server are running properly

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
Exalted Contributor

Re: Check if oracle report/form server are running properly

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Check if oracle report/form server are running properly

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Massimo Bianchi
Honored Contributor

Re: Check if oracle report/form server are running properly

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
Honored Contributor

Re: Check if oracle report/form server are running properly

Closing....