Re: Is database up

NO - tnsping will not tell you if the database is up, it only checks that sqlnet connectivity is ok, i.e the listener is up and running and listening for the entries specified in the tnsnames.ora file the database could be down, but you would still get a successful return from tnsping if sqlnet is ok

NeilC

dalalbm_at_my-deja.com wrote in message <7ul89i$moa$1_at_nnrp1.deja.com>...
>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 Thu Oct 21 1999 - 03:05:32 CDT