Re: ORA-12592: TNS:bad packet on MV refresh

From: Radoulov, Dimitre <>
Date: Wed, 30 Oct 2013 00:01:23 +0100
Message-ID: <>

On 29/10/2013 23:25, Paul Drake wrote:
> Try "1" for sqlnet expire time. Other values are known not to work.

Thanks! With SQLNET.EXPIRE_TIME = 1 the error is different:

ERROR at line 1:

ORA-12008: error in materialized view refresh path
ORA-02068: following severe error from
ORA-03113: end-of-file on communication channel
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:05:05.40

So now it's "end-of-file on communication channel" after 5 minutes. Note that I reported the complete error message, it really says: "following severe error from"m the database link name is missing.

>>> Are 'you' using Jumbo frames anywhere in the path?

No Jumbo frames in this network path.

Thank you all!


Received on Wed Oct 30 2013 - 00:01:23 CET

Original text of this message