DBD::Oracle and CHLD Signal Handler

From: Peter Marksteiner (Peter.Marksteiner_at_univie.ac.at)
Date: 01/25/05


Date: Tue, 25 Jan 2005 15:51:40 +0100
To: dbi-users@perl.org

I have a strange problem when connecting to an Oracle 10 database:

#!/usr/bin/perl

use strict;
use warnings;
use DBI;

my $rc = system "true";
print "Before: $rc\n";

my $dbh = DBI->connect("dbi:Oracle:", "scott", "tiger");

$rc = system "true";
print "After: $rc\n";

$SIG{CHLD} = 'DEFAULT';

$rc = system "true";
print "Default: $rc\n";

   gives the following result:

Before: 0
After: -1
Default: 0

In other words, connecting to the database meddles with the CHLD signal
handler in such a way that it looks as if all subsequent calls to
system() failed.

This is perl 5.8.6 on an AIX 5.2 system (64bit) with DBI 1.46 and
DBD::Oracle 1.16; the Oracle version is 10.1.0.2.0. I never had this
problem with Oracle Versions 8 and 9.

   Any ideas?
   Peter

-- 
Peter Marksteiner 
Vienna University Computer Center


Relevant Pages

  • RE: Problem with connecting to an Oracle database using Perl
    ... Problem with connecting to an Oracle database using Perl ... *IS* described in the DBD::Oracle perldocs - as the perldocs are included ... I do not have a problem connecting to the remote database using the Oracle ...
    (perl.dbi.users)
  • Re: Slow connection to Oracle 9i
    ... If your server is memory and/or CPU ... I just tested it on two oracle instances on identical ... Connecting to one with MTS took 0.059 seconds, ... Other delays could be in finding the database and authenticating the ...
    (perl.dbi.users)
  • Re: pooled connection using tclhttpd
    ... >> I am using TCLHTTPD as the web server for hosting my applications. ... >> connecting with the oracle database. ... I doubt that oratcl supports async communication with oracle ...
    (comp.lang.tcl)
  • Re: Date / Time a table changed
    ... We are connecting to an Oracle 9i Database, is it possible to query a ...
    (comp.databases.oracle.misc)
  • Re: Oracle RAC connection
    ... Connecting to rac is the same as connecting to any normal oracle database. ... With the tnsnames.ora file for a rac database, you can specify if the alias is to connect to specific node or use the service and allow for the listener to connect you to a random node. ...
    (perl.dbi.users)