The role of parameters local_listener

Posted on 2009-06-26 filed under: Oracle (RSS) 21 views

Listener log file e: oracleproduct10.2.0db_1networkloglistener.log

Summary of monitoring endpoint ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522)))
Service Summary ..
Service "orcl" contains two routines.
Routine "orcl", status UNKNOWN, this service contains a process ...
Routine "orcl", status READY, this service contains a process ...
Services "orcl_XPT" contains a routine.
Routine "orcl", status READY, this service contains a process ...
Service "test" contains a routine.
Routine "test", status UNKNOWN, this service contains a process ...
The command completed successfully
LSNRCTL>
2. Local_listener can also be set to the address or address list:
SQL> alter system set local_listener = '(DESCRIPTION =
2 (ADDRESS = (PROTOCOL = TCP) (HOST = xys) (PORT = 1522))
3) ';

System has been changed.

LSNRCTL> stop
Is connected to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xys) (PORT = 1522)))
The command completed successfully
LSNRCTL> start
Start tnslsnr: Please wait ...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
File system parameters for the e: oracleproduct10.2.0db_1networkadminlistener.ora
Write e: oracleproduct10.2.0db_1networkloglistener.log monitor the log information: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522)))

Is connected to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xys) (PORT = 1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
25-10 start on the date of -2008 20:39:07
Uptime 0 days 0 hours 0 minutes 3 seconds to track levels off
Security ON: Password or Local OS Authentication
SNMP OFF
Parameter files listener e: oracleproduct10.2.0db_1networkadminlistener.o
ra
Listener log file e: oracleproduct10.2.0db_1networkloglistener.log

Summary of monitoring endpoint ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522)))
Service Summary ..
Service "orcl" contains a routine.
Routine "orcl", status UNKNOWN, this service contains a process ...
Service "test" contains a routine.
Routine "test", status UNKNOWN, this service contains a process ...
The command completed successfully
LSNRCTL> status
Is connected to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xys) (PORT = 1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
25-10 start on the date of -2008 20:39:07
Uptime 0 days 0 hours 0 minutes 6 seconds to track levels off
Security ON: Password or Local OS Authentication
SNMP OFF
Parameter files listener e: oracleproduct10.2.0db_1networkadminlistener.o
ra
Listener log file e: oracleproduct10.2.0db_1networkloglistener.log

Summary of monitoring endpoint ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522)))
Service Summary ..
Service "orcl" contains a routine.
Routine "orcl", status UNKNOWN, this service contains a process ...
Service "test" contains a routine.
Routine "test", status UNKNOWN, this service contains a process ...
The command completed successfully

SQL> alter system register;

System has been changed.

SQL>
LSNRCTL> status
Is connected to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xys) (PORT = 1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
25-10 start on the date of -2008 20:39:07
Uptime 0 days 0 hours 0 minutes 21 seconds to track levels off
Security ON: Password or Local OS Authentication
SNMP OFF
Parameter files listener e: oracleproduct10.2.0db_1networkadminlistener.o
ra
Listener log file e: oracleproduct10.2.0db_1networkloglistener.log

Summary of monitoring endpoint ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522)))
Service Summary ..
Service "orcl" contains two routines.
Routine "orcl", status UNKNOWN, this service contains a process ...
Routine "orcl", status READY, this service contains a process ...
Services "orcl_XPT" contains a routine.
Routine "orcl", status READY, this service contains a process ...
Service "test" contains a routine.
Routine "test", status UNKNOWN, this service contains a process ...
The command completed successfully
LSNRCTL>

rn rn rn