Could not connect to host 127.0.0.1 (port 8080).

[Phil Pinkerton]

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.



configuration Steps taken:

Specify the HTTP port that will be used for Oracle Application Express [8080]:*<enter>*

Specify a port that will be used for the database listener [1521]:*<enter>*

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:*password*
Confirm the password:*password*

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:*<enter>*

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.

To access the Database Home Page go to "http://127.0.0.1:8080/apex"

Could not connect to host 127.0.0.1 (port 8080)


Log does not show port 8080 ??

$ cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 11-JUN-2007 07:48:28

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

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
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

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

[Phil Pinkerton]

It seems like a simple port configuration issue 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.

ps -deaf | grep oracle
oracle 5715 1 0 07:48 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit


netstat -l shows there is no port 8080 listening ?

/etc/services - shows default configuration

webcache 8080/tcp # WWW caching service

configuration Steps taken:

Specify the HTTP port that will be used for Oracle Application Express [8080]:*<enter>*

Specify a port that will be used for the database listener [1521]:*<enter>*

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:*password*
Confirm the password:*password*

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:*<enter>*

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.

To access the Database Home Page go to "http://127.0.0.1:8080/apex"

Could not connect to host 127.0.0.1 (port 8080)


Log does not show port 8080 ??

$ cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 11-JUN-2007 07:48:28

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

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
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

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

[Derek Broughton]

Post by Phil Pinkerton
netstat -l shows there is no port 8080 listening ?
/etc/services - shows default configuration
webcache 8080/tcp # WWW caching service

services doesn't tell you much - that just provides an alias for 8080.

/etc/inetd configures the actual services (well, it used to - now I only
seem to have ONE service...where did all the others go?)

[Derek Broughton]

Post by Phil Pinkerton
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".

Post by Phil Pinkerton
Started with pid=5715
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(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))

Post by Phil Pinkerton
* 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).

[Wilfried Kaeufler]

Post by Derek Broughton

Post by Phil Pinkerton
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".

Post by Phil Pinkerton
Started with pid=5715
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(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))

Post by Phil Pinkerton
* 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).

I think, your problem is the tcp-port 8080 for https reserved for the
localhost- 127.0.0.1.

Take another host: e.q. 127.0.0.10: 8088 or 6588 etc.

But don?t use the tcp/ip ports: 80, 8080, 21, 2121, 100, 1010.

Use anothr protocol than tcp/ip.

Greetings Wilfried Kaeufler

[Derek Broughton]

Post by Wilfried Kaeufler

Post by Derek Broughton

Post by Phil Pinkerton
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".

Post by Phil Pinkerton
Started with pid=5715
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(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

Post by Wilfried Kaeufler

Post by Derek Broughton
(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))

Post by Phil Pinkerton
* 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).

I think, your problem is the tcp-port 8080 for https reserved for the
localhost- 127.0.0.1.

Why do you think that? 8080 is not usually used for https and afaict
nothing he's doing is trying to use https.

Post by Wilfried Kaeufler
Take another host: e.q. 127.0.0.10: 8088 or 6588 etc.

hmmm. Never tried using another host on 127.0.*.*. That might well work -
but again, the real problem appears to me to be that he _isn't_ using a
local IP, he's using quecaixa or quecaixa.rio.

Post by Wilfried Kaeufler
But don?t use the tcp/ip ports: 80, 8080, 21, 2121, 100, 1010.
Use anothr protocol than tcp/ip.

Ack!!! That's never going to work. You want to use 8080 because it's
generally easier to make _anything_ else use another port than Oracle, and
you MUST use TCP/IP (well, there might be a work-around, but I sure don't
know it).

[Phil Pinkerton]

Post by Phil Pinkerton

Post by Wilfried Kaeufler

Post by Derek Broughton

Post by Phil Pinkerton
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".

*Result : Perhaps due to telnetd not being installed (default ?)

telnet localhost:8080
telnet: could not resolve localhost:8080/telnet: Name or service not known

telnet localhost
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

/Installed telnetd:

Manually added to /etc/xinetd.conf:

///service telnet/
/{ /
/ socket_type = stream /
/ protocol = tcp /
/ wait = no /
/ user = root /
/ server = /usr/sbin/in.telnetd/
/*//*}*/

*Ran # /etc/rc.d/init.d/xinetd restart*

*# telnet localhost
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Ubuntu gutsy (development branch)*

*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

# telnet localhost:8080
telnet: could not resolve localhost:8080/telnet: Name or service not known*

phil
/*
*

Post by Phil Pinkerton

Post by Wilfried Kaeufler

Post by Derek Broughton

Post by Phil Pinkerton
Started with pid=5715
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(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

Post by Wilfried Kaeufler

Post by Derek Broughton
(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))

Post by Phil Pinkerton
* 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).

I think, your problem is the tcp-port 8080 for https reserved for the
localhost- 127.0.0.1.

Why do you think that? 8080 is not usually used for https and afaict
nothing he's doing is trying to use https.

Post by Wilfried Kaeufler
Take another host: e.q. 127.0.0.10: 8088 or 6588 etc.

hmmm. Never tried using another host on 127.0.*.*. That might well work -
but again, the real problem appears to me to be that he _isn't_ using a
local IP, he's using quecaixa or quecaixa.rio.

Post by Wilfried Kaeufler
But don?t use the tcp/ip ports: 80, 8080, 21, 2121, 100, 1010.
Use anothr protocol than tcp/ip.

Ack!!! That's never going to work. You want to use 8080 because it's
generally easier to make _anything_ else use another port than Oracle, and
you MUST use TCP/IP (well, there might be a work-around, but I sure don't
know it).

[Nils Kassube]

Post by Phil Pinkerton

Post by Derek Broughton

Post by Phil Pinkerton
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".

*Result : Perhaps due to telnetd not being installed (default ?)

Telnetd is definitely NOT needed here.

Post by Phil Pinkerton
telnet localhost:8080
telnet: could not resolve localhost:8080/telnet: Name or service not known

Wrong syntax -- it is "telnet host" for the standard telnet port
or "telnet host port" for other ports.

Post by Phil Pinkerton
telnet localhost
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

Correct syntax, but no service on port 23 (standard port for telnet).

Post by Phil Pinkerton
telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

Correct syntax, but no service on port 8080.

Post by Phil Pinkerton
///service telnet/
/{ /
/ socket_type = stream /
/ protocol = tcp /
/ wait = no /
/ user = root /
/ server = /usr/sbin/in.telnetd/
/*//*}*/
*Ran # /etc/rc.d/init.d/xinetd restart*
*# telnet localhost
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Ubuntu gutsy (development branch)*

Now service telnet is running on port 23, as expected -> successfully
connected.

Post by Phil Pinkerton
*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

You didn't install a service for port 8080 -- no change here.

I don't know anything about that oracle database, but obviously you want
it to listen on port 8080. Therefore, please check if the setup of the
database is correct. From your previous post:

| Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quecaixa.rio)
| (PORT=1521)))

Maybe it is listening on the wrong port 1521.


Nils

[Derek Broughton]

Post by Nils Kassube
I don't know anything about that oracle database, but obviously you want
it to listen on port 8080. Therefore, please check if the setup of the
| Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quecaixa.rio)
| (PORT=1521)))
Maybe it is listening on the wrong port 1521.

1521 is _definitely_ the right port for the database listener. But that's
not the http listener.

[Derek Broughton]

There really should _never_ be a reason to install telnetd on your system.
It's a security hazard, and it won't help you when you're trying to test
another _server_.

Post by Phil Pinkerton
*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

We already knew that. Nothing is listening on port 8080 - you need to fix
the problem with the listener startup, not play with other servers.

The startup script on the KDE menu is:

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh

Try running it from a terminal, and see what you get.

[Phil Pinkerton]

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your system.
It's a security hazard, and it won't help you when you're trying to test
another _server_.

OK but how else was I suppose to test "telnet" ??

Post by Derek Broughton

Post by Phil Pinkerton
*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

We already knew that. Nothing is listening on port 8080 - you need to fix
the problem with the listener startup, not play with other servers.
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
Try running it from a terminal, and see what you get.

The DB starts fine I guess:

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit

I would expect more output than that.

[macariov]

Try ( as user with oracle rights, omit -):
-lsnrctl stop
-lsnrctl start
-dbshut
-dbstart

Wait about 20 seconds and try
-lsnrctl status
You should see a bunch of output that includes the db name.
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Phil Pinkerton <pcpinkerton at gmail.com>

Date: Fri, 15 Jun 2007 00:07:12
To:Kubuntu Help and User Discussions <kubuntu-users at lists.ubuntu.com>
Subject: Re: Could not connect to host 127.0.0.1 (port 8080).

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your system.
It's a security hazard, and it won't help you when you're trying to test
another _server_.

OK but how else was I suppose to test "telnet" ??

Post by Derek Broughton

Post by Phil Pinkerton
*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

We already knew that. Nothing is listening on port 8080 - you need to fix
the problem with the listener startup, not play with other servers.
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
Try running it from a terminal, and see what you get.

The DB starts fine I guess:

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit

I would expect more output than that.

[Phil Pinkerton]

Post by macariov
-lsnrctl stop
-lsnrctl start
-dbshut
-dbstart
Wait about 20 seconds and try
-lsnrctl status
You should see a bunch of output that includes the db name.
Sent from my Verizon Wireless BlackBerry

The DB seems to be missing ?
Shouldn't there be a default created upon install ??

Where is "apex" on linux ?

lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2007 06:56:50

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

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2007 06:56:50

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
The command completed successfully
oracle at quecaixa:~$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2007 06:57:27

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=127.0.0.1
)(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 15-JUN-2007 06:57:27
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=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully

dbshut
-su: dbshut: command not found

lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2007 07:07:13

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 Linux: Version 10.2.0.1.0 - Production
Start Date 15-JUN-2007 06:57:27
Uptime 0 days 0 hr. 9 min. 45 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=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully




-----Original Message-----

Post by macariov
From: Phil Pinkerton <pcpinkerton at gmail.com>
Date: Fri, 15 Jun 2007 00:07:12
To:Kubuntu Help and User Discussions <kubuntu-users at lists.ubuntu.com>
Subject: Re: Could not connect to host 127.0.0.1 (port 8080).

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your

system.

Post by Derek Broughton
It's a security hazard, and it won't help you when you're trying to test
another _server_.

OK but how else was I suppose to test "telnet" ??

Post by Derek Broughton

Post by Phil Pinkerton
*# telnet localhost 8080
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

We already knew that. Nothing is listening on port 8080 - you need to

fix

Post by Derek Broughton
the problem with the listener startup, not play with other servers.

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh

Post by Derek Broughton
Try running it from a terminal, and see what you get.

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
I would expect more output than that.
--
kubuntu-users mailing list
kubuntu-users at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/kubuntu-users
--
kubuntu-users mailing list
kubuntu-users at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/kubuntu-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/kubuntu-users/attachments/20070615/945dbe6c/attachment-0001.htm

[Derek Broughton]

Post by macariov
-lsnrctl stop
-lsnrctl start
-dbshut
-dbstart

dbshut/dbstart are not part of the Oracle XE debian package.

[Derek Broughton]

Post by Phil Pinkerton

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your
system. It's a security hazard, and it won't help you when you're trying
to test another _server_.

OK but how else was I suppose to test "telnet" ??

It's the difference between a client and a server. "telnet" is a client
that simply sends text to any internet socket (well, perhaps not quite that
simple). telnetd is a server that you have no need for (in _any_
circumstance, imo). You wanted to use telnet to test access to an http
server, not a telnetd server.

Post by Phil Pinkerton

Post by Derek Broughton
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
Try running it from a terminal, and see what you get.

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
I would expect more output than that.

Come on, now. You have to try to help yourself here; we can't do
everything - and given that there are probably about 1 of us actually
running Oracle XE, I'm the only help you've got :-)

Look at the script - your TNS listener is up, so there's only one line there
that could have an effect (I expect you get no output from the TNS listener
step because it was already up). Try executing the SQLPLUS line - without
the /NOLOG

In fact, I _do_ expect a lot more than that. If I run the script from my
own terminal, I get:

$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925

I don't remember exactly what that was, but I know I googled the fix for it
last time it happened (as you can see, I haven't had my Oracle DB up for a
week or more). I'm reasonably certain in this case it has to do with the
fact that I deleted and recreated the 'dba' group this week - for reasons
not worth going into that are not related to oracle.

[Phil Pinkerton]

Post by Derek Broughton

Post by Phil Pinkerton

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your
system. It's a security hazard, and it won't help you when you're trying
to test another _server_.

OK but how else was I suppose to test "telnet" ??

It's the difference between a client and a server. "telnet" is a client
that simply sends text to any internet socket (well, perhaps not quite that
simple). telnetd is a server that you have no need for (in _any_
circumstance, imo). You wanted to use telnet to test access to an http
server, not a telnetd server.

Post by Phil Pinkerton

Post by Derek Broughton
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
Try running it from a terminal, and see what you get.

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
I would expect more output than that.

Come on, now. You have to try to help yourself here; we can't do
everything - and given that there are probably about 1 of us actually
running Oracle XE, I'm the only help you've got :-)
Look at the script - your TNS listener is up, so there's only one line there
that could have an effect (I expect you get no output from the TNS listener
step because it was already up). Try executing the SQLPLUS line - without
the /NOLOG

I do appreciate the help, believe me it may not seem like it but I am
trying to fix this without help.

sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 16 07:17:45 2007

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

Post by Derek Broughton
In fact, I _do_ expect a lot more than that. If I run the script from my
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
I don't remember exactly what that was, but I know I googled the fix for it
last time it happened (as you can see, I haven't had my Oracle DB up for a
week or more). I'm reasonably certain in this case it has to do with the
fact that I deleted and recreated the 'dba' group this week - for reasons
not worth going into that are not related to oracle.

[Phil Pinkerton]

Post by Derek Broughton

Post by Phil Pinkerton

Post by Derek Broughton
There really should _never_ be a reason to install telnetd on your
system. It's a security hazard, and it won't help you when you're trying
to test another _server_.

OK but how else was I suppose to test "telnet" ??

It's the difference between a client and a server. "telnet" is a client
that simply sends text to any internet socket (well, perhaps not quite that
simple). telnetd is a server that you have no need for (in _any_
circumstance, imo). You wanted to use telnet to test access to an http
server, not a telnetd server.

Post by Phil Pinkerton

Post by Derek Broughton
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
Try running it from a terminal, and see what you get.

ps -deaf | grep oracle
oracle 5709 1 0 Jun14 ? 00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
I would expect more output than that.

Come on, now. You have to try to help yourself here; we can't do
everything - and given that there are probably about 1 of us actually
running Oracle XE, I'm the only help you've got :-)
Look at the script - your TNS listener is up, so there's only one line there
that could have an effect (I expect you get no output from the TNS listener
step because it was already up). Try executing the SQLPLUS line - without
the /NOLOG
In fact, I _do_ expect a lot more than that. If I run the script from my
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
I don't remember exactly what that was, but I know I googled the fix for it
last time it happened (as you can see, I haven't had my Oracle DB up for a
week or more). I'm reasonably certain in this case it has to do with the
fact that I deleted and recreated the 'dba' group this week - for reasons
not worth going into that are not related to oracle.

squplus output:

$sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 16 07:22:14 2007

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

Enter user-name: admin
Enter password:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open
shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

[Derek Broughton]

Post by Phil Pinkerton

Post by Derek Broughton
Try executing the SQLPLUS line -
without the /NOLOG
In fact, I _do_ expect a lot more than that. If I run the script from my
$
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied

Phil, "$sqlplus" is hardly the line in the script. I'm trying to get you to
execute the startup script one step at a time. Running sqlplus - with a
bogus username - won't help.

The script executes:

$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql

I suggested removing /nolog, but it's really the "-s" (silent) you want to
take out (/nolog is actually "no login", because the connect statement is
part of the sql file).

Post by Phil Pinkerton
$sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 16 07:22:14 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: admin
oracleXE: error while loading shared libraries: libaio.so.1: cannot open
shared object file: No such file or directory
ORA-12547: TNS:lost contact

However, all that said - how did you install oracle-xe? libaio is NOT part
of Ubuntu. Ubuntu is using libaio1. libaio needs to be installed from the
same source as oracle-xe. In my case, I had /etc/apt/sources.list pointing
to the oracle download site, so when I did "aptitude install oracle-xe", I
got the libaio package with it. Somehow, I seem to have lost that line,
but I'm sure you can find it with google.