今天在自己电脑上手工启动listener时出现如下错误:
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bright)(PORT=1521)))
TNS-12546: TNS: 拒绝许可
TNS-12560: TNS: 协议适配器错误
TNS-00516: 拒绝许可
32-bit Windows Error: 13: Permission denied
奇怪!以前都好好的,怎么会报这种错误?难道是权限不够?查看一下当前的用户,没问题呀,是管理员权限,而且也是ORA_DBA群组成员!难道是目录权限不够?一查看也没问题呀!那就奇怪了....难道是端口有冲突?赶紧执行:
C:/>netstat
Active Connections
Proto Local Address Foreign Address State
TCP bright:912 bright:1323 ESTABLISHED
TCP bright:912 bright:1331 ESTABLISHED
TCP bright:912 bright:1332 ESTABLISHED
TCP bright:1323 bright:912 ESTABLISHED
TCP bright:1331 bright:912 ESTABLISHED
TCP bright:1332 bright:912 ESTABLISHED
TCP bright:microsoft-ds ip-252-1-168-192.rev.dyxnet.com:3552 ESTABLISHED
TCP bright:1521 baym-cs331.msgr.hotmail.com:1863 ESTABLISHED
TCP bright:2202 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
TCP bright:2207 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
TCP bright:2360 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
TCP bright:2364 spc2-addl1-4-0-cust119.asfd.broadband.ntl.com:54116 ESTABLISHED
TCP bright:2896 baym-gw44.msgr.hotmail.com:http ESTABLISHED
TCP bright:3148 baym-gw27.msgr.hotmail.com:http ESTABLISHED
果然显示1521端口被占用,而且是被msn占用!害人不浅
将listener端口改成1522,然后重新启动listener,果然起来了!将msn关掉,然后将listener端口改回1521,也起来了,看来就是端口被占用造成的!!
呵呵,真是什么怪事都有,还第一次碰到端口被msn占用而listener无法起来的事情,瑾此为记,以做纪念