How to fix Oracle SQL Developer connection issue "Got minus one from a read call"

 During connection from SQL Developer to EBS database got below error message:


Status : Failure -Test failed: IO Error: Got minus one from a read call



Following solution can be done :
1. Go to directory $ORACLE_HOME/network/admin
2. Modify sqlnet.ora file with following parameter: 
tcp.validnode_checking = no

3. If you don't want to disable this, you can put the machine names as follows:
tcp.invited_nodes=(machine1, machine2)

3. Bounce the listener.

Due to security enhancements it is not good to put tcp.validnode_checking = no or comment out will through error 
when we start listener like below:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shsebs7idb1.appsolworld.com)(PORT=1522)))
TNS-00584: Valid node checking configuration error
 TNS-12560: TNS:protocol adapter error

Better plan is to add localhost or IP address of client (Local Computer) in the sqlnet.ora file
That will solve the problem

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10 tcp.validnode_checking = yes tcp.invited_nodes=(192.168.1.3,SHSEBS7IDB1.appsolworld.com) SQLNET.INBOUND_CONNECT_TIMEOUT =60 SQLNET.ALLOWED_LOGON_VERSION_SERVER=8






Comments

Popular posts from this blog

Few Important steps of Oracle Database Clone

How to autopopulate user_guid in fnd_user table ( EBS Blank Page)