Re: ORA-12592: TNS:bad packet on MV refresh
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 30 Oct 2013 07:00:31 +0100
Message-ID: <5270A07F.1080905_at_gmail.com>
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.
Date: Wed, 30 Oct 2013 07:00:31 +0100
Message-ID: <5270A07F.1080905_at_gmail.com>
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-lReceived on Wed Oct 30 2013 - 07:00:31 CET