Table of Contents

Oracle xe - enabling remote access

http://madrid9999.googlepages.com/oraclexeenableremoteaccess

By default Oracle XE has remote access to Administration Console disabled. So when an attempt to access http://hostname:8080/apex is executed an error such as “unable to open page” shows up. Then an additional post-install procedure has to be performed to remotely access the console.

Enabling Remote HTTP Connection to the Database, should be enough to try to enable remote access from the web console:

Home → Administratrion → Manage HTTP Access

or

from a SQL prompt connected as sysdba excute the store procedure: EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Once the remote access has been enabled it can be accessed not only from the http://127.0.0.1:8080 url, but also from the http://hostname:8080, and this URL can be remotely accessed