I have installed and configured apex 5 with the EPG. I ran apex_epg_config passing in the parameter for the location I had unzipped the apex folder and it all said it completed successfully. Did the post install steps. However when I go to the login page it is rendered without any images (i.e. just blue links on a white background, black text etc). I tried reloading the images but it made no difference. If I do a view source in chrome then I can click on the style sheets and download them (i.e. the stylesheets are there):
<link rel="stylesheet" href="/i/app_ui/css/Core.min.css?v=5.0.0.00.31" type="text/css" />
<link rel="stylesheet" href="/i/app_ui/css/Theme-Standard.min.css?v=5.0.0.00.31" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_builder.min.css?v=5.0.0.00.31" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui.min.css?v=5.0.0.00.31" type="text/css" />
Database is 11.1.0.7.0 (just a demo system, nothing prod).
VIS121 r121@ebs121-vm /oracle/r12/VIS121/db/tech_st/11.1.0/rdbms/admin $ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Wed May 20 10:38:36 2015
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @epgstat
+--------------------------------------+
| XDB protocol ports: |
| XDB is listening for the protocol |
| when the protocol port is non-zero. |
+--------------------------------------+
HTTP Port FTP Port
--------- --------
8080 2100
1 row selected.
+---------------------------+
| DAD virtual-path mappings |
+---------------------------+
Virtual Path DAD Name
-------------------------------- --------------------------------
/apex/* APEX
1 row selected.
+----------------+
| DAD attributes |
+----------------+
DAD Name DAD Param DAD Value
------------ ------------------------ ----------------------------------------
APEX database-username ANONYMOUS
default-page apex
document-table-name wwv_flow_file_objects$
request-validation-funct wwv_flow_epg_include_modules.authorize
ion
path-alias-procedure wwv_flow.resolve_friendly_url
nls-language american_america.al32utf8
path-alias r
7 rows selected.
+---------------------------------------------------+
| DAD authorization: |
| To use static authentication of a user in a DAD, |
| the DAD must be authorized for the user. |
+---------------------------------------------------+
no rows selected
+----------------------------+
| DAD authentication schemes |
+----------------------------+
DAD Name User Name Auth Scheme
-------------------- -------------------------------- ------------------
APEX ANONYMOUS Anonymous
1 row selected.
+--------------------------------------------------------+
| ANONYMOUS user status: |
| To use static or anonymous authentication in any DAD, |
| the ANONYMOUS account must be unlocked. |
+--------------------------------------------------------+
Database User Status
--------------- --------------------
ANONYMOUS OPEN
1 row selected.
+-------------------------------------------------------------------+
| ANONYMOUS access to XDB repository: |
| To allow public access to XDB repository without authentication, |
| ANONYMOUS access to the repository must be allowed. |
+-------------------------------------------------------------------+
Allow repository anonymous access?
----------------------------------
true
1 row selected.
SQL>
SQL> select comp_name, version, status
2 from dba_registry where comp_id='APEX';
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle Application Express
5.0.0.00.31 VALID
1 row selected.
I saw a piece of sql online somewhere in the past to verify the images in the database but can't find it now...