Script to test connecting to Oracle DBs

2012-07-27 Thread newbie01 perl
Hi all, I am looking for a Perl script or something similar that I can use to test connection from a client PC to several databases on a server. Does anyone know of any such script lying around somewhere :(- Currently, am testing connection from a client PC to an Oracle DB using Oracle's

Re: Script to test connecting to Oracle DBs

2012-07-27 Thread John D Groenveld
In message camnmhccsuwb1cy3rumce5zrx635hms6xnjxuvv6wvjz9hep...@mail.gmail.com , newbie01 perl writes: test connection to the Oracle DB and run a simple SQL like SELECT COUNT(1) from USER_TABLES, if I get an error, that means there is an issue I would try the DBI connect and ping methods with