ITPub博客

首页 > 数据库 > Oracle > 物化视图 链路 ora-12570

物化视图 链路 ora-12570

原创 Oracle 作者:wmlm 时间:2008-10-16 22:32:14 0 删除 编辑

今天做一个链路,开始增加了几个快照很正常。

然而再去增加,死活链路不通了。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/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: SPFILE与RAW
请登录后发表评论 登录
全部评论

注册时间:2008-04-08

  • 博文量
    398
  • 访问量
    3716772