Oracle-L: Listener Problem

From: Peter Barnett <regdba_at_yahoo.com>
Date: Wed, 09 Oct 2002 11:09:06 -0800
Message-ID: <F001.004E4BB7.20021009110906@fatcity.com>

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.

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

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: regdba_at_yahoo.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 Oct 09 2002 - 14:09:06 CDT