我要评论windows环境下重建oracle监听
由于某种原因导致数据库监听启动失败，需要重新创建监听。
过程如下：
第一步
修改 listenr.ora 文件 ，增加新的监听配置
listener4 =
(description_list =
(description =
(address = (protocol = tcp)(host = desktop-be6gdnt)(port = 1528))
)
)
adr_base_listener4 = d:\app\zhou
第二步
启动监听
lsnrctl start listener4 日志记录如下： c:\windows\system32>lsnrctl start listener4 lsnrctl for 64-bit windows: version 11.2.0.4.0 - production on 31-may-2024 12:19:07 copyright (c) 1991, 2013, oracle. all rights reserved. starting tnslsnr: please wait... failed to open service <oracleoradb11g_home1tnslistenerlistener4>, error 1060. tnslsnr for 64-bit windows: version 11.2.0.4.0 - production system parameter file is d:\app\zhou\product\11.2.0\dbhome_1\network\admin\listener.ora log messages written to d:\app\zhou\diag\tnslsnr\desktop-be6gdnt\listener4\alert\log.xml listening on: (description=(address=(protocol=tcp)(host=desktop-be6gdnt)(port=1528))) connecting to (description=(address=(protocol=tcp)(host=desktop-be6gdnt)(port=1528))) status of the listener ------------------------ alias listener4 version tnslsnr for 64-bit windows: version 11.2.0.4.0 - production start date 31-may-2024 12:19:13 uptime 0 days 0 hr. 0 min. 6 sec trace level off security on: local os authentication snmp off listener parameter file d:\app\zhou\product\11.2.0\dbhome_1\network\admin\listener.ora listener log file d:\app\zhou\diag\tnslsnr\desktop-be6gdnt\listener4\alert\log.xml listening endpoints summary... (description=(address=(protocol=tcp)(host=desktop-be6gdnt)(port=1528))) the listener supports no services the command completed successfully
第三步
配置 tnsnames.ora 内容，注册服务
scimdb4 =
(description =
(address = (protocol = tcp)(host = desktop-be6gdnt)(port = 1528))
(connect_data =
(server = dedicated)
(service_name = scimsdb)
)
)
第四步
注册服务
alter system set local_listener='scimdb2','scimdb3','scimdb4'; alter system register;
总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持代码网。
发表评论