一个在win下关于配置监听端口的有…

本文详细介绍了在Windows环境下修改数据库监听端口(从默认1521更改为1523,再回滚)的步骤及遇到的问题解决方法,包括配置listener.ora文件、重启数据库服务等操作。

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

<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 一个在win下关于配置监听端口的有趣的问题<br> 问题场景:一网友想把默认的port=1521 改为port=1523,接着又想改回来。</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

将listener.ora的port改为1521
LISTENER =
<wbr> (DESCRIPTION_LIST =<br><wbr><wbr><wbr> (DESCRIPTION =<br><wbr><wbr><wbr><wbr><wbr> (ADDRESS = (PROTOCOL = TCP)(HOST = PC-20120306AAJY)(PORT = 1521))<br><wbr><wbr><wbr><wbr><wbr> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<br><wbr><wbr><wbr> )<br><wbr> )<br><wbr><br> 保存后重启数据库。<br> 发现如下问题 lsnrctl status:<br><wbr><br> ........<br> LSNRCTL&gt; status<br> 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-20120306AAJY)(PORT=152<br> ))<br> TNS-12541: TNS: 无监听程序<br><wbr>TNS-12560: TNS: 协议适配器错误<br><wbr> TNS-00511: 无监听程序<br><wbr><wbr> 32-bit Windows Error: 61: Unknown error<br> 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))<br> LISTENER 的 STATUS<br> ------------------------<br> 别名<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> LISTENER<br> 版本<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Pro<br> ction<br> 启动日期<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 22-5月 -2012 19:53:00<br> 正常运行时间<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 0 天 0 小时 6 分 41 秒<br> 跟踪级别<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> off<br> 安全性<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ON: Local OS Authentication<br> SNMP<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> OFF<br> 监听程序参数文件<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> F:\oracle11gR2\product\11.2.0\dbhome_1\network\admin<br> istener.ora<br> 监听程序日志文件<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> f:\oracle11gr2\diag\tnslsnr\PC-20120306AAJY\listener<br> lert\log.xml<br> 监听端点概要...<br><wbr> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC-20120306AAJY)(PORT=1523)))<br><wbr> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))<br> 服务摘要..<br> 服务 "CLRExtProc" 包含 1 个实例。<br><wbr> 实例 "CLRExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...<br> 命令执行成功<br> .......<br> 发现port还是1523</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

##解决方法:将windows中listener的服务重启下
net stop OracleService%ORASID%

net stop Oracle%ORAHOME%TNSListener


重启:
net start Oracle%ORAHOME%TNSListener

net start OracleService%ORASID%

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值