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
--Beyond some training, I'm very much a newbie to Perl (and this list). So,
please indulge me with my first attempt at a posted question to you; please see
below (*with the full code Perl script toward the bottom of my email)...
-I've been dealing with an issue in a Perl script that I'm
Hi,
I've seen:
$connString = 'dbi:Oracle:SID'
Maybe it helps to add the SID like:
$connString = 'dbi:Oracle:SID=SID_NAME'
where SID_NAME is the SID you want to use...
--Octavian
- Original Message -
From: Warren James - jawarr james.war...@acxiom.com
To: beginners
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
On Jul 31, 2012, at 5:54 PM, Warren James - jawarr wrote:
--Beyond some training, I'm very much a newbie to Perl (and this list). So,
please indulge me with my first attempt at a posted question to you; please
see below (*with the full code Perl script toward the bottom of my email)...
have a look at
http://search.cpan.org/~pythian/DBD-Oracle-1.46/lib/DBD/Oracle/Troubleshooting.pm
it should answer most of your questions
From: james.war...@acxiom.com
To: beginn...@perl.org; dbi-users@perl.org
CC: newbie01.p...@gmail.com;
