Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XE Homepage - unable to connect

540110Oct 18 2006 — edited Feb 12 2009
I have looked at the forum and still cannot figure out why the hompage will not show. IE says 'Page cannot be displayed'. Firefox says 'unable to connect'.

I'm on WinXP Pro with admin rights. Never have been able to view the homepage. I cant even connect by SQL*Plus.

Running 'net start':
OracleServiceXE
OracleXETNSListener

And those are the only ones that arent normally there.

Running 'netstat':
Active Connections

Proto Local Address Foreign Address State
TCP sparebird:1114 localhost:1115 ESTABLISHED
TCP sparebird:1115 localhost:1114 ESTABLISHED
TCP sparebird:kpop gateway1:1025 ESTABLISHED
TCP sparebird:1521 allomony:1539 ESTABLISHED
TCP sparebird:1539 allomony:1521 ESTABLISHED
TCP sparebird:1694 gateway1:5002 ESTABLISHED
TCP sparebird:1776 gateway1:netbios-ssn TIME_WAIT
TCP sparebird:1807 gateway2:5002 ESTABLISHED

I see the 1521 used by the database, but I dont see 8080 for the http listener. When I start tomcat, I see 8084 up there. I've restarted twice. Stopped, then started the db several times.

The 'lnsrctl status' returns:
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 - Production
Start Date 18-OCT-2006 11:11:00
Uptime 0 days 0 hr. 41 min. 26 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\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sparebird)(PORT=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...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status BLOCKED, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

I'm just trying to get the easiest development oracle database setup and it's proving to not be that easy. I dont think I have a firewall because tomcat works just fine with 'localhost:8084' as it does with '127.0.0.1:8084'. I have Norton AV.

Could someone please help me? I appreciate it
Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2009
Added on Oct 18 2006
12 comments
3,037 views