We have an application in Oracle APEX where we do not have a large database and the number of pages used in the application would be max 250. However, there is a 500 Internal Server error that we are encountering since the last 3-4 days and we have not made any major changes in the application in the last 3-4 days.
We have not been able to debug which page, which process or which object in Oracle apex or Oracle Database is causing the error.
There are many applications deployed on that server and it is difficult to find out which particular application is causing this issue.
We are using Oracle Apex 18.2 and Oracle Database Standard Edition 11.2.
Please help us in debugging the issue as it is impacting many of our LIVE applications and clients.
The "internal server error" will be most likely be coming back from ORDS on the webserver you are using host application express.
So check your ORDS logs (location will depend on what webserver etc you are using) and normally (if its a database error) then the database error (ORA- etc) will have been captured in the ORDS logs.
If that does not assist *and* the error is reproducible on demand, you could activate tracing for the ORDS sessions on the database with something like:
set serverout on
begin
for i in ( select sid, serial#
from v$session
where username in ('ORDS_PUBLIC_USER')
) loop
dbms_output.put_line(i.sid||','||i.serial#);
dbms_monitor.SESSION_TRACE_ENABLE(i.sid, i.serial#, true,true);
end loop;
end;
/
and then re-generate your error and then examine your trace directory for trace files.
Don't forget to turn *off* trace for those session with "session_trace_disable"