My Oracle Support Banner

Why Does the E-Business Suite 12.1.1 Upgrade Driver, u6678700.drv, Appear to Hang on AIX with the Database? (Doc ID 1336692.1)

Last updated on FEBRUARY 03, 2019

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)


On AIX with Database, 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.


Issue happens on AIX with Database


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

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