4 Replies Latest reply on Jan 9, 2017 1:38 PM by Jstraub-Oracle

    Apex 5.1 downgrade to 5.0

    Shaun
    Shaun Jan 5, 2017 1:02 PM

      Hi

       

      Anyone got some guidelines on on rolling back to 5.0 from 5.1?

       

      The latest 5.1 documentation omits this information? https://docs.oracle.com/database/apex-5.1/HTMIG/cleaningup-after-failed-installation.htm#HTMIG265

      Should I follow the 4.2 non-CDB process and replace all references to APEX_040200 with APEX_050000?

         ****** The above doesnt work... scripts have changed... *****

       

      Regards,

      Shaun

        • 1. Re: Apex 5.1 downgrade to 5.0
          Jstraub-Oracle
          Jstraub-Oracle Jan 6, 2017 9:12 PM (in response to Shaun)

          Hi Shaun,

           

          Thanks for bringing this to our attention. It was definitely a miss and we will get the Installation Guide corrected. In the meantime, you can use my blog post on this subject.

           

          Regards,

           

          Jason

          • 2. Re: Apex 5.1 downgrade to 5.0
            Shaun
            Shaun Jan 9, 2017 10:29 AM (in response to Jstraub-Oracle)

            Hi Jason

             

            Thank you.

             

            I have run the downgrade scripts, and rerun the apex_rest_config.sql scripts and rerun the database config scripts for ORDS, but I am now getting an ORA-01031 error as soon as try access the builder.

             

            Capture.PNG

             

            If I try access an application directly:

             

            Capture.PNG

             

            Running the following as SYS in sqlplus, apex_util.set_security_group_id(p_security_group_id => c1.workspace_id); gets below error

             

            ERROR at line 1:

            ORA-01031: insufficient privileges

            ORA-06512: at "SYS.DBMS_SESSION", line 122

            ORA-06512: at "APEX_050000.WWV_FLOW_SESSION_CONTEXT", line 30

            ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2728

            ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2770

            ORA-06512: at "APEX_050000.HTMLDB_UTIL", line 2973

            ORA-06512: at line 11

             

            Which at the end is executing this is WWV_FLOW_SESSION_CONTEXT ->

            PROCEDURE SET_WORKSPACE_ID (

                P_WORKSPACE_ID IN NUMBER )

            IS

            BEGIN

                WWV_FLOW_DEBUG.ENTER (

                    'set_workspace_id',

                    'p_workspace_id', P_WORKSPACE_ID );

                SYS.DBMS_SESSION.SET_CONTEXT (

                    NAMESPACE => C_CONTEXT,

                    ATTRIBUTE => 'WORKSPACE_ID',

                    VALUE     => P_WORKSPACE_ID );

            END SET_WORKSPACE_ID;

             

            Thank you in advance for your help.

             

            Regards,

            • 3. Re: Apex 5.1 downgrade to 5.0
              Shaun
              Shaun Jan 9, 2017 11:02 AM (in response to Shaun)

              Hi

               

              Found the fix. After running the above scripts, login as SYS and run the following:

               

              drop context APEX$SESSION;

              create context APEX$SESSION using APEX_050000.WWV_FLOW_SESSION_CONTEXT;

               

              Regards,

              Shaun

              • 4. Re: Apex 5.1 downgrade to 5.0
                Jstraub-Oracle
                Jstraub-Oracle Jan 9, 2017 1:38 PM (in response to Shaun)

                Hi Shaun,

                 

                Thanks for also pointing that out. I should have attempted to actually login in my downgrade test! I will make sure I get the instructions corrected.

                 

                Regards,

                 

                Jason