-
1. Re: Apex 5.1 downgrade to 5.0
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 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.
If I try access an application directly:
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 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 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