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

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 30 Oct 2013 00:11:57 +0100
Message-ID: <527040BD.3070303_at_gmail.com>

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.
>>
>
> 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

Wait! I tried to re-execute the code and right now (midnight CEST) the remote database is not accessible:

ERROR at line 1:
ORA-04052: error occurred when looking up remote object <edit>

ORA-00604: error occurred at recursive SQL level 2
ORA-12541: TNS:no listener
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

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.

Thanks again!
Dimitre

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

Received on Wed Oct 30 2013 - 00:11:57 CET