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.






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

Post a Comment

Popular posts from this blog

Error processing request - Contact your application administrator apex 20.1

APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter (R12 12.1.3)

WEB ADI - issues encountered during initial access