Hey, We are implementing eBusiness Suite (Oracle Financials) and I need a good GET string to check that our web servers are working correctly. I am not keen on a standard GET /. Does anyone have any suggestions on a URL which doesn't include dynamically generated strings etc?

If you don't find anything better, you might try a request to see if the login page for the application returns a 200. You can check what request a browser sends for this URI using a header logging addon like HttpFox for Firefox or Fiddler for IE.

Aaron

I'm going to assume you are talking about EBS version 12.x.  The default login page for EBS is usually in the format of  http://host.domain:port/OA_HTML/AppsLogin.html.  If you have configured the Web tier for an "external HTTP load balancer" , like Big-IP, using the Apps Manager Wizard, then this would change, removing the :port ( assuming you set the Web Entry Point to port 80).  If you chose to use SSL offload on the Big-IP, then the protocol would change to https://host.domain/OA_AppsLogin.html, and you would need to change the monitor from http to https, so the Big-IP would make the SSL monitor connection to the Web pool members.

In any case, this will usually send you back an http 302 redirect, to either the SSO url ( if configured), or to a new Login URL, with your sessionID attached.  This will display the main EBS logon screen with the empty userid and password boxes.  This is probably good enough for basic monitoring, as this will let you know that a session was able to be created with the Web tier.  I am unsure if this first logon page makes a backend database call, an EBS expert would need to tell you for sure.  When I have tried this in the lab, if the database is not running, the login page returns an http 500, so I'm pretty sure the database must be up and running for the logon page to be rendered properly.

Hope this helps.  Please let us know what you find, and share back with us.

-Chris.

Hey,

As Chris said if you GET the login page you receive a 302. I had to get something implemented pretty quickly (before any of your responses) so I used

 /OA_HTML/RF.jsp?function_id=28804&resp_id=-1&resp_appl_id=-1&security_group_id=0〈_code=US¶ms= 

If the database is not up the login page doesn't display. I also got the F5 to check for a text file in Apache so that the server guys could do their own changes without requiring us manually bring nodes down on the F5s.

I was speaking to someone in Oracle today and they were happy for me to use the above URL. The only caveat is that schema change may kill it, however we have test environments so this will be picked up early. I was also told that in other deployments they have actually logged into the EBS portal as just checking the login page does not fully guarantee that the app is up.

Here is the URL suggested for auto login:

/OA_HTML/fndvald.jsp?username=sysadmin&password=sysadmin_password

Thanks for all your responses.

Cheers,

kreggz