expdp error

From: nc5 <nc5_at_sanger.ac.uk>
Date: Fri, 12 May 2017 11:09:07 +0100
Message-ID: <2fc0b0c5-7dd1-b87e-198d-88cb46aa4d58_at_sanger.ac.uk>



We are getting an odd expdp error with an 11.2.0.4 Standard edition db on SLES 11.2

Basically after several years of nightly exports without issue, in the last few days exports are failing with

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

I have an SR open and have looked at a slew of MOS notes suggesting the STREAMS_POOL_SIZE could be implicated

A restored version on RHEL 7.2 shows the same issue and setting the STREAMS_POOL_SIZE to 1G fails to resolve. Additional info:
There are no invalid objects reported from dba_registry neither logtime or systimestamp are used in the parameter file (as per 1936319.1)
In test I have exec dbms_aqadm.drop_queue_table (queue_table => 'SYS.KUPC$DATAPUMP_QUETAB', force => TRUE); and recreated
and run utlrp.sql
all to no avail.

BANNER



Oracle Database 11g Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production

SQL> select * from v$sgainfo;

NAME                                  BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size                      2262656 No
Redo Buffers                       24088576 No
Buffer Cache Size                1325400064 Yes
Shared Pool Size                  570425344 Yes
Large Pool Size                   100663296 Yes
Java Pool Size                     83886080 Yes
Streams Pool Size                1073741824 Yes
Shared IO Pool Size                       0 Yes
Granule Size                       16777216 No
Maximum SGA Size                 5344731136 No
Startup overhead in Shared Pool   281155040 No
Free SGA Memory Available        2164260864

Knowing the considerable expertise of this list I just wanted to ask if anyone has encountered a similar issue recently?

thanks,
Norman

-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE. 
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 12 2017 - 12:09:07 CEST

Original text of this message