My Oracle Support Banner

When using the psa utility or the upgrade assistant to upgrade it never finishes due to long running queries (Doc ID 2513026.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

When trying to upgrade an environment to the latest version in environments with large database usage the upgrade may take a really long time and possibly never finish.  In the case of 11.1.1.6 -> 11.1.1.7 you would use the psa utility to upgrade and in the logs you may notice it get stuck here (but it may get stuck other places as well):

 

 You could also check the AWR report and you may see some long running sql executing:

 

If upgrading to a later version using the ua (upgrade assistant) utility it could get stuck at a different query and the logs may look differently as well.



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
Cause
Solution
References


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