Re: [Solved] ORA-12592: TNS:bad packet on MV refresh

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: Paul Drake <bdbafh@xxxxxxxxx>, Phillip Jones <phil@xxxxxxxxxx>
  • Date: Wed, 13 Nov 2013 22:01:35 +0100

On 30/10/2013 07:00, Radoulov, Dimitre wrote:
[...]
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

[...]

Hi all,
I just wanted to confirm that, as already mentioned by other posters here and by Oracle support, it was a firewall issue. The db link was passing though two firewalls on our side. We "removed" one of the firewalls from the network path and that fixed the problem.


Best regards
Dimitre
--
//www.freelists.org/webpage/oracle-l


Other related posts: