Wednesday, January 27, 2010

Enable LAN access for Oracle XE admin web on Ubuntu

Edit your .bashrc file to include the lines:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH


Log out. Log in again.

Then start up sqlplus:

sqlplus sys as sysdba


And then just execute:

SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);