Re: Problem Connecting w Perl/DBD::Oracle as SYSDBA

J R Longwill <longwill_at_psmfc.org> wrote in message news:<bo9807$97a$1_at_nntp.psmfc.org>... <snip>
> The error I get when running this for database BB seems to be occuring
> in the DBI library, at the exact point of connection to the database.
> The error is:
>
> Uncaught exception from user code:
> DBI connect('bb','sys',...) failed: at ./bk3.pl line 80
> Carp::croak('DBI connect(\'bb\',\'sys\',...) failed: ') called
> at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 579
> DBI::__ANON__() called at
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 629
> DBI::connect('DBI', 'dbi:Oracle:bb', 'sys', 'pswd123',
> 'HASH(0x8335710)') called at ./bk3.pl line 80
>
> The main error seems to be line 579 of
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm but I can't be sure.

Have you used the DBI 'trace' method? This method captures the "conversation" between the script and the database. What you have above is, well, and indication of a problem, but not too much else. Plus, the above is really nothing more than a traceback. It's telling you the connection failed - which you already knew (nice that the script let's us know the obvious :-) ).

When ever I've had an issue like this, the 'trace' method _usually_ points out what's going on for me. OTOH, my experience with Oracle is _very_ limited. I installed a "starter" version (from some book I picked up about 2 years ago) on my Linux box, played around with it a little, then put it aside :-( Maybe someone else has other ideas.

HTH Jim
(jwillmore _at_ adelphia _dot_ net) Received on Tue Nov 04 2003 - 21:05:32 CST