TNSPING in CMD script

[felipe]

Hi,
I want to create a install script for windows. I shoud be very simple if TNSPING go $SID works ok, then run
sqlplus /nolog @do_all.sql

I made some install sript for DB in unix system i look like this :
#!/bin/bash
NLS_LANG=AMERICAN_AMERICA.EE8MSWIN1250
export NLS_LANG

SID=$1

if tnsping $SID 2>&1 > /dev/null; then
sqlplus /nolog @do_all.sql
else
echo "$SID not up"
fi

But i don;t know is there an option i dos to check result of command like tnsping ?

[foxidrive]

You can replace the URL with an IP address.

Code: Select all

@echo off
set sid=www.google.com

ping %sid% >nul 
If not errorlevel 1 (
sqlplus /nolog @do_all.sql
) else (
echo "%sid% not up"
)
pause