Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is database up
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
Received on Wed Oct 20 1999 - 08:03:28 CDT