Oracle Database Express Edition (XE)

I realize that Arch Linux is not one of the supported Linux distributions
but i decided to try XE anyways. (I also tried the Debian installation under
Debian 3.1 and it did not work either.)

However under Arch Linux these are the steps I took:

Downloaded both .deb and .rpm files and tried both with equal results.

Under root:
----------------

- compile and install libaio
- install bc

- Extract the archive at the root which gives an install at /usr/lib/oracle/...
and rc file at /etc/init.d/oracle-xe.

- create a user account oracle:dba
- chown -R oracle:dba /usr/lib/oracle
- run /etc/init.d/oracle-xe configure

at this point at this point the listener and the server are supposed to be started
but when I checked only the listener had been started. I realized it was because
there were no database files in $ORACLE_HOME/dbs or /usr/lib/oracle/xe/oradata/XE

then i tried
- su - oracle
- $ORACLE_HOME/bin/createdb.sh

when this step completed some database files were created in $ORACLE_HOME/dbs
then connected to the database with

sqlplus system/oracle -- stop the server
lsnrctl stop

back to root

erase the configuration file and reconfigure. Now the listener, server, and web server start.

go back to oracle, connect with sqlplus again an run

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

to enable remote access.

now connect to the database with the web browser from a windows machine

http://192.168.1.202:8080/apex

log in ---> result:

Not found
The requested URL /apex/ was not found on this server


then
http://192.168.1.202:8080/

Index of /
Name Last modified Size
public/

Mon, 13 Mar 2006 17:57:45 GMT


-
sys/

Mon, 13 Mar 2006 17:58:29 GMT


-
xdbconfig.xml

Mon, 13 Mar 2006 18:15:29 GMT


0

summary: the system seems to be running and conncting fine through sqlplus
but where is the web interface?

is there a way to create a db instance which is complete?

thanks in advance for any help.

Ramiro