RE: Listener Problem

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Peter Barnett [mailto:regdba_at_yahoo.com]
> 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: Rich.Jesse_at_qtiworld.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).