Thanks
for replying Leroy,
I
am running Oracle 9i Enterprise Edition 9.2.0.1.0 for both the database
and the listener. But I wonder if the issue is the standard port 1521,
should I change to a non-standard port?
Julio
Cesar Quijada-Reina
Programmer
Analyst
Computer
Services at AlfredState
College
-----Original
Message-----
From:
ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On
Behalf Of LeRoy Kemnitz
Sent:Wednesday,
December 17, 20033:34
PM
To:
Multiple recipients of list ORACLE-L
Subject:
Re: no longer listening
I
had a lot of problems with the listeners going down for no reason.
I was running 8.1.7.4 with 8.1.7 listeners at the time. I changed
the ports to non-default ports and upgraded to 9. And haven't had
a problem since.
"QuijadaReina,
Julio C" wrote:
Hi
all,
For
the last couple of weeks, I have experienced listener down times. The listener
will work fine for say a week, and then all the sudden it will no longer
allow connections from remote machines. Clients use SQL*plus to connect.
Interestingly enough, on the actual server I am able to login just fine.
The following are the log lines as they appear in my listener.log.
-------------------------------------
No
longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
No
longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521)))
No
longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
No
longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW))
-------------------------------------
HTTP
and FTP are not important, since we do not use any Oracle’s HTTP or FTP.
But the second line on the log is rather important since it is the listener’s
port (1521).
The
server is a Win2K with 128MB of RAM and a small test database for about
60 users of which 20 or so might connect simultaneously.
Any
ideas as to why this might be happening?
Regards,
Julio
Cesar Quijada-Reina
Programmer
Analyst
Computer
Services at AlfredStateCollege
