Problem:
When an Oracle Alert is run in R12.1.3 on a Windows 2008 platform, the alert completes with status 255 or status -1073741819.
Solution:
Apply patch 13728376.
The log files for the alerts showed the following errors:
+---------------------------------------------------------------------------+ Alert: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. ALECDC module: Check Periodic Alert +---------------------------------------------------------------------------+ Current system time is 13-JUL-2012 14:58:48 +---------------------------------------------------------------------------+ C:oracleDEV1appsapps_stapplalr12.0.0binalecdc Program exited with status 255 Cause: The program terminated, returning status code 255. Action: Check your installation manual for the meaning of this code on this operating system. +---------------------------------------------------------------------------+ Executing request completion options... Output file size: 0 Output is not being printed because: The print option has been disabled for this report. Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 13-JUL-2012 14:58:52 +---------------------------------------------------------------------------+
You may also see this message (status -1073741819) in the log:
+---------------------------------------------------------------------------+ Alert: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. ALECDC module: Check Periodic Alert +---------------------------------------------------------------------------+ Current system time is 23-JUL-2012 13:49:29 +---------------------------------------------------------------------------+ C:oracleTEST2appsapps_stapplalr12.0.0binalecdc Program exited with status -1073741819 Cause: The program terminated, returning status code -1073741819. Action: Check your installation manual for the meaning of this code on this operating system. +---------------------------------------------------------------------------+ Executing request completion options... Output file size: 0 Output is not being printed because: The print option has been disabled for this report. Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 23-JUL-2012 13:49:31 +---------------------------------------------------------------------------+
I noticed that if the ALECDC program was run from Command Prompt with lowercase username/password, it crashed.
C:oracleTEST2appsapps_stapplalr12.0.0binALECDC.exe apps/apps 0 Y 0, 102022, A
However, when it was run with uppercase username/password, it completed successfully.
C:oracleTEST2appsapps_stapplalr12.0.0binALECDC.exe APPS/APPS 0 Y 0, 102022, A
Therefore, there was a case sensitivity issue here. During the R12.1.3 upgrade, patch 8919491 was applied, which changed the password case sensitivity in R12. Patch 13728376 overcame this issue.
Reference:
After Upgrade R12.1.3 All Alerts Are Completing With Signal 11 [ID 1438919.1]
[amazon asin=0070077290&template=iframe image&chan=default] [amazon asin=1453742735&template=iframe image&chan=default] [amazon asin=0615238440&template=iframe image&chan=default]
0 Comments.