<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> 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%