type tnsnames.ora | find "description" > temp1.tmp
for /f "tokens=1" %%i in (temp1.tmp) do (
echo ********************************** begin check %%i ********************************** >> %result_file%
tnsping %%i > temp2.tmp
if errorlevel 1 set tns_name=%%i && goto fail
sqlplus -s %usr%/%pwd%@%%i @%sql_file% >> %result_file%
echo %%i checked successful!
:fail
echo %tns_name%checked failful!
)
一旦其中一条有误，后面的就无法进行了，请问如何解决？

未知，for 内goto 老是这样，我改为 && || 这样写了

没看懂，那处出错

改成这样就可以了

type tnsnames.ora | find "description" > temp.tmp
for /f "tokens=1" %%i in (temp.tmp) do (
echo ********************************** begin check %%i ********************************** >> %result_file%
tnsping %%i > nul
if errorlevel 1 (echo %%i tnsping failing! && echo tnsping failing! >> %result_file%) else (
sqlplus -s %usr%/%pwd%@%%i @%sql_file% >> %result_file%
if errorlevel 1 (echo %%i sqlplus failing! && echo sqlplus failing! >> %result_file%) else (
echo %%i checked successful!
)
)
)