Hello everyone. I am trying to do a data pump export of my Oracle 11.1.0.6 database, and I am running into a few hurdles. When I try and kick off the export, I get this error:
oracle@cpscsdbp11:~> expdp username/password DIRECTORY=DATA_PUMP_DIR DUMPFILE=full_cipca1c_database.dmp LOGFILE=full_cipca1c_exp.log FULL=YES;
Export: Release 11.1.0.6.0 - 64bit Production on Monday, 06 November, 2017 14:43:02
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
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 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line 1
When I check the alert log, I see streams_pool_size errors:
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
Here are my current database parameters (it's a small production database):
SQL> show parameter target
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 24M
sga_target big integer 244M
SQL> show parameter pool
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
global_context_pool_size string
java_pool_size big integer 0
large_pool_size big integer 0
olap_page_pool_size big integer 0
shared_pool_reserved_size big integer 12163481
shared_pool_size big integer 232M
streams_pool_size big integer 0
If I try and increase the streams_pool_size, I get the insufficient memory error:
SQL> alter system set streams_pool_size=48M;
alter system set streams_pool_size=48M
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
Does anyone have any ideas? Thanks so much everyone.