Re: Is Database Up?

In message <spd6f2dt8rdv92otok0lti4cp9oriap2kf_at_4ax.com>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> writes
>On 28 Aug 2006 10:48:59 -0700, "amerar_at_iwc.net" <amerar_at_iwc.net>
>wrote:
>
>>
>>Radoulov, Dimitre wrote:
>>> > I want to write a Unix shell script that will check to see if a
>>> > database, on a remote machine, is up. Is this possible without writing
>>> > some long telnet routine or something?
>>> >
>>> > I was hoping for some simple command that I can grep for some string to
>>> > tell me the status of the remote database........
>>>
>>> No need to grep:
>>>
>>> printf "%s\n%s\n" "whenever sqlerror exit failure" "select null from
>>> dual;"|sqlplus -L user/pass_at_service_name >/dev/null 2>&1||echo "Database NOT
>>> accessible\!"
>>>
>>>
>>> Regards
>>> Dimitre
>>
>>Very slick.....I like that..........
>
>Please read the posts of Brian Peasland and Ed Stevens and stop
>building your own OEM.
>

Without the OP explaining why he wants to do this, is OEM always a valid solution ? If the requirement is for a script (called perhaps from cron) to check to see if the database is up before trying an operation against it, would this not be a valid reason for not using OEM ?

Adrian

-- 
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.