Manage HTTP Access in Application Express 3.0

by

Wow, Richard and I have been strugling with APEX 4 on XE for hours before we came across this port:

http://www.emarcel.com/database/143-apexhttpccess

It would have saved us hours.. thanks Marcin!

<COPIED BLOG>

After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEXconsole)

  • http://127.0.0.1:8080/apex
  • http://localhost:8080/apex
  • http://hostname.com:8080/apex (not allowed by default from remote location)

This is because the listener local access setting is being set to local only by default.

To set HTTP Access to allow remote connects:

exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);

To set HTTP Access back to Local only:

exec dbms_xdb.setListenerLocalAccess (l_access => TRUE);

UPDATE:
Another way to set this up is to login to APEX dashboard as a sys user and navigate to: Home > Administration > Manage HTTP Access (Tasks’ list on the right side of the page) and change the settings:

</COPIED BLOG>

Regards,
Sergei

Leave a Comment