404 error after restoring the database
497499Apr 17 2007 — edited Jun 20 2007Friends, our dba team restored the Flows_030000 schema after a complete monthly refresh of our server (RMAN restore). Now when I try to access the APEX admin page or any of the applications it gives me a 404 error saying '/pls/apex/apex_admin/ was not found on this server'.
I looked at the apache error log file and found the following
mod_plsql: /pls/apex/apex_admin HTTP-404 ORA-04063: package body "FLOWS_030000.WWV_FLOW_SECURITY" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "FLOWS_030000.F", line 276
ORA-06512: at "FLOWS_030000.APEX_ADMIN", line 5
ORA-06512: at line 10.
The RMAN refresh is a regular monthly process for us it was going smooth for the past one year ever since we deployed Apex 2.2. Last month we upgraded it to 3.0 and this is the first refresh after the upgrade.
I feel it is most probably a priveleges issue. But not sure what it could be.
Guys, any thoughts or any experiences facing the same kind of situation?