Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect to Apex admin page: http://<host>:8080/apex/apex_admin

752606Feb 9 2010 — edited Nov 4 2012
Hello,

I recently installed Oracle Enterprise Linux 2.6.18-128.el5 running Oracle 11g (11.1.0.6.0). I have configured Apex with embedded PL/SQL gateway using: http://www.oracle.com/technology/obe/11gr1_db/install/apexinst/apexinst.htm. Apex configures without issue, however, my browser is not finding the admin page (Firefox/IE locally or remotely). I am getting "Cannot find server" error. It does not appear that Apex is actually listening on the defined port: netstat -an does not show anything listening on port 8080. Also, SELinux and firewall are both disabled. Here is my epgstat output:

--------------------------------------
| XDB protocol ports: |
| XDB is listening for the protocol |
| when the protocol port is non-zero. |
--------------------------------------

HTTP Port FTP Port
--------- --------
8080 0

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

document-procedure wwv_flow_file_mgr.process_download
nls-language american_america.al32utf8
document-path docs

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?
----------------------------------
false

1 row selected.


SQL> SELECT STATUS FROM DBA_REGISTRY
WHERE COMP_ID = 'APEX';
2
STATUS
-----------
VALID

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT
-----------
8080

SQL> select comp_name, version, status
2 from dba_registry
3 where comp_name='Oracle Application Express';

COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ -----------
Oracle Application Express
3.0.1.00.08 VALID


Any assistance is greatly appreciated.

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2012
Added on Feb 9 2010
14 comments
21,909 views