Re: Listener NO services

From: <_at_(none)>
Date: Fri, 25 Feb 2005 15:35:22 +0100
Message-ID: <421f3958$0$836$8fcfb975@news.wanadoo.fr>

Thanks Oxnard,

I regard it, for local_listener :
exmample for listener.ora

oracle_at_future:/oracle/product/10.1.0/network/admin$ cat listener.ora # listener.ora Network Configuration File:
/oracle/product/10.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

TRACE_FILE_LISTENER = listener.trc

SID_LIST_LISTENER =
(SID_LIST =

     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = /oracle/product/10.1.0)
       (PROGRAM = extproc)
     )

)

TRACE_DIRECTORY_LISTENER =
/oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1524)) )

TRACE_LEVEL_LISTENER = USER oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 15:59:31

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /oracle/product/10.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.2.0 - Production System parameter file is /oracle/product/10.1.0/network/admin/listener.ora Log messages written to /oracle/product/10.1.0/network/log/listener.log Trace information written to
/oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date                25-FEB-2005 15:59:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               user
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10.1.0/network/admin/listener.ora
Listener Log File         /oracle/product/10.1.0/network/log/listener.log

Listener Trace File
/oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524))) Services Summary...
Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL> exit
oracle_at_future:/oracle/product/10.1.0/network/admin$ export ORACLE_SID=DBT oracle_at_future:/oracle/product/10.1.0/network/admin$ sqlplus system/manager

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Feb 25 16:00:23 2005

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- 
------------------------------
local_listener                       string
log_archive_local_first              boolean     TRUE

SQL> alter system set local_listener='LISTENER'; alter system set local_listener='LISTENER' *
ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'

SQL> alter system set local_listener='';

System altered.

SQL> alter system set local_listener='1524';

System altered.

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- 
------------------------------
local_listener                       string      1524

SQL> I don't understand.

In Oracle Book :

Registering Information with a Nondefault Listener

If you want PMON to register with a local listener that does not use TCP/IP, port 1521, configure the LOCAL_LISTENER parameter in the initialization parameter file to locate the local listener.

For a shared server environment, you can alternatively use the LISTENER attribute of the DISPATCHERS parameter in the initialization parameter file to register the dispatchers with a nondefault local listener. Because both the LOCAL_LISTENER parameter and the LISTENER attribute enable PMON to register dispatcher information with the listener, it is not necessary to specify both the parameter and the attribute if the listener values are the same.

Set the LOCAL_LISTENER parameter as follows:

LOCAL_LISTENER=listener_alias

Set the LISTENER attribute as follows:

DISPATCHERS="(PROTOCOL=tcp)(LISTENER=listener_alias)"

listener_alias is then resolved to the listener protocol addresses through a naming method, such as a tnsnames.ora file on the database server.

For example, if the listener is configured to listen on port 1421 rather than port 1521, you can set the LOCAL_LISTENER parameter in the initialization parameter file as follows:

LOCAL_LISTENER=listener1

Using the same listener example, you can set the LISTENER attribute as follows:

DISPATCHERS="(PROTOCOL=tcp)(LISTENER=listener1)"

You can then resolve listener1 in the local tnsnames.ora as follows:

listener1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1421)))

Notes:

To dynamically update the LOCAL_LISTENER parameter, use the SQL statement ALTER SYSTEM SET:

ALTER SYSTEM SET LOCAL_LISTENER='listener_alias'

If you set the parameter to null with the statement that follows, then the default local address of TCP/IP, port 1521 is assumed.

ALTER SYSTEM SET LOCAL_LISTENER='' See the Oracle9i SQL Reference for further information about the ALTER SYSTEM SET statement.

The LISTENER attribute overrides the LOCAL_LISTENER parameter. As a result, the SQL statement ALTER SYSTEM SET LOCAL_LISTENER does not affect the setting of this attribute.

Thanks for your help

Christophe Received on Fri Feb 25 2005 - 08:35:22 CST