Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from puck1183.startdedicated.com (localhost [127.0.0.1])
 by puck1183.startdedicated.com (Postfix) with ESMTP id 86CD91960FF8
 for <oracle-l@orafaq.com>; Wed, 30 Oct 2013 07:02:00 +0100 (CET)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by puck1183.startdedicated.com (Postfix) with ESMTP
 for <oracle-l@orafaq.com>; Wed, 30 Oct 2013 07:02:00 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B19026EE1;
 Wed, 30 Oct 2013 02:01:59 -0400 (EDT)
Authentication-Results: turing.freelists.org; dkim=fail
 (verification failed; insecure key) header.i=@gmail.com;
 dkim-adsp=none (insecure policy)
X-Virus-Scanned: Debian amavisd-new at turing.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id ENHKn+dU75M9; Wed, 30 Oct 2013 02:01:59 -0400 (EDT)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6DBF926EB7;
 Wed, 30 Oct 2013 02:01:17 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 30 Oct 2013 02:00:36 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 438D026D1C
 for <oracle-l@freelists.org>; Wed, 30 Oct 2013 02:00:35 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id NSb-U7dtVMjp for <oracle-l@freelists.org>;
 Wed, 30 Oct 2013 02:00:35 -0400 (EDT)
Received: from mail-ea0-f174.google.com (mail-ea0-f174.google.com [209.85.215.174])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E6C6126221
 for <oracle-l@freelists.org>; Wed, 30 Oct 2013 02:00:34 -0400 (EDT)
Received: by mail-ea0-f174.google.com with SMTP id z15so380727ead.19
        for <oracle-l@freelists.org>; Tue, 29 Oct 2013 23:00:33 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=message-id:date:from:user-agent:mime-version:to:cc:subject
         :references:in-reply-to:content-type:content-transfer-encoding;
        bh=nNsCYbR1jSb0i6/U+t54ZdfZZp4g8gqLjwiw1se1k2U=;
        b=R290Ja8/ytWSlHDdsR8NwhDrJuzDMYdXaVYYCXm2NFvV9NmJ59R87/yqBYVZCiO1/P
         AuHHnC0gK5f6it9f2WhhYG75AukrW/X7Ltj51emtHaCA9/xKw8QOaYLB3e3PdqAGai8i
         hHVA38227Xc675rxTdnSHIbdERMig+fINKWckGR6Un2Sll5gnulCjyEfqVzqcQaNQxUF
         38b+NDJNo2mcmW3X7GfNFKGWo+/JYrZtiPX6FRYB4bZlns5nQzEkEn6ZAk0Jn2PUkiF6
         ZCxp+EPoxUAkvXKvWDMEBjZ7V/QCAcNaWiw9vwh2Xg7VvKw11ocOxmaLVnEqmOS0SyNg
         LNcA==
X-Received: by 10.15.101.3 with SMTP id bo3mr560996eeb.77.1383112833855;
        Tue, 29 Oct 2013 23:00:33 -0700 (PDT)
Received: from [192.168.0.2] (dynamic-adsl-94-36-128-243.clienti.tiscali.it. [94.36.128.243])
        by mx.google.com with ESMTPSA id h45sm79183097eeg.5.2013.10.29.23.00.32
        for <multiple recipients>
        (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
        Tue, 29 Oct 2013 23:00:33 -0700 (PDT)
Message-ID: <5270A07F.1080905@gmail.com>
Date: Wed, 30 Oct 2013 07:00:31 +0100
From: "Radoulov, Dimitre" <cichomitiko@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: Paul Drake <bdbafh@gmail.com>, Phillip Jones <phil@phillip.im>
CC: Hans Forbrich <fuzzy.graybeard@gmail.com>, =?UTF-8?B?T1JBQ0xFLUzvu7/vu78=?=
 =?UTF-8?B?77u/77u/?= <oracle-l@freelists.org>
Subject: Re: ORA-12592: TNS:bad packet on MV refresh
References: <5270243D.9020704@gmail.com>	<CAOyzJuexENBmLOOYpVGT67qKm34N5FKaWrb0Ddkvo1bf-1Uq-g@mail.gmail.com>	<5270328E.2090801@gmail.com>	<52703516.2080409@gmail.com> <CAPptggUJMUGA3VKDCk6wTYp4nqERxPSxkaXss-=OH0ExLnJmng@mail.gmail.com> <52703E43.7070803@gmail.com> <527040BD.3070303@gmail.com>
In-Reply-To: <527040BD.3070303@gmail.com>
Content-type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-archive-position: 51195
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: cichomitiko@gmail.com
Precedence: normal
Reply-To: cichomitiko@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l

On 30/10/2013 00:11, Radoulov, Dimitre wrote:
> On 30/10/2013 00:01, Radoulov, Dimitre wrote:
>> On 29/10/2013 23:25, Paul Drake wrote:
>>>
>>> Try "1" for sqlnet expire time. Other values are known not to work.
[...]
> I suppose they run a cold backup or some other maintenance task now 
> ... :)
> I hope that Phil (firewall timeout) and Paul (expire_time = 1) are right,
> there could be another, somehow more "aggressive" firewall on the 
> remote side.
>
> I'll try again tomorrow and let you know.

Hi,
rerun the refresh again, sqlnet expire time 1 doesn't seem to help:

ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-12592: TNS:bad packet
ORA-02063: preceding line from <edit>
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 2


Elapsed: 00:04:34.88


Thanks
Dimitre
--
http://www.freelists.org/webpage/oracle-l