My Oracle Support Banner

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

Last updated on JANUARY 19, 2018

Applies to:

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


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.

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.