Re: Listener NO services

From: Tof <None_at_ForNotSpam>
Date: Fri, 25 Feb 2005 22:17:46 +0100
Message-ID: <421f97a8$0$3107$8fcfb975@news.wanadoo.fr>

I find the solution :

SQL> alter system set
local_listener="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524)))";

System altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options oracle_at_future:/u01$ lsnrctl

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 22:32:15

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener listener_test Current Listener is listener_test
LSNRCTL> status
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future.linux.org)(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 6 hr. 32 min. 54 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 "DBT" has 1 instance(s).

Instance "DBT", status READY, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).

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

Thanks All

Christophe Received on Fri Feb 25 2005 - 15:17:46 CST