got minus one from a read call

I got the same issue but following steps worked for me, it seems Gaurav also has shared it already:

From your inputs in the dialog, you are using port 5500. That port is what is used for EM Express. It answers to HTTPs traffic only. So in this case the -1 error message means the protocol negotiation failed. SQLDEV is trying to talk SQL*NET to something listening for HTTPs.

The port you are looking for is 1521 if it wasn’t altered. If it was check the $ORACLE_HOME/network/admin/listener.ora for the proper port number.

Try Connection name: HR_ORCL Username: HR , Password: hr , Connection type : local, Role: SYSDBA Click on connect. It will work.

Seems you have enabled ACL on the listener.

You can follow these steps to avoid the error:

Hope that helps

Actually, It is not database specific issue. it is related to port value generated by database during your installation. To overcome on this issue, please follow below.

1. Go to the folder where you have installed the database (Like: F:app)
2. Here you will be able to see many folders, go to product11.2.0(«your databse version»)dbhome_1NETWORKADMIN
3. find listener.ora file and open as text file
4. Check for the port number in that file
5. Now provide that port number while doing connection in sql developer.

Hope it will resolve your issue.

Ensure the DB is up and running and you can connect locally AS SYSDBA to the database using Oracle binaries owner (usually oracle:oinstall Unix / Linux user). If it does not work, probably you encounter a different problem. Check privileges of an Oracle file on Unix / Linux host where database is running:

Change permissions as below:

Most of the answers out there for this problem point to using the wrong PORT number in your connection options, or similar. In my case, after a couple hours of searching, the reason showed to be something else.

Mind which user you are using when starting Oracle listener. You should do it with the oracle user, not as root. Otherwise you end up with listener files being created as e.g. user deamon group root instead of user oracle group dba. This in turn leads to:

To check whether this is the case, go to

and list all files (ls -la). If you find out some of the s#* files being created by a root-group user, stop the listener (lsnrctl stop), delete the above files as root and restart the listener as oracle user.

Unfortunately sqldeveloper doesn’t show the full stack-trace when reading «Got minus one from a read call». I could find the problem thanks to switching to SQL-Squirrel.

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 >

Attempting to connect to a database via SQL Developer throws the error when testing or attempting to use the 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:

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:

I setup a DB cloud instance but now I can’t connect to it using SQL Developer.

I setup the SSH connection in SQL Developer + port forwarding and I test that connection successfully.

But when I try to create a connection, I always get this error:

«STATUS: Failure — Test Failed: I/O error: Got minus one from read call, connect lapse XX ms, Authentication lapse 0 ms.»

Источник: computermaker.info