Re: 10g Listener not listening?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 16 Mar 2004 19:31:02 -0800
Message-ID: <c9bc36ff.0403161931.411e2719@posting.google.com>

xux_at_informa.bio.caltech.edu (Xuequn Xu) wrote in message news:<c37te1$efi$1_at_naig.caltech.edu>...
> I saw the same "ON: Local OS Authentication" output from my 10g installation
> on Solaris, and yet I can connect to it just fine from any of my remote 8, 8i
> and 9i clients.
>

Thanks for your answer, Xuequn. I found the problem and its solution. It turns out that there is a bug in the 10g Linux Listener.

You CANNOT telnet into port 1521 from any outside host if you have lines like these in listener.ora:

    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.domain.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

However if you use any of these two lines, everything works fine:

     (ADDRESS = (PROTOCOL = TCP)(HOST = 148.87.9.44)(PORT = 1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))

Therefore...
Linux folks: use either all zeros or the host actual IP address ONLY.

Boy, my head is square now, with so much banging it against the wall on this problem!! That's what you get when you try to be on the bleeding edge. :-)

-Ramon Received on Tue Mar 16 2004 - 21:31:02 CST