I've installed Oracle Express according to the docs (Oracle&reg; Database Express Edition) in a unix oracle-6.5-x64 box. The installation was successful, I'm able to start a sqlplus session by running 'sqplus system/<password>' in the host machine.
Now I want to access the web application (I think it's name is apex) remotely (my host is headless). So I've run the following command:
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
When I navigate to: http://192.168.0.1:8080 or http://192.168.0.1:8080/apex I get a 404.
Some extra info:
- When I navigate to: http://192.168.0.1 I get a "It works"
- I have disabled iptables (etc/init.d/iptables stop)
- netstat -lnptu on the host gives me:
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* OUÇA 14574/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* OUÇA 4419/master
tcp 0 0 :::33454 :::* OUÇA 17014/xe_d000_XE
tcp 0 0 :::8080 :::* OUÇA 16860/tnslsnr
tcp 0 0 :::1521 :::* OUÇA 16860/tnslsnr
tcp 0 0 :::22 :::* OUÇA 14574/sshd
tcp 0 0 ::1:25 :::* OUÇA 4419/master
udp 0 0 0.0.0.0:68 0.0.0.0:* 13792/dhclient
udp 0 0 ::1:40560 :::* 17014/xe_d000_XE
udp 0 0 :::54274 :::* 17010/xe_mmon_XE
udp 0 0 ::1:60812 :::* 17018/xe_s001_XE
udp 0 0 ::1:34192 :::* 16982/xe_pmon_XE
udp 0 0 ::1:36516 :::* 17022/xe_s003_XE
udp 0 0 ::1:57391 :::* 17016/xe_s000_XE
udp 0 0 ::1:37973 :::* 17020/xe_s002_XE
- lsnrctl status on the host gives me:
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 09-JUL-2014 00:45:55
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Estabelecendo conexão com (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS do LISTENER
------------------------
Apelido LISTENER
Versão TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Data Inicial 08-JUL-2014 19:54:30
Funcionamento 0 dias 4 hr. 51 min. 24 seg
Nível de Análise off
Segurança ON: Local OS Authentication
SNMP OFF
Serviço Default XE
Arq. Parâm. Listn. /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Resumo de Atendimento...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclehost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclehost)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Resumo de Serviços...
O serviço "PLSExtProc" tem 1 instância(s).
Instância "PLSExtProc", status UNKNOWN, tem 1 handler(s) para este serviço...
O serviço "XE" tem 1 instância(s).
Instância "XE", status READY, tem 1 handler(s) para este serviço...
O serviço "XEXDB" tem 1 instância(s).
Instância "XE", status READY, tem 1 handler(s) para este serviço...
O comando foi executado com êxito
(hope the non-english text won't affect the output's readability. Sorry for that )