Oracle 客户端死死地等待
我昨天遇到一个问题。可能是因为今天是4月1日吧... 但它确实存在。
我在偏远地区有3台PC，两台客户端和一台oracle服务器。 我的应用程序在两个客户端中单独运行，每小时连接到 oracle 数据库。我的客户在 4 月 1 日之前运行良好，但突然我在客户端计算机上的应用程序崩溃了。
首先，我没有更改任何配置。我使用 libsqlora8 连接到服务器。我在图书馆陷入了死循环。我尝试了 sqlplus，但它在我的 shell 终端中死了，就像它遇到了无限循环：直到我按下 ctrl + c 才返回。我猜的原因是某个地方存在“无限循环”。
顺便说一句，当我使用本地电脑连接服务器时，效果很好。从这个现象就可以看出问题出在客户端机器上。我检查了本地计算机和客户端计算机中的配置文件 - 它们是相同的
您遇到过这样的问题吗？ 我希望这不是4月1日。
I meet a problem yesterday. Maybe it's because it is April 1st...
but it did exist.
I have 3 PCs in remote area, two clients and one oracle server.
My app is running separately in the two clients, connecting hourly to the oracle database. My clients worked well before April 1st, but suddenly my app in the client machines went down.
Firstly, I did not change any configurations. I used libsqlora8 to connect to the server. I went into a dead loop in the library. I tried sqlplus, but it is dead there in my shell terminal, like it meets an infinite loop: no return until i pressed ctrl + c. The reason I guess is an "infinite loop" somewhere.
BTW, when I used my local PC to connect the server, it worked well. Just from this phenomenon, we can see the problem lies in the client machine. I checked the configuration file both in local machine and client machines -they are identical
Have you met a problem like this?
I hope it's not due to April 1st.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
首先，一群颜色奇特的独角兽并没有冲进你的集群并破坏你的配置。因此，您的应用程序不太可能因为昨天是愚人节而失败。
那么，您的应用程序是否启用了一些日志记录或跟踪功能？如果是这样，日志文件中是否有任何内容？服务器的警报日志中是否有任何内容？或者转储目录中的其他跟踪文件？
当你说你可以从本地电脑连接时，你是如何连接的？ SQLPlus？您是否尝试过连接到服务器并从那里运行 SQL Plus？如果是这样，会发生什么？
First off, a herd of whismsically coloured unicorns did not stampede through your cluster and trash your configuraation. So it is unlikely your application died because yesterday was April Fools' Day.
So, does your app have some logging or trace enabled? If so, is there anything in the logfiles? Is there anything in the server's Alert Log? Or other trace file in the dump directories?
When you say you could connect from your local PC how are you connecting? SQLPlus? Have you tried connecting to the server and running SQLPlus from there? If so, what happens?
最有可能的是，某些重要的表被锁定。您需要找到并终止锁的所有者会话。关于解决oracle锁的文章有很多。
此外，如果您安装了企业管理器数据库控制台，则可以使用它 - 在性能选项卡上，使用实例锁定或阻止会话链接。
Most likely, some important table is locked. You need to find and kill the owner session of the lock. There are numerous articles on resolving oracle locks.
Also, if you have an enterprise mananager DB Console installed, you can use it - on Performance tab, use Instance locks or Blocking sessions link.