Friday, 22 April 2011

Io Error: Got minus one from a read call

When trying to connect using oracle sqldeveloper this error messages is thrown. I came across this error two times, on each occasion different cause.

1)  Make sure you are connecting to the correct port, wrong port also gives the error above.


2) This is happening becuase oracle is using ACL (access control list) where only authorised clients are given access.

check sqlnet.ora file ($ORACLE_HOME/network/admin)

tcp.validnode_checking = yes
tcp.invited_nodes=(ORACLE11I.mylearn.com)


we can either disable this checking

tcp.validnode_checking = no

or add the node in the acl.

tcp.invited_nodes=(ORACLE11I.mylearn.com,192.168.1.14)


bounce the listener and try connecting again

if oracle apps is using use addlnctl script to bounce it.






6 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. good advice
    although, in my case i just simply didnt connect to correct port
    by some reason used the 8080 port not 1521, because when opening the database app, it tried to open http://127.0.0.1:8080 addess.

    good luck and thanks!

    ReplyDelete
    Replies
    1. I came across the one you mentioned also today. Thank you very much.

      Keep sharing :)

      Delete
  3. Its Helped me as well...thanks very much

    ReplyDelete
  4. Thank you very much for this article, it is so rare to see nowadays written as fervently article. I enjoyed reading it and I learned a lot of things. I will go and continue reading your blog =). Good luck for the future and another one for the quality of it.You can also check out this (http://www.sqiar.com).

    ReplyDelete