On 28/07/2012 02:45, newbie01 perl wrote:
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
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.
I would use one of the many nagios/icinga plugins for doing so, start
here:
https://www.itefix.no/i2/check_oracle
use strict;
use DBI;
use DBD::Oracle qw(:ora_types);
my $user = '';
my $passwd = '';
my $tnsName = '';
$ENV{'ORACLE_HOME'} = 'C:\oracle\product\10.2.0\client_1';
my $dbh = DBI-connect(dbi:Oracle:$tnsName, $user, $passwd);
my $SQL = qq{ SELECT XXX};
my $sth0 = $dbh-prepare($SQL);
print SQL is
.
Date: Sat, 28 Jul 2012 13:45:18 +1200
Subject: Script to test connecting to Oracle DBs
From: newbie01.p...@gmail.com
To: beginn...@perl.org; dbi-users@perl.org
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
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
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