Re: 10g Listener not listening?

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.

Ramon F Herrera (ramon_at_conexus.net) wrote:
: 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

: Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

: 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

: Copyright (c) 1991, 2004, Oracle. All rights reserved.

: 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 - 16:00:33 CST