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: martin.ev...@easysoft.com > To: c...@cam.ac.uk > CC: mahdi_sb...@hotmail.com; dbi-users@perl.org > 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, tim.bu...@pobox.com wrote: > >> ----- Forwarded message from Mahdi Sbeih <mahdi_sb...@hotmail.com> ----- > >> > >> Date: Tue, 5 Mar 2013 00:45:26 -0800 > >> From: Mahdi Sbeih <mahdi_sb...@hotmail.com> > >> To: "tim.bu...@pobox.com" <tim.bu...@pobox.com> > >> 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
