local_listener参数（1）---elaine

最新推荐文章于 2020-12-04 10:33:37 发布

csi0288

最新推荐文章于 2020-12-04 10:33:37 发布

阅读量226

点赞数

文章标签：数据库网络

本文介绍了Oracle数据库中local_listener参数的设置及其与实例动态注册的关系。通过步骤演示如何配置local_listener参数，并验证实例是否成功注册到监听器上。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

对于local_listener，官方文档是这样描述的：

Property	Description
Parameter type	String
Syntax	LOCAL_LISTENER = network_name
Default value	(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) where hostname is the network name of the local host.
Modifiable	ALTER SYSTEM
Basic	No

LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.

个人理解：local_listener与监听的动态注册有关。

第一步，检查主机的信息

[oracle@secdb1 ~]$ cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

192.168.61.101 secdb1.localdomain secdb1

第二步，检查local_listener参数

SYS@PROD>show parameter local_

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

local_listener string

第三步，启动监听

[oracle@secdb1 ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2012 21:07:27

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb1.localdomain)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 26-JUL-2012 21:07:32

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb1.localdomain)(PORT=1521)))

The listener supports no services

The command completed successfully

第四步，等待实例注册成功

LSNRCTL> status