RE: expdp not working

We are getting following error when try to change this parameter
dynamically:
SQL> alter system set streams_pool_size=100M scope=both;
alter system set streams_pool_size=100M scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is
invalid
ORA-04033: Insufficient memory to grow pool

We are using 32 bit linux and have 32GB RAM, so we are not using
SGA_TARGET and explicitly set shared_pool to 2G and database_buffers to
8GB. Is there any way to set this parameter dynamically or I have to
shutdown the instance and modify the spfile?

-----Original Message-----
From: Richard J. Goulet [mailto:rgoulet@xxxxxxxxxx] 
Sent: Friday, January 26, 2007 12:35 PM
To: Harvinder Singh; oracle-l
Subject: RE: expdp not working

 I think the error at the very bottom of the stack says it all:

ORA-00832: no streams pool created and cannot automatically create one
    Cause: A database feature which needs STREAMS SGA was being used,
however, the streams_pool_size parameter was not defined and the value
of db_cache_size was too small to permit an automatic transfer of SGA to
the streams pool from the buffer cache.
    Action: Please set the parameter streams_pool_size or set
sga_target.


 
Dick Goulet, Senior Oracle DBA

45 Bartlett St  Marlborough, Ma 01752, USA
Tel.: 598.573.1978 |Fax:  508.229.2019 | Cell:508.742.5795

RGoulet@xxxxxxxxxx

: POWERING TRANSFORMATION 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
Sent: Friday, January 26, 2007 11:31 AM
To: oracle-l
Subject: expdp not working

Hi,

We are getting the following error while running expdp and I didn't
found munch information on this error on google, Did anyone saw this
error on their environment and what was the problem/solution?

S:\>expdp nm/nm@linux schemas=nm directory=backup_dir dumpfile=nm.dmp
logfile=nm.log

Export: Release 10.2.0.2.0 - Production on Friday, 26 January, 2007
11:19:30

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
- Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20070126111433" and
"KUPC$S_1_20070 126111433" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-00832: no streams pool created and cannot automatically create one

Environemnt: 10.2.0.1 on RHAT4

Thanks
--Harvinder

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: