首页 > 数据库 > Oracle > 物化视图 链路 ora-12570
今天做一个链路,开始增加了几个快照很正常。
然而再去增加,死活链路不通了。CONN 一直挂那了,最后出一个大概是TNS PACK错误
而在笔记本上仍可以正常连接。很不平。
NETCA重新配了一把TNS和NAMES。链路又正常可用了。
没有找出问题在哪,烦哪。
[@more@]省局故障现象:连接远程数据库时,报12570错误
ORA-12570: TNS: 包阅读程序失败
环境:省局端hp-ux 11i oracle9i RAC 做为客户端
市局端red-flag 4 oracle9i RAC 做为服务端
当然两端都有防火墙
在省局端增加了到市局端的tnsnames项目kfrkxx
操作过程如下:
HNGADB1$ id
uid=200(oracle) gid=300(dba)
HNGADB1$ ping 10.57.152.241
PING 10.57.152.241: 64 byte packets
64 bytes from 10.57.152.241: icmp_seq=0. time=2. ms
64 bytes from 10.57.152.241: icmp_seq=1. time=2. ms
64 bytes from 10.57.152.241: icmp_seq=2. time=2. ms
64 bytes from 10.57.152.241: icmp_seq=3. time=2. ms
----10.57.152.241 PING Statistics----
4 packets transmitted, 4 packets received, 0% packet loss
round-trip (ms) min/avg/max = 2/2/2
HNGADB1$
HNGADB1$ tnsping kfrkxx
TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 17-OCT-2008 09:39:20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.57.152.241)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
HNGADB1$
HNGADB1$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 17 09:39:29 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn aa/aa@kfrkxx
到此处,一直等待,没有响应,数分钟后报ORA-12570错误
TNS-12570 TNS:packet reader failure
Cause: An error occurred during a data receive.
This message is not normally visible to the user.
Action: For further details, turn on tracing and re-execute the operation.
If the error persists, contact Oracle Support Services.
如此的故障时好时坏,找不到规律。
后到google上翻腾,有8i的先例,又夹杂windows操作系统,不符合。例是有一博文上的案例与此类似。他的解决方法很简单,更新了防火墙软件。
难道与数据库无关?
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/271063/viewspace-1011982/ ,如需转载,请注明出处,否则将追究法律责任。