Does inactivity of a database handle causes it to get disconnected ??

mailarunpandey_at_gmail.com
Date: 12/22/04

  • Next message: Dave Rolsky: "ANNOUNCE: Alzabo 0.86" 
    Date: 22 Dec 2004 09:08:18 -0800

    Hi guys,
    I am not very sure whether i should post it in an Oracle group or here
    . Please excuse me for that !!
    here goes the issue.
    I have a perl script which creates 2 database handles (oracle)
    connecting to separate database instances . The first database handle
    does quite some work (say about 30 seconds) before the second database
    handle is first used. At this point i get the dreaded error :
    ORA-03113: end-of-file on communication channel (DBD ERROR:
    OCIStmtExecute/Describe)

    the script might something like

    my $dbh1 = DBI->Connect (....)
    my $dbh2 = DBI->Connect (....)

    ...........
    ...........
    processing on $dbh1
    ............
    ...........

    $dbh2->prepare(...) <-------- this is where i get the error

    now my query is :-

    what exactly could be the reason behind this ?.. The inactivity of
    $dbh2 causes DBI to close it or is the oracle server is smart enough
    to disconnect an idle session or something else ??
    Please Advise

    Thanks in advance!!

    Arun

  • Next message: Dave Rolsky: "ANNOUNCE: Alzabo 0.86"

    Relevant Pages

    • Re: What so special about PostgreSQL and other RDBMS?
      ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
      (comp.lang.php)
    • A cool DBA job wanted
      ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
      (comp.databases.oracle.server)
    • Re: I want to add to myknowledge
      ... 7, Oracle 6, Sybase, SQL Server ... Oracle Database Administrator ... Trained installation and support personnel in basic ... Senior Oracle Database Administrator ...
      (comp.databases.oracle.server)
    • Re: choices regarding where to place code - in the database or middle tier
      ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
      (comp.lang.java.programmer)
    • Re: choices regarding where to place code - in the database or middle tier
      ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
      (comp.lang.java.databases)