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.

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
Received on Wed Oct 30 2013 - 07:00:31 CET

Original text of this message