一次奇怪的TNS-00516错误–MSN跟Oracle Listener端口冲突!

今天在自己电脑上手工启动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:\>netstatActive 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: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: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无法起来的事情,瑾此为记,以做纪念