Re: DBD::Oracle debugging

From: Reinhard Pagitsch (reinhard.pagitsch_at_isis-papyrus.com)
Date: 07/26/04


To: dbi-users@perl.org
Date: Mon, 26 Jul 2004 09:26:19 +0200

Mark Nettlingham wrote:

>Hi all,
>
>I was wondering if there's a way of enabling DBI's internal debugging?
>
>Essentially, I'm getting a fail when connecting to an Oracle Database, but
>no $DBI::err, or $DBI::errstr is being produced - both are null. This is
>especially frustrating as it only happens on one of two mirrored databases.
>It also occurs when I attempt to connect to a nonexistant server.
>
>I just want to see how far DBI gets before it fails - is it getting to the
>TNS info? If so, can it connect?
>
>TIA
>Mark
>
>
>
Hello Mark,

$trace_level = 9; # e.g.
Did you set: DBI->trace($trace_level);

Maybe it would help if you post the error message.

mit freundlichen Grüßen,
with my best regards,
Reinhard

-- 
QA
ISIS Information Systems
Austria tel: (+43) 2236 27551 150  Fax: 2236 21081
Visit our web site http://www.isis-papyrus.com


Relevant Pages

  • DBD::Oracle debugging
    ... I was wondering if there's a way of enabling DBI's internal debugging? ... Essentially, I'm getting a fail when connecting to an Oracle Database, but ...
    (perl.dbi.users)
  • Re: Boot warning
    ... It may not fail for long time or it might ... If you are connecting other devices to your hard drivelike fans, ... >> It is a SMART error, warning you that your hard is failing. ... Continuing the boot so far has not resulted in any problems. ...
    (microsoft.public.windowsxp.general)
  • RE: Connecting to more than one oracle database
    ... In order to connect to an oracle database on a different machine ... I am currently connecting to an oracle database on a different ... CONFIDENTIALITY NOTICE This e-mail and any files or attachments may contain confidential and privileged information. ...
    (perl.dbi.users)
  • Re: oracle jdbc abd OpenOffice 2.0
    ... in the course of finding out how to connect an Oracle database ... Error while connecting to data source ... error code 17002 ... Server URL: localhost ...
    (comp.databases.oracle.server)
  • Intermittend ORA-12519, TNS:no appropriate service handler found
    ... connecting via JDBC we get intermittend ORA-12519 (reflected as TNS-12519 ... wise and memory wise). ... job scheduling to check whether there might be a job that eats up ... Oracle Database 10g Enterprise Edition ...
    (comp.databases.oracle.server)