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; rob.di..
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)...
>
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
> > 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
http://exchange.nagios.org/directory
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"
To: "beginners" ; "dbi-users"
Cc: "newbie01 perl" ;
--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 writing
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 connecti