Issue
Error in starting DB Listener for Oracle EBS 12i Database
Error Description
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
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
Listener failed to start. See the error message(s) above...
Steps to Reproduce
Start the DB listener using the following command
$ lsnrctl start VIS
Solution
1. Check /etc/hosts file and make sure the IP address used for EBS domain is exactly the same as configured in listener.ora file. The listener.ora file will be located in this directory:
/u01/apps/<hostname>/db/tech_st/11.1.0/network/admin/<SID>_<hostname>/listener.ora
2. Make sure you are able to ping the IP address in the server you have installed Oracle DB and EBS
3. Once above issues have been fixed, then try restarting listener using below command at the terminal
$ lsnrctl start <SID name>
Environment