Oracle Errors TNS-12560: TNS:protocol adapter error TNS-00584: Valid node checking configuration error

Writing by shivdev on Friday, 3 of August , 2012 at 5:59 pm

It’s not surprising to me that after the pain of setting up Oracle, I would be running into further errors at random periods.

[oracle@sk-redhat bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 03-AUG-2012 10:44:45

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /home/oracle/OraHome11g/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.2.0 – Production
System parameter file is /home/oracle/OraHome11g/network/admin/listener.ora
Log messages written to /home/oracle/OraHome11g/log/diag/tnslsnr/sk-redhat/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=15.15.15.15)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00584: Valid node checking configuration error

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

This time the fault was NOT on ORACLE issue, but rather the IT folks that had made some changes to the VMs and IP addresses etc. and my Invited nodes were not being recognized.
Check whether the entries in the following files are correct.

[oracle@sk-redhat bin]$vi /home/oracle/OraHome11g/network/admin/sqlnet.ora
[oracle@sk-redhat bin]$ su root
[root@sk-redhat bin]$ vi /etc/hosts

Ensure that IP Addresses and Hostnames and respective mappings are all accurate and everything is reachable.

Leave a comment

Category: Tips and Tricks

• Add this post to
• Del.icio.us -
• Digg -
• -
• Tweet -

No comments yet.

You must be logged in to post a comment.