Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g Listener not listening?

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.

    (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))


     (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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US