Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to test if Oracle is up or down???
william.timm_at_sap-ag.de wrote in message
<356474ec.13380700_at_news.sap-ag.de>...
>How can I test if Oracle is up? We are writing a NT batch script for
>some administrative tasks and we first need to check wether Oracle is
>up or down, can this be done in a NT batch script, anyone out there
>doing somthing simular.
Quickly wrote one and tested it. It seems to work OK on NT4. Please feel free to change it to suite your needs.
regards,
Billy
begin 666 Dbstatus.cmd
M0&5C:&\@;V9F#0IR96T@(R!$0E-405154R!V,2XP#0IR96T@(R!7<FET=&5N
M(&)Y($)I;&QY(%9E<G)E>6YN90T*<F5M(",@92UM86EL.B!V<VQA8G- ;VYW
M92YC;RYZ80T*#0IR96T@(R!38W)I<'0_at_8V%N(&)E(&5X=&5N9&5D('1O(&1O
M(&%D9&ET:6]N86P_at_8VAE8VMI;F<L('-U8V@@87,-"G)E;2 C('5S:6YG('1N M<W!I;F<@=&\@8VAE8VL@=&AE(&QI<W1E;F5R(&%N9"!S;R!O;B!I;B!O<F1E M<B!T;PT*<F5M(",@<F5T=7)N(&%N(&5X86-T(&1I86=N;W-E(&%S('1O('=H M>2!T:&4_at_9&%T86)A<V4@:7,@;F]T(&%V86EL86)L92X-"G)E;2 C(%)E87-OM;B!W:'D_at_86X@86-T=6%L(&-L:65N="US97)V97(@8V]N;F5C=&EO;B!I<R!D
M;VYE("T@:70G<R!T:&4@+6]N;'DM#0IR96T@(R!R96QI86)L92!M971H;V0@ M=&\@8VAE8VL@:68@=&AE(&1A=&%B87-E(&ES(&%V86EL86)L92P@;6]U;G1E M9"P_at_971C+B!E=&,N#0H-"FEF("(E,2(@/3T@(BUH(B!G;W1O(#I(14Q0#0IIM9B B)3$B(#T]("(O/R(@9V]T;R Z2$5,4 T*:68@(B4Q(B ]/2 B+3\B(&=O M=&\@.DA%3% -"FEF("(E,R(@/3T@(B(@("!G;W1O(#I%4E)/4_at_T*9V]T;R Z M4%)/0T534PT*#0HZ15)23U(-"F5C:&\N26YV86QI9"!N=6UB97(@;V8@<&%R M86UE=&5R<R!S<&5C:69I960N(%1Y<&4@)R4P("UH)R!F;W(@:&5L<"X-"F=O M=&\@.D5.1 T*#0HZ2$5,4 T*96-H;RYU<V%G93H@)3 @9&)A;&EA<R!U<V5R
M('!A<W-W;W)D#0IE8VAO+B @9&)A;&EA<R @+2!43E,@86QI87,@;V8@=&AE M(&1A8F%S92 H<V5E(%1.4TY!3453+D]202!F:6QE*0T*96-H;RX@('5S97(@ M(" @("T_at_5D%,240H(2D_at_3W)A8VQE('5S97)N86UE( T*96-H;RX@('!A<W-W M;W)D("T_at_5D%,240H(2D_at_4&%S<W=O<F0_at_9F]R('1H92!/<F%C;&4@=7-E<FYAM;64-"F5C:&\N#0IE8VAO+E1H:7,@<V-R:7!T('=I;&P_at_8W)E871E(&%N(&5N M=FER;VYM96YT('9A<FEA8FQE('=I=&@@=&AE(&YA;64-"F5C:&\N;V8@=&AE
M(&1A=&%B87-E(&%L:6%S(&%N9"!S970@:70@=&\@96ET:&5R(%50(&]R($1/ M5TX@=&\@:6YD:6-A=&4-"F5C:&\N=VAE=&AE<B!O<B!N;W0@=&AE(&1A=&%B M87-E(&ES(&]P96X@;W(@<VAU=&1O=VXN($YO=&4@=&AA="!I9B!I;G9A;&EDM#0IE8VAO+G5S97)I9"!A;F0O;W(@<&%S<W=O<F0@:7,O87)E('-P96-I9FEE M9"P@=&AI<R!S8W)I<'0@=VEL;"!S:&]W('1H90T*96-H;RYD871A8F%S92!A M<R!$3U=.+@T*96-H;RX-"F5C:&\N17AA;7!L93H-"F5C:&\N0T%,3" E,"!0
M4D]$(&=U97-T(&=U97-T#0IE8VAO+D$@=F%R:6%B;&4@=VET:"!T:&4@;F%M M92!04D]$('=I;&P_at_8F4@8W)E871E9"X_at_270@=VEL;"!E:71H97(@8V]N=&%I M;@T*96-H;RYT:&4@=F%L=64_at_55 @;W(@1$]73B!D97!E;F1I;F<@;VX@=&AEM('-T871U<R!O9B!T:&4_at_9&%T86)A<V4N#0IG;W1O(#I%3D0-"@T*#0HZ4%)/ M0T534PT*<F5M("HJ(&1E;&5T92!T:&4_at_96YV:7)O;FUE;G1A;"!V87)I86)L
M92!I9B!I="!E>&ES=',-"G-E=" E,3T-"G)E;2 J*B!C<F5A=&4_at_82!T97-T M('-Q;"!S8W)I<'0-"F5C:&\N0T].3D5#5" E,B\E,T E,2 @(" @(" @(" @ M(" @(" @(" @/B @)51%35 E7"4Q+G-Q; T*96-H;RY314Q%0U0@<WES9&%T M92!&4D]-(&1U86P[(" @(" @(" @(" ^/B E5$5-4"5<)3$N<W%L#0IE8VAOM+D58250@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(#X^("5414U0 M)5PE,2YS<6P-"G)E;2 J*B!R=6X@=&AE('-C<FEP="!V:6$@4V5R=F5R($UA M;F%G97(-"G-V<FUG<C(S($ E5$5-4"5<)3$N<W%L(#X@)51%35 E7"4Q+F]U
M= T*9&5L("5414U0)5PE,2YS<6P-"G)E;2 J*B!C:&5C:R!T:&4@<V-R:7!T M(&]U='!U=" M(&EF(&ET(&-O;G1A:6YS('1H92!T97AT#0IR96T@*BH@(C$@ M<F]W('-E;&5C=&5D(B!I="!M96%N<R!T:&%T('1H92!S8W)I<'0@=V]R:V5DM(&%N9 T*<F5M("HJ('1H870@=&AE(&1A=&%B87-E(&ES('5P#0IT>7!E("54 M14U0)5PE,2YO=70@?"!F:6YD("]I("(Q(')O=R!S96QE8W1E9"(@/B!N=6QL M#0IR96T@*BH_at_8V]U;&0@;F]T(&9I;F0@=&AE('-E87)C:"!S=')I;F<@+2!T M:&4_at_9&%T86)A<V4@:7,@9&]W;@T*:68@)65R<F]R;&5V96PE(#T](#$@9V]T M;R Z1$]73_at_T*9V]T;R Z55 -"@T*#0HZ55 -"G)E;2 J*B!T:&4_at_9&%T86)A M<V4@:7,@=7 @)B!R=6YN:6YG#0IS970@)3$]55 -"F=O=&\@.D5.1 T*#0H- M"CI$3U=.#0IR96T@*BH@=&AE(&1A=&%B87-E(&ES(&1O=VX-"G-E=" E,3U$ M3U=.#0IG;W1O(#I%3D0-"@T*#0HZ14Y$#0IR96T@*BH_at_9&5L971E('1H92!T M96UP(&]U='!U="!F:6QE(&EF(&-R96%T960-"FEF(&5X:7-T("5414U0)5PE 9,2YO=70_at_9&5L("5414U0)5PE,2YO=70-"@``