ORA-12592: TNS:bad packet on MV refresh
Date: Tue, 29 Oct 2013 22:10:21 +0100
Message-ID: <5270243D.9020704_at_gmail.com>
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.
SQL trace:
WAIT #28: nam='SQL*Net more data from dblink' ela= 1502827 driver
id=675562835 #bytes=1 p3=0 obj#=-1 tim=120596825715063
WAIT #28: nam='SQL*Net break/reset to dblink' ela= 38 driver
id=675562835 break?=1 p3=0 obj#=-1 tim=120596825715263
WAIT #28: nam='SQL*Net break/reset to dblink' ela= 49889 driver
id=675562835 break?=0 p3=0 obj#=-1 tim=120596825765231
WAIT #28: nam='direct path write' ela= 3 file number=11 first dba=669504
block cnt=32 obj#=-1 tim=120596825765613
EXEC
#28:c=19580000,e=245790469,p=0,cr=1760,cu=36671,mis=0,r=0,dep=1,og=1,tim=120596825779551
ERROR #28:err=12592 tim=3759180367
Oracle*Net trace:
[000002 29-OCT-2013 19:26:37:945] nioqrc: found a break marker...
[000002 29-OCT-2013 19:26:37:945] nioqrc: Recieve: returning error: 3111
[000002 29-OCT-2013 19:26:37:945] nioqrc: exit
[000002 29-OCT-2013 19:26:37:945] nioqrs: entry
[000002 29-OCT-2013 19:26:37:945] nioqrs: state = interrupted (1)
[000002 29-OCT-2013 19:26:37:945] nscontrol: entry
[000002 29-OCT-2013 19:26:37:945] nscontrol: cmd=1, lcl=0x0
[000002 29-OCT-2013 19:26:37:945] nscontrol: normal exit
[000002 29-OCT-2013 19:26:37:945] nioqrs: state = interrupted (1)
[000002 29-OCT-2013 19:26:37:945] nioqrs: nioqrs: sending reset marker...
[000002 29-OCT-2013 19:26:37:945] nioqsm: entry
[000002 29-OCT-2013 19:26:37:945] nioqsm: Sending reset packet (2)...
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-lReceived on Tue Oct 29 2013 - 22:10:21 CET