Test multiple Oracle strings using a batch file and logging errors

Question

I have over 900 Oracle strings in the following format:

sqlplus (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=c)(PORT=a))(CONNECT_DATA=(SID=b)))

Can I create a batch file to test all 900 together using DOS? I do not want to test each manually. Getting the version will be helpful too. Appreciate your help.

Could you install cygwin? Should you use the cmmand prompt only? — 0xdb
– 0xdb, Commented Oct 4, 2016 at 20:22
By "DOS" you are actually talking about the Windows command prompt cmd, I guess... — aschipfl
– aschipfl, Commented Oct 4, 2016 at 20:30
There is no current Oracle client that runs on DOS. They all require at least Windows to run. So, no you can't do that in DOS - but you can do it in the Windows command line. — user330315
– user330315, Commented Oct 4, 2016 at 21:23

Community · Accepted Answer · 2017-05-23 11:48:29Z

0

You can read a file line by line (source) and use it as a argument like this:

for /f "tokens=*" %%a in (alias.txt) do call :processline %%a

:processline
tnsping %*
goto :eof

:eof

You might need to use the trick from Checking if the output is OK to check if connection is ok or not.

I would prefer tnsping over sqlplus, so you do not have to worry about username, password and actual command to execute.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Oct 4, 2016 at 20:20

eckes

10.5k1 gold badge66 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Test multiple Oracle strings using a batch file and logging errors

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related