10g Listener not listening?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 16 Mar 2004 11:03:32 -0800
Message-ID: <c9bc36ff.0403161103.64890756@posting.google.com>

Did Oracle change the default LISTENER behavior from version 9i to version 10g?

I have a new 10g installation which only accepts connections coming from the same host where the database resides.

I can telnet to localhost port 1521 from the database server itself only. From any other host I get a "connection refused".

The lsnrctl status output has definitely changed. This is the older one:

LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 16-MAR-2004 13:52:43

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date                16-MAR-2004 05:39:26
Uptime                    0 days 8 hr. 13 min. 19 sec
Trace Level               off
Security                  OFF
SNMP                      OFF


--------------------------------------------------------------------------------

and this is the new one:

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 16-MAR-2004 13:55:29

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date                16-MAR-2004 13:43:18
Uptime                    0 days 0 hr. 12 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF


--------------------------------------------------------------------------------

What is this business of "ON: Local OS Authentication"? How can I change it??
I can't find anything about it in the OTN documentation.

Initially I thought it was a firewall problem, but I turned the "iptables" firewall off and the rejection problem persists.

Thanks for your insight,

-Ramon F. Herrera Received on Tue Mar 16 2004 - 13:03:32 CST