Tuesday, September 11, 2012

TNS-12542: TNS Address already in use

While starting the Oracle DB 11g listener I am getting the error TNS-12542. Check the below screenshot.

The DB services are running in VM and network setting is applied as NAT. It was working all while until today so I verified the ip address and noticed that it is changed.
So I updated the /etc/hosts file with correct IP address and started the listener without any hiccups :)