So, how are your host names resolved? Any changes in DNS or WINS name servers?
Did anybody reboot or alter PDC? On NT host names are resolved by asking PDC .
If it cannot respond because of reboot, listener may shut down as well. You
should try modifying yur local equivalent of nsswitch.conf. whatever the name
is.
On 12/17/2003 04:24:34 PM, "QuijadaReina, Julio C" wrote:
> Mladen,
>
> I did look at the listener.log file and did not see any changes as far
> as network configuration. The host where the database is running on does
> not have a fixed IP address though. It gets a lease from a DHCP. I
> checked the logs on the DHCP and the IP for my database host has not
> changed lately. Also, the HOST parameter in listener.ora has assigned to
> it the host's name and not its IP address.
>
> Julio Cesar Quijada-Reina
> Programmer Analyst
> Computer Services at Alfred State College
>
>
> -----Original Message-----
> Mladen Gogala
> Sent: Wednesday, December 17, 2003 3:19 PM
> To: Multiple recipients of list ORACLE-L
>
> Somebody might have changed network configuration. Did you look into
> the listener.log ?
> On 12/17/2003 02:19:43 PM, "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 Alfred State College
> >
> >
> >
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: QuijadaReina, Julio C
> INET: QuijadJC_at_alfredstate.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Dec 17 2003 - 15:44:32 CST
