By Kabeer Khan on Saturday, 27 December 2014
Category: Apps DBA

status failure - test failed io error got minus one from a read call SQL Developer

Error Description 

status failure - test failed io error got minus one from a read call, while connecting to Oracle EBS Database from SQL Developer

Root Cause of the Issue

SQL Net is not allowing connections to the database because of the setting 'tcp.validate_node' is set as 'yes'.

Resolution

1. Open sqlnet.ora

2. Change the setting to:

tcp.validate_node = no

3. Now try reconnecting to the database from SQL Developer and you should be able to connect it successfully this time.

Environment

Leave Comments