SQL Developer – IO Error: Got minus one from a read call

The IO Error: Got minus one from a read call error is caused by the SQLNET.ora file on the database server being configured to only allow connections from certain computers on the network (as identified by their IP addresses).

Attempting to connect to a database via SQL Developer throws the error when testing or attempting to use the connection:

Screenshot-New - Select Database Connection

If the TCP.VALIDNODE_CHECKING parameter is enabled In the SQNET.ora file then the IP address of each computer allowed to connect to databases via the listener configured using that SQLNET.ora file will need to be added to the TCP.INVITED_NODES list.

Here is an example SQLNET.ora file with VALIDNODE_CHECKING enabled and one computer (with the IP address 192.168.1.101) granted access:

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

tcp.validnode_checking = YES

tcp.invited_nodes = (192.168.1.101)

There is an opposite parameter to TCP.INVITED_NODES; TCP.EXCLUDED_NODES will forbid access to those IP addresses configured in its list.

With the appropriate settings in place, SQL Developer should be able to connect as planned:

Screenshot-New - Select Database Connection-1

The SQLNET.ora settings effect other systems as well as SQL Developer – tools like Oracle Enterprise Manager can also throw the Got minus one from a read call error if the OEM server is not in the list of invited nodes!

Advertisements
SQL Developer – IO Error: Got minus one from a read call

One thought on “SQL Developer – IO Error: Got minus one from a read call

  1. Ivan J. says:

    FYI… I was getting the error by using port 5500, which was shown in the Database Config Assistant. When I changed it to 1521 (as shown here), the error went away and got a successful connection.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s