Why Does the E-Business Suite 12.1.1 Upgrade Driver, u6678700.drv, Appear to Hang on AIX with the 10.2.0.5 Database?

(Doc ID 1336692.1)

Last updated on DECEMBER 16, 2014

Applies to:

Oracle Applications DBA - Version 11.5.9 to 12.1.1 [Release 11.5 to 12.1]
IBM AIX on POWER Systems (64-bit)

Symptoms

On AIX with Database 10.2.0.5, the upgrade from E-Business Suite 11.5.9 to 12.1.1 appears to hang.
This is when running upgrade driver u6678700.drv, specifially the appdstln.sql script, which appears to run forever or hang.
The script appdstln.sql is supposed to insert records in the XLA_DISTRIBUTION_LINKS & AP_PAYMENT_HIST_DISTS tables.
As soon as the script appdstln.sql starts running it is seen that the total record count in the above tables increases initially but after some time there is no change in the record count for those tables.
When checking worker status through the adctrl utility the adworker processes are found to be in "Running" status.

When the adworkers have been set to "Failed" and restarted using the adctrl utility the script appdstln.sql will start running again and the total record count again initially increases and then stops increasing.
When checked through the adctrl utility this time the adworker processes are stuck in "Restarted" status.
When checked at the database level using SQLplus there is no equivalent database session (in v$session) found for the adworkder and adpatch processes.

Changes

Issue happens on AIX with Database 10.2.0.5

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