windows环境下重建oracle监听
由于某种原因导致数据库监听启动失败，需要重新创建监听。
过程如下：
第一步
修改 listenr.ora 文件 ，增加新的监听配置
LISTENER4 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-BE6GDNT)(PORT = 1528))
)
)
ADR_BASE_LISTENER4 = D:appzhou
第二步
启动监听
lsnrctl start LISTENER4 日志记录如下： C:Windowssystem32>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 , error 1060. TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production System parameter file is D:appzhouproduct11.2.0dbhome_1networkadminlistener.ora Log messages written to D:appzhoudiagtnslsnrDESKTOP-BE6GDNTlistener4alertlog.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:appzhouproduct11.2.0dbhome_1networkadminlistener.ora Listener Log File D:appzhoudiagtnslsnrDESKTOP-BE6GDNTlistener4alertlog.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;
总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持IT俱乐部。
