Publishing Oracle Application Express Applications On The Internet
An application created using Oracle Application Express can only be run under the local machine (eg. http://localhost:8080/apex/ or http://127.0.0.1:8080/apex/). It would be nice if the applications developed with Oracle Application Express could be accessed by other computers across the Intranet or Internet. So, I was wondering if it is ever possible to publish web applications developed by an Oracle Application Express on the Internet. Actually there are commercial hosting (eg. http://www.htmldb-hosting.com/) for Oracle Application Express or HTML-DB. One needs only to import the applications developed at the commercial hosting’s workspace. I don’t really need a commercial hosting for this if the application is only for Intranet use.
Activate Oracle Application Express Applications for the Internet using sqlplus:
#sqlplus /nolog
SQL>connect sys/ as sysdba;
SQL>exec dbms_xdb.setListenerLocalAccess(false);
Source: Oracle® Database Express Edition Installation Guide 10g Release 2 (10.2) for Linux
Take note that the firewall setting of the machine hosting the Oracle Apex application should be set to allow access from the network or Internet. I hope that works for you!
Posted on
Friday, March 14th, 2008 at 7:02 am under 