TNS-12542 TNSaddress already in use

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博客 ” ，链接：http://blog.itpub.net/678020/viewspace-1043717/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/678020/viewspace-1043717/