@echo off
rem -----------------------------------------------------------------------
rem Filename:   DBStop.bat
rem Purpose:    Stop an Oracle database
rem Date:       05-Mar-2002
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

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

rem  -- Create SQL Script to Shutdown the DB --
echo set echo on                  > %0.tmp
echo connect sys/orcl as sysdba; >> %0.tmp
echo shutdown immediate;         >> %0.tmp
echo exit;                       >> %0.tmp

rem -- Do the Shutdown --
sqlplus /nolog @%0.tmp

rem -- Cleanup -- 
del %0.tmp