OracleXeWebAccessPrep

Grant Gainey edited this page Dec 12, 2016 · 2 revisions

Oracle XE Web access prep

The Oracle XE web interface is accessible on localhost (127.0.0.1) by default. If you want to access it from outside the box, there

are a number of ways to address this.

The Oracle way

The 'correct' oracle way would be to execute the following with sysdba privileges:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

If you messed up the APEX port in configure, you can use the following command to 'fix' it:

SQL> EXEC DBMS_XDB.SETHTTPPORT(9000); 

Change listener configuration

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=9000))(Presentation=HTTP)(Session=RAW))

Do not forget to restart the listener. Example of a modified /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora:

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = spacewalk-server.example.com)(PORT = 1521))
    )
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spacewalk-server.example.com)(PORT=9000))(Presentation=HTTP)(Session=RAW))
  )

DEFAULT_SERVICE_LISTENER = (XE)

ssh forwarding trick

You can also forward http://127.0.0.1:9000/apex via ssh tunnel:

ssh -L 9000:localhost:9000 -l root -N <oracle machine name>. This should allow you to browse to localhost.

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.