Have Geek Brain

Got a minus one from a read call

I am connecting to a read-only database using a SQL developer. This is a TNS connection. I am using tnsnames.ora, a script forwarding port and SQL Developer.

In the past, sometimes when connecting, I get the error Got minus one from a read call. Vendor code 0

If I restart, it disappears. Another friend suggested changing the forwarding port that worked for him.

I recently upgraded to a new computer and now it seems that I am getting the error consistently. Reloading or changing the forwarding port doesn't help at all.

The port forwarding script contains something like this

putty -L (port) :( machine name): 1521

Does anyone have any ideas? Thanks.

+2


a source to share


2 answers


My port forwarding script is forwarding multiple ports. Somehow separating them into 2 smaller files, this error went away.



+2


a source


Check the sqlnet.ora file and comment if there is any entry like the one below.

tcp.validnode_checking = yes

tcp.invited_nodes=(<hostname_1>, <hostname_2>)


Now reload your listener and check the connection from the SQL developer.

lsnrctl reload <SID>
0


a source






More articles:


All Articles