DBA Notes: 2011/10/31
Cheng Li
ORA-12542: TNS: address already in use
This part gives a simple example how to resolve issue ORA-12542 found from alerts file.
ORA-12542: TNS:address already in use
Cause: Specified listener address is already being used.
Action: Start your listener with a unique address
In UNIX, the ORA-12542 error is an easy fix, just re-set the listener to run on a different port or add to the queue size for the listener in your listener.ora file.
listener=(address=
(protocol=tcp)
(host=myhost)
(port=2241)
(queuesize=60)
)
$ lsnrctl status
Check listener status
$ lsnrctl service
Check listener service
Reference:
http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm
http://space.itpub.net/3326/viewspace-607363
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26136400/viewspace-710013/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26136400/viewspace-710013/