How can I solve Got minus one of oracle sql developer to read?

Question

When I launched the sql developer and installed all the data, click the connection, but I get this error:

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

I am new to Oracle, how can I solve this error?
my windows: 7 64 bit and oracle 12c

Answer 1

You need to set " tcp.validnode_checking = no" or comment on this parameter in the sqlnet.ora file, then restart the listener on the db server and check again.

Give it a try.

Answer 2

I have the same problem, but the following steps worked for me, it seems Gaurav has already shared it:

 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 product\11.2.0("your databse version")\dbhome_1\NETWORK\ADMIN 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. 

Answer 3

Of your entries in the dialog box, you are using port 5500. This port is used for EM Express. It only responds to HTTP traffic. Therefore, in this case, the -1 error message means that protocol negotiation has not been completed. SQLDEV is trying to talk SQL * NET with something while listening to HTTP.

The port you are looking for is 1521 if it has not been changed. If it was the number $ ORACLE_HOME / network / admin / listener.ora for the correct port number.

Answer 4

Try Connection name: HR_ORCL Username: HR, Password: hour, Connection type: local, Role: SYSDBA Click on the connection. He will work.

Answer 5

It seems you have activated the ACL on the listener.

You can follow these steps to avoid an error:

 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. 

Hope that helps

Answer 6

Actually, this is not a specific database problem. this is due to the port value created by the database during installation. To overcome this problem, please follow below.

• Go to the folder where you installed the database (for example: F: \ app)
• Here you can see many folders, go to product \ 11.2.0 ("your version of the database") \ dbhome_1 \ NETWORK \ ADMIN
• find listener.ora file and open as text file
• Check the port number in this file
• Now specify the port number when connecting in the sql developer.

Hope this solves your problem.

Answer 7

Make sure the DB is running and you can connect AS SYSDBA locally to the database using the Oracle binary owner (usually oracle: oinstall Unix / Linux user). If this does not work, you may have encountered another problem. Check the permissions of the Oracle file on the Unix / Linux host where the database is running:

 cd $ORACLE_HOME/bin ls -ltr oracle -rwxr-xr-x 1 oracle oinstall 136803483 Mar 16 20:32 oracle 

Change the permissions as shown below:

 chmod 6751 oracle ls -ltr oracle -rwsr-s--x 1 oracle oinstall 136803483 Mar 16 20:32 oracle 

Answer 8

Try this: Got minus one of the read call. Sql Developer this works for me.

Answer 9

Most of the answers to this problem indicate the use of an invalid port number in the connection settings or similar. In my case, after a couple of hours of searching, the reason turned out to be something else.

Think about which user you are using when starting the Oracle listener. You must do this with the oracle user and not as the root user . Otherwise, you will receive listener files, for example, the root of the user deamon group instead of user oracle group dba. This in turn leads to:

 TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation Linux Error: 1: Operation not permitted 

To check if this is the case, go to

 /var/tmp/.oracle 

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

Unfortunately, sqldeveloper does not show the full stack trace when reading "Got minus one of the read calls." I could find the problem by switching to SQL protein.

Answer 10

Try linking or checking permissions on listener directories, or use the / dbhome / bin / relink all command