SUMMARY: ProC Problems on TRU64 V5.1B-4 with Oracle 10GR2

All;

The University of Alaska is also in the process of upgrading our 
SunGard Banner databases to 10g so this post caught my attention. We 
were able to reproduce the behavior detailed in the original post 
below and subsequently opened SR# 6649583.993 with Oracle support. 
Oracle support was also able to reproduce the problem and has created 
bug #6726045 to address the issue in a future release. In the 
meantime, Oracle has provided the following information and work-around:

>The problem is specific to using bequeath connections. Either set 
>TWO_TASK to force a tcpip connection or add BEQUEATH_DETACH=YES in 
>the client side sqlnet.ora.

Both of these options do indeed resolve the problem and Oracle has 
stated that they will provide a fix in a future release.

The original post follws:

At 09:05 AM 12/21/2007, [email protected] wrote:
>Hello,
>
>We have encountered Pro C program problems on our TRU64 V5.1B-4 system
>with Oracle10GR2. We think the issue is related to the "Pro C".
>
>The basic problem is that when a "Pro C" program makes a system call
>the child process is lost. This means that the system call always
>returns a -1 with the error message "Child Process Not Found".
>
>This TRU64 machine has both Oracle9i and Oracle10GR2 databases on it.
>We are in the process of converting Oracle 9I to Oracle 10G.
>
>These same programs that fail in the Oracle 10G environment, work in
>the Oracle 9I environment.
>
>Any thoughts/ideas/experiences greatly appreciated.
>
>Thanks,
>
>Steve
>
>Stephen L. LaBelle
>Metropolitan State College of Denver
>Senior System Administrator
>Database Administration Team
>[email protected]
>303-556-3644


David J. DeWolfe
Manager, Technical Services
Office of Information Technology
University of Alaska Fairbanks
University of Alaska System
907 450-8317
mailto:[email protected]