This page isn’t redirecting properly

If you have issues connecting to an APEX instance and firefox responds with:

firex error message

… you probably have the issue that someone told APEX to require https connections but https is not working for any reason. To at least enable the http connections again issue:

ALTER SESSION SET CURRENT_SCHEMA = [APEX_USER];
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('REQUIRE_HTTPS', 'N');
commit;
end;
/

In may case the reason for https not to work anymore is still under investigation, but it seems to be related to this:

select * from v$wallet;
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 1100
Session ID: 566 Serial number: 795

Which leads to a nice core dump in the alert-log:

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x47A1644, __intel_new_memcpy()+52] [flags: 0x0, count: 1]
Errors in file xxxxxxx.trc  (incident=238044):
ORA-07445: exception encountered: core dump [__intel_new_memcpy()+52] [SIGSEGV] [ADDR:0x0] [PC:0x47A1644] [SI_KERNEL(general_protection)] []
Incident details in: xxxxxx.trc