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

How to drop index and before dropping it how to get the DDL.

PRVG-11250 : The check "RPM Package Manager database" was not performed because

How to troubleshoot Long Running Concurrent Request in EBS 12.2

ORA-00257:archiver error, connect internal only until freed

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

CPU Patch Analysis

How to write to a CSV file using Oracle SQL*Plus

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION