Unfortunately, our company is large enough that no one ever really has to admit to anything because it is simply too difficult to run down the perpetrators.
The listener did start. Some users could connect to the databases from one server but not another. We think it was related to an intrusion software install, but the back out of the install did not fix the problem. There was a giant meeting of everyone who might have any impact on the box and minutes after the meeting ended everything was working again. My guess is that someone in the meeting recognized a mistake and corrected it without saying anything. So, we will never know the true cause. --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > As luck would have it, we just went through a > similar problem. > > Does the listener actually startup? Can you stop > and restart it manually > using "lsnrctl"? > > Ours wouldn't. We tracked it down to two problems, > both security related. > The one that was hampering our listener was a change > in /etc/nsswitch.conf > that caused a change in the way that the listener > tried to listen on the > port. Specifically, look for differences in the > "protocols" line and the > "services" line. Also, potentially, the "ipnodes" > line. > > We were installing LDAP and had changed these lines > to "ldap > [NOTFOUND=return] files", but the listener just > didn't like it, so we > changed them back to just "files". Also, the only > time we'd see a problem > is in the start and stop of the listener. If we > changed the files back to > "ldap..." while the listener was up, connections > worked fine. We just > couldn't start it back up if it was shutdown. > > Barring this, check for security differences in your > "bin" and "network" dir > trees under $ORACLE_HOME. Check for owner, group > and protection bits. > > HTH! GL! :) > > Rich > > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > > > -----Original Message----- > > From: Peter Barnett [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 09, 2002 2:09 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Listener Problem > > > > > > Yesterday we had a cpu panic followed by a > spontaneous > > reboot of a Sun E6000 server. When the server and > > databases came back on line we were getting 'no > > listener' errors from several Unix servers but not > all > > of them. We also lost connectivity between the > > mainframe and the databases on the affected > server. > > Those that failed were consistent, those that > conected > > were also consistent. > > > > The Unix Admin captured the following lines from a > > netsta -an command: > > > > Following line is from dragon - the server that > has > > the TNSLISTENER on only one interface > > > > 161.208.1.138.1521 *.* 0 > 0 > > 0 0 LISTEN > > > > > > Following line is from beowulf - the server that > has > > the TNSLISTENER on all interfaces > > > > *.1521 *.* 0 > 0 > > 0 0 LISTEN > > > > He is focusing the ip address binding to the > oracle > > port on one server but using a wild card for the > > other. > > > > We have a tar open for this but so far, they have > not > > been too helpful. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > 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). ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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).
