The role of parameters local_listener
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
Related Posts of The role of parameters local_listener
-
RMAN created physical standby
Monitor in the standby host to create the necessary directory structure and parameter files. Hot COPY after the main library to the standby, and on standby to restore. +++++++++++++++++++++++++++++ Standby ++++++++++++++++++++++++++++++++++++++++++++ ...
-
Oracle deadlock related
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
-
SQL optimization (4) - Table of the three connections
Test the following three commonly used connection between the table: Sort - merge connected (sort-merge join, SMJ) Nested loops (nested loop, NL) Hash connection (hash join, HASH) 1. To create the test table SQL> select * from v $ version; BANNER ...
-
SQL optimization (5) - commonly used test hints
First, the purpose of testing SunnyXu in accordance with the "SQL Performance adjust - summarized," commonly used to test the following four categories of hints: 1. The method of instruction optimizer hints with the aim ALL_ROWS: Based on t ...
-
SQL optimization (3) - four index
Test the following four types of index: Unique Index Scan (INDEX UNIQUE SCAN) Index range scan (INDEX RANGE SCAN) Scan the whole index (INDEX FULL SCAN) Express-wide scan index (INDEX FAST FULL SCAN) 1. To create the test table and the only composite ...
-
SQL optimization (1) - full table scan and index the test
Test Objective: To test CBO and RBO, as well as full table scan than index the situation quickly. 1. To create a test environment SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- Oracle Datab ...
-
use sqlldr 1 Introduction
The customer is always asked for two days to a number of temporary table to import text data, sql * loader is also not very familiar with the FREE today to sum up. General to set up two files: Control files and data files, if the data can also be les ...
-
Oracle10g with cross-platform endian transfer
In Oracle10g, the same endianness the first cross-platform file information Oracle will automatically re-evaluated, the conversion is no longer necessary. We watch the following tests: [oracle @ danaly oradata] $ sqlplus "/ as sysdba" SQL * ...
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
Leave a Reply