AutoSys Fails With "ERROR: connection error: 28040" After Upgrading An E-Business Suite RAC Enabled Database From 11g To 12c

Last updated on OCTOBER 29, 2015

Applies to:

Symptoms

After upgrading an EBS RAC-enabled database from 11g to 12c, AutoSys is unable to run jobs and fails with ORA-28040 connectivity errors.

AutoSys trace log shows the following:

UJMAOA Adapter Version 3.0.0
Adapter Library Version 2.0.0 (GA)
(C) 1996,2003 Computer Associates International, Inc.
    Remote Agent PID = 27449
    Adapter PID = 27459
    Parent  PID = 27453
...
Environment:
    AUTOSYS:                 /opt/autosys/x.x
    AUTOUSER:                /opt/autosys/config
    AUTORUN:                 9721111-6
    profile:                 /etc/auto.profile
    login:                   applprod
    uid=504  euid=504  gid=504  egid=504
UJMAOA(3) adapter_getenv-> DEBUG: OAP_DUMPENV(d)=0
UJMAOA(4) set_defaults-> DEBUG: server=PROD_BALANCE
UJMAOA(5) adapter_getenv-> DEBUG: OAPDIR(e)=/opt/autosys/UnicenterJMAOracleApps/oap
UJMAOA(6) set_defaults-> DEBUG: lookup password from configuration
UJMAOA(7) adapter_get_auth-> DEBUG: configuration=PROD_BALANCE, user=apps
Job:
    Server:                                PROD_BALANCE
    Oracle ID:                             apps
    User Name:                             PO_BATCH
    Responsibility Application Short Name: PO
    Responsibility Name:                   PO-NPP Batch_B2
    Program Application Short Name:        OKC
    Program Name:                          OKCARTSYNCCTX
    Display concurrent request log file?   NO
    Override Args List:   
UJMAOA(8) adapter_getenv-> DEBUG: TNS_ADMIN(e)=/opt/autosys/config
UJMAOA(9) adapter_getenv-> DEBUG: ADAPTER_PUTENV(d)=-1
UJMAOA(10) dial_erp-> DEBUG: connect( apps/*****, PROD_BALANCE )
olog status = 28040
UJMAOA(11) dial_erp-> ERROR: connection error: 28040                                       // NOTE:  Line represents a connection error eg.  "ORA-28040: No matching authentication protocol"

Instead of the following successful AutoSys run on an 11g database or a single node 12c database:

Program: OKC - OKCARTSYNCCTX
    Description        : Synchronize Clause Text Index
    Enabled Flag       : Y
    SRS Flag           : Y
    Exec Method        : PL/SQL Stored Procedure
    Argument Method    : Standard
    Program ID         : 44769
    Application ID     : 510
    User ID            : 1297
    Responsibility ID  : 51120
Program <OKCARTSYNCCTX> found 0 flexfields

Job Request Id  : 1859586
UJMAOA(11) Program - Synchronize Clause Text Index of 1859586 has started!
UJMAOA(12) Program - Synchronize Clause Text Index of 1859586 is Pending. Status: Standby
UJMAOA(13) Program - Synchronize Clause Text Index of 1859586 is Completed. Status: Normal
UJMAOA(14) watch-> DEBUG: Request completed with message: This request completed successfully. The request started at 13-JUN-2015 02:36:04 and ended on 13-JUN-2015 02:36:13.
UJMAOA(15) adapter-> DEBUG: exiting with status 0 at Sat Jun 13 02:36:14 2015

Changes

 The RAC-enabled EBS database had been upgraded from 11g to 12c.

Cause