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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to troubleshoot APEX embedded PL/SQL Gateway issue (EPG)?

Denis SunJul 18 2012 — edited Aug 1 2013
Hi,

The EPG has been working fine till Jul 17, 2012. Except that the lisenter was shutdown and brought up and I changed listener port to 1522 from 1521 to test sth then change back to 1521, nothing else I was aware of at the server side. Now when entering a url such as: http://myserver.mycompany.com:8080/apex/apex_admin, recieving "Internet Explorer cannot display the webpage".

This post 10391109 also described the EPG not working after change listener port but working after revert back. In my case, revert back does not work either.

some info:

Aplex Version: 4.1.1.00.23
Oracle : 11.2.0.3.0

--- from dba_registry

COMP_NAME VERSION STATUS
------------------------------ ------------------------------ -----------
Oracle Application Express 4.1.1.00.23 VALID
Oracle XML Database 11.2.0.3.0 VALID


SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

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

-- when i check listener status I got an entry for port 8080, is this expected and is an indication of EPG working?
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver)(PORT=8080))(Presentation=HTTP)(Session=RAW))


-- I can telent to the server for port 8080


Any idea and suggestions about how to troubleshoot this issue further?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2013
Added on Jul 18 2012
3 comments
1,217 views