This discussion is archived
10 Replies Latest reply: Aug 2, 2013 7:22 AM by DanielAndino RSS

Error when installing apex 4.2.2

DanielAndino Newbie
Currently Being Moderated

Hi All,


I know it's a quite new version of APEX but we have decided to upgrade our current version (4.1.1) to the new 4.2.2.


I downloaded it from this link (OTN).


I unzipped downloaded file in: /usr/lib/oracle/xe/ (Renamed previous APEX version folder to "apex4.1.1").


Then I followed steps listed in this link in order to get APEX upgraded to 4.2.2 version.


After a few minutes, the installation process failed with below error:



alter package wwv_flow_security compile body


Error at line1:

ORA-04021: timeout ocurred while waiting to lock object




I have checked through database and found that  this package (APEX_040200.WWV_FLOW_SECURITY) is locked by that user (APEX_040200).

It seems that something is wrong with the installation process as it creates the APEX_040200 and then its package WWV_FLOW_SECURITY.


I have reverted this installation. This process includes dropping APEX_040200 user using cascade mode. So I made sure that all db objects were deleted for that user. Then I re-run installation process with no luck. I got same error message.


Have you ever experienced this kind of error during APEX upgrade process? Am I missing some step before running this process?


I really appreciate your help on this!!



  • Correct Answers - 10 points
  • Helpful Answers - 5 points