@echo off
setlocal
set oracle_home=E:\oracle\10.2.0
set path=E:\oracle\10.2.0\bin
set oracle_sid=ora10g
(
echo conn / as sysdba
echo set head off feed off pages 0
echo select status from v$instance;
) | sqlplus -s /nolog > %TEMP%\status.log

for /f "tokens=3" %%i in ('%SystemRoot%\system32\find /c "OPEN" %TEMP%\status.log') do (
if %%i == 1 (
echo Database is OPEN
) ELSE (
echo Databse does NOT appear to be OPEN
))

for /f "tokens=4" %%i in ('%SystemRoot%\system32\sc query oracleserviceora10g ^| 
	%SystemRoot%\system32\find "STATE"') do echo The Oracle service is %%i
endlocal