RE: expdp not working

From: <oracle-l-bounce_at_freelists.org>
Date: Fri, 26 Jan 2007 13:35:58 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E02762@ex2003.metratech.com>

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_at_kanbay.com] 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_at_kanbay.com

: POWERING TRANSFORMATION
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
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_at_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

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 Received on Fri Jan 26 2007 - 12:35:58 CST