Hi All:
We are installing APEX within same DB as our Oracle EBS R12.2, which has EBR (Edition-Based Redifinition) enabled in general.
APEX Info:
APEX V19.2
ORDS: 19.4
EBS Info:
DB 19c (19.8)
EBS R12.2
EBR (Edition-Based Redifinition)
Issue
My DBA is applying patch to EBS DB via online patching cycle (Prepare/Apply/Finalize/Cutover/Cleanup). After DBA finishes, I login to APEX workspace and issue below SQL in SQL workshop:
select SYS_CONTEXT('userenv', 'session_edition_name') from dual;
I can tell the edition value returned is an old edition, not the latest edition.
Question: what my DBA should do after online patching cycle so that APEX connection pool is connected with latest EBS DB edition.
I am not a DBA and don't have access to the ORDS configuration. My guess is DBA needs to stop and restart DB connection for the database (that has been patched) within ORDS.
I am looking for what is the best practice to do this: after patch is applied to Oracle DB (EBR enabled), how to ensure APEX connection pool to connect with latest DB edition. If this can be done via a script, that will be super!
Thank you!
Kevin