try to get text from error as follows...
Modify "$dbh = ..." line
remove "|| die ..." part.
after "$dbh = ..." line
add
if ( ! $dbh )
{
print "$mysqldatabase\n";
print "$mysqlhost\n";
print "$mysqlusername\n";
print "$mysqlpassword\n";
print "Can't connect: $DBI::errstr\n";
die;
}
My guess it that you have to build Perl first. Don't rely on a Perl
distribution that comes with OS or another package.
Get Perl source and start with making Perl.
make sure to use gcc compiler.
Then do install of DBI.
Then make sure you have Oracle client installed (I'm assuming you plan to
use
If you are on NT, try downloading the definitive pre-built Perl for NT:
ActivePerl
http://aspn.activestate.com/ASPN/Downloads/ActivePerl/
It may or may not already have DBI. I think it does, but if not, no
problem. Just use ppm (perl package manager) for installing DBI and
DBD::Oracle. The ...
Or the listener may not be running.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 10:45 AM
To: 'Juan Jose Natera Abreu '; ''[EMAIL PROTECTED] ' '
Subject: RE: Problems connecting to Oracle (ORA-01034: ORACLE not
availabl e)
Right. The d
Has anyone figured out how to call OCIPasswordChange from Perl (with or
without DBI)? The reason I'm asking that Oracle is saying that
OCIPasswordChange function should be used instead of 'alter user..' to
accomplish password changes. I'm hoping someone has figured out how to do
this using Perl.
More PRO arguments:
If "use strict;" is used (and I use it all the time), you get error
checking, which will save lots of debugging time. Of course, you get error
checking in PL/SQL but not much in shell scripts. It's easy to waste lots
of time trying to troubleshoot a typographical error in a
: Mickey Mestel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 12, 2001 2:39 PM
To: Molina, Gerardo
Cc: Dbi-Users@Perl. Org
Subject: Re: Oracle memory leak
derardo,
> This might be the same issue we ran into just this week.
>
> According to Oracle Support, this is Bug 1397603, which is su
Is there a way to specify a timeout parameter for a dbi->connect call? I
know TNS has a timeout limit, but is there a way to specify a timeout in the
connect call? This is so that the script doesn't have to wait forever for a
response from the connect call.
TIA,
Gerardo
