After a long and annoying process of trial and error I've managed to install Oracle XE on Gentoo Linux. Now the problem is I can't access the web interface.
kenjiru radu # ps -ef | grep tnslsnr
oracle 9416 1 0 15:02 ? 00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
kenjiru radu # ps -ef | grep XE
oracle 9421 1 0 15:02 ? 00:00:00 xe_pmon_XE
oracle 9423 1 0 15:02 ? 00:00:00 xe_psp0_XE
oracle 9425 1 0 15:02 ? 00:00:00 xe_mman_XE
oracle 9427 1 0 15:02 ? 00:00:00 xe_dbw0_XE
oracle 9429 1 0 15:02 ? 00:00:00 xe_lgwr_XE
oracle 9431 1 0 15:02 ? 00:00:00 xe_ckpt_XE
oracle 9433 1 0 15:02 ? 00:00:02 xe_smon_XE
oracle 9435 1 0 15:02 ? 00:00:00 xe_reco_XE
oracle 9437 1 0 15:02 ? 00:00:00 xe_mmon_XE
oracle 9439 1 0 15:02 ? 00:00:00 xe_mmnl_XE
oracle 9443 1 0 15:03 ? 00:00:00 xe_qmnc_XE
oracle 9495 1 0 15:03 ? 00:00:00 xe_q000_XE
kenjiru radu # cat /etc/default/oracle-xe|grep HTTP_PORT
HTTP_PORT=8088
kenjiru radu # netstat -anl | grep 8088
So oracle isn't listening on port 8088.
This is the first time I've installed Oracle on Linux so it is possible I've done something wrong, but I can't figure out where the problem is.
During installation process I've created a new database like this:
1. modified ORACLE_SID=XE
2. cp $ORACLE_HOME/dbs/init.ora $ORACLE_HOME/dbs/initXE.ora
3. sqlplus '/ as sysdba'
4. SQL> create database XE;
So I can start oracle like this:
kenjiru ~ # /etc/init.d/oracle start
* Starting Oracle Net Listener ...
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-SEP-2006 15:02:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost,)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-SEP-2006 15:02:49
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost,)(PORT=1521)))
Services Summary...
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully [ ok ]
* Starting Oracle Database 10g Express Edition Instance ...
ORACLE instance started.
Total System Global Area 96468992 bytes
Fixed Size 1257356 bytes
Variable Size 88080500 bytes
Database Buffers 4194304 bytes
Redo Buffers 2936832 bytes
Database mounted.
Database opened.
1. How can I check if the database is really ok?
2. And why the web interface doesn't work?
Message was edited by:
kenjiru