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:
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]Information in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |