Could not connect to host 127.0.0.1 (port 8080).

[Derek Broughton]

Phil Pinkerton wrote:

> It seems like a simple problem but for the life of me I cannot remember
> how to fix it.
> 
> I installed Oracle-XE the DB is running but port 8080 is not active.

First guess is you have something else on 8080.  Try "telnet localhost
8080". 

> Started with pid=5715
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quecaixa.rio)(PORT=1521)))
> Listener completed notification to CRS on start
> 
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
> 11-JUN-2007 07:48:29 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=quecaixa)(USER=oracle))(COMMAND=status
(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))
> * status * 0

That looks a little odd.  Why does the listener specify "HOST=quecaixa.rio"
but the connect says "HOST=quecaixa"?  Try making it just "localhost" (mine
is actually 127.0.0.1). Even if you actually want to connect from another
host, _you_ connect to the listener, and _it_ connects to the database, so
if the listener runs on the same machine as the db it doesn't need a
network name (well, I'm a bit out of my depth, but I run Oracle XE on my
laptop and _do_ access it from SQLDeveloper and Toad from another box).
-- 
derek