@echo off
echo script to test connectivity
echo %~dp0
set user=ABSSOLUTE
set pw=tuKSzrLRUHG
rem set db=ABST
set db=ABS1
set path=%~dp0;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;
set log=%~dp0log\testlog.log
echo %path%
set ORACLE_HOME=%~dp0
set TNS_ADMIN=%~dp0network\admin
echo ========================%date% date time %time% >>%log%
echo SQL Login to database %db% >> %log%
cd %~dp0log
%~dp0sqlplus %user%/%pw%@%db% @%~dp0sql\scan2.sql
%~dp0sqlplus %user%/%pw%@%db% @%~dp0sql\scan3.sql
echo ping ABS01-RENTEX.floronet.local from computer %computername% >>%log% 
ping ABS01-RENTEX.floronet.local >> %log%
rem ---- ABST ----- 
set pw=vRzefdJLF5M
set db=ABST

%~dp0sqlplus %user%/%pw%@%db% @%~dp0sql\scan2.sql
%~dp0sqlplus %user%/%pw%@%db% @%~dp0sql\scan3.sql
echo ping ABS02-RENTEX.floronet.local from computer %computername% >>%log%
ping -n 1 -a ABS02-RENTEX.floronet.local >>%log%
cd ..
echo =======================>>%log%
notepad %log%