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

Last updated on FEBRUARY 22, 2019

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 = <agent PID>
    Adapter PID = <adapter PID>
    Parent  PID = <parent PID>
...
Environment:
    AUTOSYS:                 <dir>/autosys/x.x
    AUTOUSER:               <dir>/autosys/config
    AUTORUN:                 9721111-6
    profile:                 /etc/auto.profile
    login:                   <login>
    uid=<uid>  euid=<euid>  gid=<gid>  egid=<egid>
...(3) adapter_getenv-> DEBUG: OAP_DUMPENV(d)=0
...(4) set_defaults-> DEBUG: server=<server>
...(5) adapter_getenv-> DEBUG: OAPDIR(e)=<DIR>/oap
...(6) set_defaults-> DEBUG: lookup password from configuration
...(7) adapter_get_auth-> DEBUG: configuration=<server>, user=<user>
Job:
    Server:                                <server>
    Oracle ID:                             <oracle ID>
    User Name:                             <user name>
    Responsibility Application Short Name: <responsibility short name>
    Responsibility Name:                   <responsibility name>
    Program Application Short Name:        <program app short name>
    Program Name:                          <program name>
    Display concurrent request log file?   NO
    Override Args List:   
...(8) adapter_getenv-> DEBUG: TNS_ADMIN(e)=<dir>/autosys/config
...(9) adapter_getenv-> DEBUG: ADAPTER_PUTENV(d)=-1
...(10) dial_erp-> DEBUG: connect( <apps user>/*****, <server> )
olog status = 28040
...(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         : <program ID>
    Application ID     : <application ID>
    User ID            : <user ID>
    Responsibility ID  : <responsibility ID>
Program <OKCARTSYNCCTX> found 0 flexfields

Job Request Id  : <req ID>
...(11) Program - Synchronize Clause Text Index of <req ID> has started!
...(12) Program - Synchronize Clause Text Index of <req ID> is Pending. Status: Standby
...(13) Program - Synchronize Clause Text Index of <req ID> is Completed. Status: Normal
...(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.
...(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

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