Differences
This shows you the differences between two versions of the page.
|
tech:others:oracle_xe_enable_remote_access [2014/11/15 09:13] |
tech:others:oracle_xe_enable_remote_access [2014/11/15 09:13] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== 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 | ||
