Oracle Database Discussions

I proceeded through the installation of Oracle XE, on Windows, and saw no problems. I did have JBoss running on port 8080 at the time of the installation, so Oracle recognized and suggested 8081. I set the port at 9081 somewhat arbitrailly at this point. The install completed fine.

When I tried to go to the local home page (http://127.0.0.1:9081/apex) I got the error about that page being unavailable. netstat (via cygwin) shows nothing listening at 9081.

From looking at the forum, I was introduced to 'lsnrctl status', and here's what I'm seeing:

bash-3.2$ lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-FEB-2008 17:51
:07

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 21-FEB-2008 17:49:43
Uptime 0 days 0 hr. 1 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orl02rwalter3L.na.convergys.com)(POR
T=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Someone in another thread suggested that you can actually start the database via sqlplus, and I gave that a try to see if the missing HTTP listener would start...

bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 21 17:55:27 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\serv
er\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>

The start/stop commands on the windows start menu always seem to be working, but I consistently can't connect to the server home page.

I have searched for anything which might be blocking the port. My windows filewall is disabled, but I also added exceptions for 9081 just in case a group policy is acting up. I can't find anything else on my machine which should be blockign the ports, and more to the point, have recenty run some apps which established tcp/ip sockets to localhost:8087 and localhost:8089 without problems. So I don't think its a firewall issue.

Note that I have run an install repair, to try to address possible issues during installation, and everything above is post-repair.