Manage HTTP Access in Application Express 3.0

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

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:

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

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 Reply