Re: Host command fails if there is a database connection

The Oracle OCI libraries muck around with SIGCHILD which will affect running child processes (which you are when you run sqlplus like that). If you absolutely need to do what you are doing I think you need to reset SIGCHILD back to its default behavior.

Update: I believe you can stop the oracle libraries doing this by adding BEQUEATH_DETACH=YES to your sqlnet.ora file but I'm not sure of the other affects.

Comment on Re: Host command fails if there is a database connection

Replies are listed 'Best First'.
Re^2: Host command fails if there is a database connection by astroboy (Chaplain) on Nov 22, 2009 at 20:23 UTC
Thanks for your reply. setting or unsetting BEQUEATH_DETACH had no effect for me, but going via a dedicated server process worked for me - thanks for putting me on the right track!	[reply]