oracle 从阅读电话中得到了一个减号
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2824438/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Got a minus one from a read call
提问by sunyata
I connect to a database with read only access using SQL developer. It's a TNS connection. I use a tnsnames.ora, forwarding port script and SQL Developer.
我使用 SQL 开发人员连接到具有只读访问权限的数据库。这是一个 TNS 连接。我使用 tnsnames.ora，转发端口脚本和 SQL Developer。
In the past, occasionally, when connecting, I get a error message Got a minus one from a read call. Vendor Code 0
过去，偶尔在连接时，我会收到一条错误消息，从读取调用中得到一个减号。供应商代码 0
If I do a reboot, it goes away. Another friend suggested changed the forwarding port which worked for him.
如果我重新启动，它就会消失。另一个朋友建议更改对他有用的转发端口。
I recently upgraded to a new computer and now it seems that I am getting the error message consistently. Reboot or changing forwarding port does not help at all.
我最近升级到了一台新计算机，现在似乎我一直收到错误消息。重新启动或更改转发端口根本没有帮助。
The port forwarding script contains something like this
端口转发脚本包含这样的内容
putty -L (port):(machine name):1521
Does anybody have any idea? Thanks.
有人有任何想法吗？谢谢。
回答by sunyata
My port forwarding script forwards multiple ports. Somehow separating them into 2 smaller file, this error went away.
我的端口转发脚本转发多个端口。不知何故将它们分成 2 个较小的文件，这个错误就消失了。
回答by ARGStackOvaFlo
Check your sqlnet.ora file and comment if there is any entry like the below.
检查您的 sqlnet.ora 文件并评论是否有任何如下所示的条目。
tcp.validnode_checking = yes
tcp.invited_nodes=(<hostname_1>, <hostname_2>)
Now reload your listener and check the connectivity from SQL Developer.
现在重新加载您的侦听器并检查来自 SQL Developer 的连接。
lsnrctl reload <SID>
