Status : Test failed: IO Error: Got minus one from a read call, connect laps 3 sec...authentication laps 0 ms.

This document describes how to fix database connectivity issue when we try to connect database using sql developer.

Error: Status : Test failed: IO Error: Got minus one from a read call, connect laps 3 sec...authentication laps 0 ms.

Cause and Solution:

tcp.validnode_checking is set to yes in sqlnet.ora is causing the issue in standalone database. Set the value to no and bounce the listener. Retest the issue.

[oracle@ebsdb PROD_ebsdb]$ cat sqlnet.ora
###############################################################
#
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#
#$Header: NetServiceHandler.java 120.28.12020000.4 2013/12/04 10:30:05 sbandla ship $
#
###############################################################

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = no
tcp.invited_nodes=(EBSDB.apps.com, EBSAPPS.apps.com)
SQLNET.INBOUND_CONNECT_TIMEOUT =60
DIAG_ADR_ENABLED=ON
ADR_BASE=/u01/app/oracle/11.2.0/admin/PROD_ebsdb
SEC_USER_AUDIT_ACTION_BANNER = /u01/app/oracle/11.2.0/appsutil/template/txkDBSecUserAuditActionBanner.txt


Reload the listener:

[oracle@ebsdb PROD_ebsdb]$ lsnrctl reload PROD

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-SEP-2018 12:51:56

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebsdb.apps.com)(PORT=1521)))
The command completed successfully

[oracle@ebsdb PROD_ebsdb]$

Retest the issue:

Thanks for your patience to view this post.....................