Last updated on OCTOBER 29, 2015
Applies to:
Oracle Applications 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 = 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
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