Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: nt script

RE: nt script

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Tue, 01 Jul 2003 09:31:55 -0700
Message-ID: <F001.005BCFC8.20030701090452@fatcity.com>


echo off
@cls
find "ORA-124" C:\yourlog.txt >NUL

IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes

:no
ECHO NOT FOUND
goto end

:yes
 ECHO String IS found
pause
goto end

:end
exit

>
> Hi listers,
>
> I am working on a nt script. I download FORFILE exe, it works
> fine. My intention is finding the ORA-03113 string in the
> log. If there is a match, then reboot the server, else do
> nothing. I don't have problem with the findstr part. However,
> the errorlevel always return 0, no matter it find the error
> or not. So the if statement is not working. Can somebody give
> me some light on NT syntax? On unix, it is so easy to script
> the condition. Please help,
>
> Thanks,
>
> Joan
>
>
> FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> -d+0 -c"CMD /c type
> d:[EMAIL PROTECTED]|findstr ORA-03113"
> if errorlevel 1 goto run_proc echo 'there is a match'
>
> if errorlevel 0 goto end
> echo 'there is no match'
>
> :run_proc
> d:\start_proc.bat
> goto end
>
> :end
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 01 2003 - 11:31:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US