check if oracle aviable

لقد وجدت هذا الباتش بإحدى المواقع فارجو تجريبة
notepad -file -save as - name.bat



@echo off
rem -----------------------------------------------------------------------
rem Filename: dbup.bat
rem Purpose: Check if database is up and running
rem Notes: When using Oracle releases prior to 8i, replace "sqlplus" with
rem "plusXX" in the script below. XX is the version number, eg. 73
rem or 80. This is needed as sqlplus (in these releases) will start
rem a new window and the return code will be lost. With Oracle 8i
rem sqlplus executes in the same window as the rest of the script.
rem Date: 05-Mar-2002
rem Author: Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

rem -- Set Database SID ---
set ORACLE_SID=KH

rem -- Create SQL Script ---
echo sqlplus/nolog
echo connect sys/sys@data as sysdba; > %0.tmp
echo set echo off feed off pages 0 >> %0.tmp
echo whenever sqlerror exit sql.sqlcode >> %0.tmp
echo select * from global_name; >> %0.tmp
echo exit; >> %0.tmp

rem -- Test connect to database ---
rem --sqlplus /nolog @%0.tmp >NUL:

if {%ERRORLEVEL%} == {0} (
echo Database %ORACLE_SID% is available
) else (
echo Database %ORACLE_SID% is NOT available
)

rem -- Cleanup --
del %0.tmp

والسلام
selman0