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.
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 )
'p_workspace_id', P_WORKSPACE_ID );
NAMESPACE => C_CONTEXT,
ATTRIBUTE => 'WORKSPACE_ID',
VALUE => P_WORKSPACE_ID );
Thank you in advance for your help.
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;
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.