This batch file will lessen your sqlplus login frustration at zenit server.

If you are in DBS501 like me, you must be frustrated with sqlplus command. Why did they remove the good old isqlplus and instead put sqlplus. The problem with the sqlplus for most of us is because of connection problem. If you haven’t modified the ora file to include host address for neptune, you must do that before proceeding any further. Here is the link https://cs.senecac.on.ca/~nconkic/db-oracle11g.html Now lets create a batch file that will log into oracle using sqlplus Here are the steps

1. Create a file login.bat
2. Type this cmd/k “sqlplus dbs501_xxxAxx/mypasswordhere@neptune”
3. Save the file

Warning: make sure you don’t name the batch file ‘sqlplus.bat’ otherwise it call itself, not the sqlplus program in an infinite loop. If you don’t put password, it will prompt you to enter password. I just put it there because sometimes it takes 5-10 times before you can actually log into the zenit oracle server, and I really don’t like to waste any more time on typing passwords ;). Now you can double click this file to open a cmd window which will log into zenit oracle server. If there is a connection problem, just close it and reopen it. You can even open multiple instances. For testing, I opened three instances and one of them worked. The other two spit some connection errors. Common errors are timeout occurred error, host not listening error etc.