Re: Is database up

In article <380dbe7e_at_rpc1285.daytonoh.ncr.com>,   "Jim Gregory" <JG200024_at_NCR.com> wrote:
> 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
>
>

Cleaner way would be using tnsping. It's meant for that.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 15:22:26 CDT