RE: (Fwd) Bug in Oracle 11g2 with DBD::Oracle

I agree that the best solution is to use:
bequeath_detach = yes in the sqlnet.ora file. But I have two questions:

First, the default is no for the above variable and setting it to yes has reasons, what are these reasons?
Second, Is this issue known to Oracle as a bug and is there a plan to fix in the upcoming releases?

Thanks
Mahdi






> Date: Tue, 5 Mar 2013 13:08:31 +0000
> From: [email protected]
> To: [email protected]
> CC: [email protected]; [email protected]
> Subject: Re: (Fwd) Bug in Oracle 11g2 with DBD::Oracle
> 
> On 05/03/13 12:14, Charles Jardine wrote:
> > On 05/03/13 10:08, [email protected] wrote:
> >> ----- Forwarded message from Mahdi Sbeih <[email protected]> -----
> >>
> >> Date: Tue, 5 Mar 2013 00:45:26 -0800
> >> From: Mahdi Sbeih <[email protected]>
> >> To: "[email protected]" <[email protected]>
> >> Subject: Bug in Oracle 11g2 with DBD::Oracle
> >>
> >>     Dear Tim,
> >>
> >> Sorry for sending this email directly to you, but I am not an active
> >> member in Perl lists and forums and maybe you can direct this email
> >> to whom is responsible for the development of Perl DBD::Oracle
> >> module.
> >>
> >> I found a bug related to the ora_connect_with_default_signals
> >> feature.
> >>
> >> On our system RHEL5 Oracle11gR2, we had to use this feature on the
> >> child signal in order to avoid the "-1" return from the system call
> >> ora_connect_with_default_signals => ['CHLD']
> >
> > The best way to deal with the -1 return from system() is to add
> >
> > bequeath_detach = yes
> 
> Agreed.
> 
> > to your client-side sqlnet.ora file. If you do this you will not
> > need to use ora_connect_with_default_signals.
> >
> >> This caused a sever bug, if the Perl script is running in the
> >> background and doesn't exit, every time it connects to the oracle
> >> database server it will create a zombie process, and this will later
> >> crash the machine itself since it will consume all the processes on
> >> the machine.
> >
> > I think that ora_connect_with_default_signals is misguided.
> >
> 
> As it happens so do I when it comes to SIGCHLD. However, some Oracle client libraries also trap SIGINT and SIGQUIT where I have more of a problem.
> 
> Perhaps I'll find some time to update the pod.
> 
> Martin
> -- 
> Martin J. Evans
> Easysoft Limited
> http://www.easysoft.com