Monday, 31 August 2015

TNS-12545 TNS-12560 TNS-00515 Linux Error: 99: Cannot assign requested address

Listener was not able to create or registered

Getting below error in the listener.log trace.

Error:
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/SIDPRD01/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 99: Cannot assign requested address

Listener failed to start. See the error message(s) above...

Solution:
Check the ipadress of the server by running

ifconfig -a

Check the host file(cat /etc/hosts) with proper entry of host-name and IP.

In my case the ip address with hostname is wrong in the host file after fixing the /etc/hosts file with proper IP and host-name. I am able to create the listener.

1 comment:

Unknown said...

Hi,
Thank you for posting your error, i have got the same error, i saw your post.I tried what you did,now it is working.Thank u