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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).