I'm not a UNIX expert so I don't know about doing it remotely
but on the same machine you can use ps -aef|grep abc
where abc is the Oracle SID. If I expect only the standard
processes to be present I can check for the number of lines
returned from the grep.
Becca
> I'm trying to write a unix script to be run under cron that
needs to
> determine if a database instance is up on a remote box. This
will run under
> the oracle user with no root privs and rsh, rlogin, etc. is
not available.
>
> So far the only way I've determined how to do this is to try
and log into
> the remote database via "sqlplus user/pass_at_servicename, and
then pipe the
> output to grep looking for oracle error ORA 01034 "Oracle not
available".
>
> Any one have a better, cleaner solution?
>
> Thanks in Advance
>
> --
> Jim Gregory
> Principal Consultant for Keane, Inc.
> Currently assigned to NCR
> "Opinions are my own and do not reflect
> those of Keane or my clients"
>
>
> begin 666 Jim Gregory.vcf
> M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..D=R96=O<GD[2FEM#0I&3CI*
> M:6T_at_1W)E9V]R>0T*14U!24P[4%)%1CM)3E1%4DY%5#IJ:6TN9W)E9V]R>4!N
> I8W(N8V]M#0I2158Z,3DY.3$P,C!4,3,P,S(X6_at_T*14Y$.E9#05)$#0H`
> `
> end
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6331&cus_id=USENET&qtn_id=6324
Received on Mon Oct 25 1999 - 21:00:21 CDT
