listener.log 出现大量time out的问题 ora-3136

---

最初由 howard_zhang 发布
现在一个节点是这个错误RAC1
Wed Aug 8 13:49:19 2007
WARNING: inbound connection timed out (ORA-3136)
Wed Aug 8 13:49:19 2007
WARNING: inbound connection timed out (ORA-3136)
Wed Aug 8 13:49:19 2007
WARNING: inbound connection timed out (ORA-3136)
另外一个CONNECT不允许登陆的节点错误如下:RAC2
ARC1: Failed to archive thread 2 sequence 200 (19504)
Wed Aug 8 11:43:10 2007
ARC2: Failed to archive thread 2 sequence 200 (19504)
Wed Aug 8 11:43:10 2007
ARC3: Failed to archive thread 2 sequence 200 (19504)

---

关于ORA-3136,在metalink有如下的解决方案：
1.set INBOUND_CONNECT_TIMEOUT_ =0 in listener.ora
2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.
3. stop and start both listener and database.

其实listener做一下reload就可以了。

ARC1: Failed to archive thread 2 sequence 200 (19504)
这只是告警而已，可以忽略，关键要看一下正在archive 200的进程在等待什么？

这个问题也有可能是归档日志的目标满了!

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7916042/viewspace-937925/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7916042/viewspace-937925/