Re: shell status checking

/* aficionado mode on */
Why does everyone expect Oracle is a clone of

0) Informix
0) SqlServer
0) Sybase

(Mark all that apply)
It's much more than that!
/* aficionado mode off */

You will search in vain.
You can use a
ps -ef | grep dbwr
if you want to continue using that shell script. However Oracle has Oracle Enterprise Manager, in which you can define events, which will e-mail and/or page the sysadmin out of his bed. To me using OEM looks like a better solution.

Hth,

Sybrand Bakker, Oracle DBA

"eric" <epriebeNOepSPAM_at_acus.com.invalid> wrote in message news:03b30c3e.296aec59_at_usw-ex0106-048.remarq.com...
> I'm new to oracle but have lots of experience to Informix.
> We've lots of ways to check the status of an Informix database with
> shell accessible tools like onstat and dbaccess, but I dont see
> them available in /oracle/bin or /oracle/rdbms/admin.
>
> Im looking for something relativley simple like:
> #!/bin/ksh
> while :
> do
> STAT=`onstat -`
> grep 'online' $STAT 1>/dev/null 2>&1
> if [ $? != 0 ]
> then
> echo "DB Down!!" | mailx sysadmin
> fi
> sleep 60
> done
>
> Thanks, Eric Priebe
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Aug 07 2000 - 00:00:00 CEST