10 Replies Latest reply: Aug 2, 2013 9:22 AM by DanielAndino RSS

    Error when installing apex 4.2.2

    DanielAndino

      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

      APEX_040200.WWV_FLOW_SECURITY

      -----------------------------------------------------------------------------------------

       

      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!!

      Daniel.

        • 1. Re: Error when installing apex 4.2.2
          jariola

          Hi,

           

          I have not never seen this error, but ..

          Have you stop web listener before you try upgrade ?

          Are you running 10G XE ?

           

          Regards,
          Jari

          • 2. Re: Error when installing apex 4.2.2
            DanielAndino

            Hi Jari,

             

            Before starting I have changed http port to 0. I'm running 10G XE.

             

            Thanks for your answer.

            Dan.

            • 3. Re: Error when installing apex 4.2.2
              jariola

              Hi,

               

              Ok. Sorry, but I do not know what might be problem.

              You might check this guide also

              Upgrading Oracle Application Express in Oracle Database Express Edition

               

              Regards,
              Jari

              • 4. Re: Error when installing apex 4.2.2
                DanielAndino

                Thanks for sharing that upgrading guide, Jari

                 

                I think this issue is related to the process itself because I just have to run apexins.sql file with proper parameters. No need to follow further steps.

                 

                For several minutes everything looks good until it tries to compile that package body. It gets stuck there for some minutes and then return that error message.

                 

                Thanks again.

                Dan.

                • 5. Re: Error when installing apex 4.2.2
                  jariola

                  Hi,

                   

                  Just wonder could it be space issue e.g. in tablespace SYSAUX?

                  If I recall correctly 10G XE can have 1GB system data.

                   

                  Regards,

                  Jari

                  • 6. Re: Error when installing apex 4.2.2
                    DanielAndino

                    Hi Jari,

                     

                    Have checked tablespace free space by running below query

                     

                    SELECT b.tablespace_name
                              , tbs_size 
                              , a.free_space 
                    FROM   (SELECT tablespace_name
                                                  , round(sum(bytes)/1024/1024 ,2) as free_space
                                 FROM dba_free_space
                                GROUP BY tablespace_name
                                ) a,
                               (SELECT tablespace_name
                                              , round(sum(bytes)/1024/1024,2) as tbs_size
                                FROM  dba_data_files
                              GROUP BY tablespace_name
                              ) b
                    WHERE a.tablespace_name = b.tablespace_name
                    AND    a.tablespace_name = 'SYSAUX';
                    
                    
                    

                     

                    Results:

                     

                    TABLESPACE_NAME                     TBS_SIZE   FREE_SPACE

                    ---------------------------------------------------- ----------------- -----------------------

                    SYSAUX                                                  1330                  8.75

                     

                    It seems you were right. It could be a tablespace size issue. Should I increase SYSAUX tablespace size?

                    • 7. Re: Error when installing apex 4.2.2
                      jariola

                      Hi,

                       

                      Well, I'm not DBA. But I guess it should not harm to try.

                      Of course you have backup full database before you have start upgrade.

                       

                      Regards,

                      Jari

                      • 8. Re: Error when installing apex 4.2.2
                        DanielAndino

                        Hi Jari,

                         

                        I just wanted to let you know that I created a new tablespace called APEX (just to make sure my data is safe) and re-installed APEX using it.

                         

                        Unfortunatelly, I'm still getting the same error message, so any other suggestion would be more than welcome! (from anyone )

                         

                        Thanks,

                        Dan.

                        • 9. Re: Error when installing apex 4.2.2
                          DanielAndino

                          I have just found WWV_FLOW_UPGRADE_PROGRESS table which is used as a debug table during upgrade process.

                           

                          It pulled below error information:

                          UPGRADE_ACTION: Removing database job

                          UPGRADE_ERROR: ORA-27365: job has been notified to stop, but failed to do so immediately

                          UPGRADE_COMMAND: begin sys.dbms_scheduler.drop_job ( job_name = 'APEX_040100.ORACLE_APEX_MAIL_QUEUE', force => TRUE); end;

                           

                          Regards,

                          Dan.

                          • 10. Re: Error when installing apex 4.2.2
                            DanielAndino

                            As I was not able to find a better solution for this issue. I removed APEX (using @apxremov.sql script).

                             

                            Then I installed version 4.2.2 and It worked! As I did not remove anything from database, after installing APEX all workspaces, users, etc were automatically uploadad to APEX.

                             

                            Regards,

                            Dan