ORA-12542: TNS: address already in use

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

Solution:

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

 

844da0bbta8be5f02ac19&690.jpg

844da0bbta8be5f11e89d&690.jpg

844da0bbta8be5f029f5a&690.jpg

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

转载于:http://blog.itpub.net/26136400/viewspace-710013/