Re: ORA-12592: TNS:bad packet on MV refresh
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 30 Oct 2013 00:01:23 +0100
Message-ID: <52703E43.7070803_at_gmail.com>
On 29/10/2013 23:25, Paul Drake wrote:
>
> Try "1" for sqlnet expire time. Other values are known not to work.
>
Date: Wed, 30 Oct 2013 00:01:23 +0100
Message-ID: <52703E43.7070803_at_gmail.com>
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:
begin
*
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!
Regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 30 2013 - 00:01:23 CET