Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to test oracle is up and running in remote machine using shell script

user4469127Jul 11 2010 — edited Jul 14 2010
Hello,

I need help to write an linux script.

I have a java application server running on machine 192.168.5.20 and our oracle 10g standard 1.0.2 is running on machine 192.168.5.21.
I have found script to start oracle when computer is turned on.

But I cannot start my application server automatically since it depends on whether oracle is up and running or not on the remote machine.

Therefore, in case of power failure or maintenance, our client has to call us to start application server.

I would be grateful if someone can help me "How can I write script to check oracle is up and running in machine 192.168.5.21 from machine 192.168.5.20.

For your information, I have no oracle installed in application server. So tnsping won't work.

What I want is when power is back, application server script automatically and tesing for oracle server is up and running. If it is up, script will start application server.

Thanking you.
This post has been answered by Dude! on Jul 13 2010
Jump to Answer

Comments

486600
Does anyone have any ideas on how to test an Apex application?

Thanks

Kevin
Ashish Dave-Oracle
it can be tested as normal web application.
what kind of test you used to varify failure? text matching test?
486600
I'm new to Oracle Testing Suite so im unsure of exactly how to get the desired results. If an ORA error message is displayed on the screen i want to make the page fail. So is there a way of making the test fail if certain text is present on the screen?

Secondly i want to create a script that recognises a change has happened to the application (such as a link takes the user to a different page than expected when the script was created) and fail.

Do you have any idea on how to achieve this

Thanks

Kevin
Ashish Dave-Oracle
text matching test will achieve first objective
text matching test or custom object test will be good for second one
486600
Thankyou

The text matching test has worked for the first problem. However i am unable to find a custom object test in the Tests Menu. How do i go about creating one of these?

Regards

Kevin
Ashish Dave-Oracle
Answer
"insert custom object test"
which version do you use?
Marked as Answer by 486600 · Sep 27 2020
486600
Thanks for your help. I have the desired results

Kevin
695716
Hi

I installed the oats850 version 2.11.15.0 and when tried to open the oracle load testing for web application it alerts the following error message in the Firefox browser.

'http://localhost:8088/olt/'

Thanks in advance, kindly suggest.

Regards
sathish

Edited by: user10993677 on Apr 15, 2009 4:59 AM
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 11 2010
Added on Jul 11 2010
12 comments
13,010 views