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

From: Phillip Jones <phil_at_phillip.im>
Date: Tue, 29 Oct 2013 22:01:16 +0000
Message-ID: <CAOyzJuexENBmLOOYpVGT67qKm34N5FKaWrb0Ddkvo1bf-1Uq-g_at_mail.gmail.com>

Hi,
Whenever I've seen things like this in the past they've been firewall timeouts.

Cheers,

Phil

On Tue, Oct 29, 2013 at 9:10 PM, Radoulov, Dimitre <cichomitiko_at_gmail.com>wrote:

> Hi all,
>
> Oracle database 10.2.0.4 EE
> Sun OS 5.10
>
> Getting "ORA-12592: TNS:bad packet" upon MV refresh 4 - 5min after
> executing the code:
>
> begin
> dbms_mview.refresh (
> list => '<mv_name>',
> method => 'c',
> atomic_refresh => false
> );
> end;
> /
>
> 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
>
> 100% reproducible. The underling query runs without error.
>
>
>
> The network guys say "no problem on the network side".
> Next step -> SR, in the mean time, any ideas?
>
>
> Thanks
> Dimitre
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Oct 29 2013 - 23:01:16 CET