expdp error
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-lReceived on Fri May 12 2017 - 12:09:07 CEST