暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

单实例配置非默认端口静态监听器

原创 手机用户7842 2021-08-16
836

配置静态监听器:
只需要配置listener.ora文件

[oracle@begin001 admin]$ cat listener.ora

listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora

Generated by Oracle configuration tools.

LISTENER1 =
(DESCRIPTION_LIST =
(ADDRESS_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = begin001)(PORT = 1533))
)
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ortest123)
(SID_NAME = ortest)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0/db_1)
)
)

还原local_listener:
SQL> alter system set local_listener=’’ scope=both;
启动:
lsnrctl start listener1

状态如下,服务名可以随便起,状态为 UNKNOWN:
[oracle@begin001 admin]$ lsnrctl status listener1

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-AUG-2021 20:42:21

Copyright © 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=begin001)(PORT=1533)))
STATUS of the LISTENER

Alias listener1
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 15-AUG-2021 20:41:42
Uptime 0 days 0 hr. 0 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/begin001/listener1/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=begin001)(PORT=1533)))
Services Summary…
Service “ortest123” has 1 instance(s).
Instance “ortest”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[oracle@begin001 admin]$

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论