RP/TUX 9.1 - [ATMI] Conversational server hangs forever when using Oracle embedded SQL without XA (Doc ID 778192.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Tuxedo / Tuxedo / 9,1
Information in this document applies to any platform

Goal

DESCRIPTION:
Customer migrates from Tuxedo 8.1 and Oracle 9 to Tuxedo 9.1 and Oracle 10g on AIX 5.2 to AIX 5.3. The customer uses
embedded SQL inside their servers without XA support. This means that they open a SQL connection in tpsvrinit() using
'EXEC SQL CONNECT :username IDENTIFIED BY :password;' directly without Tuxedo functionality. This worked well under
Tuxedo 8.1 and works well under Tuxedo 9.1 as well as long as the conversational server is configured with MIN=MAX=1.
If you configure for example MIN=1 MAX=3, you can see that one server hangs forever and the service function from the
server is never entered.

CONFIGURATION:
AIX 5.3, Tuxedo 9.1 RP092+RP087, Oracle 10.2.0
AIX 5.3, Tuxedo 8.1 RP280, Oracle 10.2.0

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms