ITPub博客

首页 > 数据库 > Oracle > TNS-12542 TNSaddress already in use

TNS-12542 TNSaddress already in use

原创 Oracle 作者:liypsky 时间:2010-12-27 12:08:23 0 删除 编辑
TNSLSNR for Linux: Version 9.2.0.6.0 - Production on 27-DEC-2010 07:35:25

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /MIS/misdb/9.2.0/network/admin/MIS_erpcn/listener.ora
Log messages written to /MIS/misdb/9.2.0/network/admin/mis.log
Trace information written to /MIS/misdb/9.2.0/network/admin/mis.trc
Trace level is currently 0

Started with pid=1795
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCMIS))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use[@more@]TNSLSNR for Linux: Version 9.2.0.6.0 - Production on 27-DEC-2010 07:39:28

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /MIS/misdb/9.2.0/network/admin/MIS_erpcn/listener.ora
Log messages written to /MIS/misdb/9.2.0/network/admin/mis.log
Trace information written to /MIS/misdb/9.2.0/network/admin/mis.trc
Trace level is currently 0

Started with pid=2435
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCMIS))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

TNSLSNR for Linux: Version 9.2.0.6.0 - Production on 27-DEC-2010 08:12:14

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /MIS/misdb/9.2.0/network/admin/MIS_erpcn/listener.ora
Log messages written to /MIS/misdb/9.2.0/network/admin/mis.log
Trace information written to /MIS/misdb/9.2.0/network/admin/mis.trc
Trace level is currently 0

Started with pid=1501
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCMIS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpcn.sunled.com)(PORT=1523)))

解决方法:
1)查看Port占用情况
2)查看Host名称,或重新指定Listener.ora中的HOST
3)停用后重新启用Listener

命令补充:
1) arp -a 取得IP和MAC地址
2) nbtstat -A IP 取得计算机名称

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/678020/viewspace-1043717/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    93
  • 访问量
    325153