expdp error [message #278325] |
Sat, 03 November 2007 00:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shiju_t_v
Messages: 56 Registered: May 2007 Location: kannur,kerala
|
Member |
|
|
When using expdp
expdp \'sys/admin as sysdba\' directory=data_pump_dir1 dumpfile=expfull.dmp logfile=expfull.log schemas=BANQUE;
i got the following error
Export: Release 10.2.0.1.0 - Production on Saturday, 03 November, 2007 10:52:28
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_02 for user SYS
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_20071103105229" and "KUPC$S_1_20071103105229" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-04031: unable to allocate 32 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
|
|
|
|
Re: expdp error [message #278530 is a reply to message #278426] |
Sun, 04 November 2007 22:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shiju_t_v
Messages: 56 Registered: May 2007 Location: kannur,kerala
|
Member |
|
|
When i Tried to set streams_pool_size , i was unable
[oracle@linuxserver1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 5 10:12:47 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/admin as sysdba;
Connected.
SQL> alter database set streams_pool_size = 10000 scope=BOTH;
alter system set streams_pool_size = 10000 scope=BOTH
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
================================================
My Initialization parameter file contains
sga_max_size=385212672
sga_target=385875968
shared_pool_size=113246208
streams_pool_size=0
db_block_size=8192
db_cache_size=159383552
|
|
|
|
|
|
Re: expdp error [message #278549 is a reply to message #278532] |
Mon, 05 November 2007 01:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shiju_t_v
Messages: 56 Registered: May 2007 Location: kannur,kerala
|
Member |
|
|
i update sga_target with 400875968 and
streams_pool_size with 15000 but in the spfile contains streams_pool_size = 4194304
why this happend ?
Then i issued this
expdp banque/banque directory=data_pump_dir1 dumpfile=expfull.dmp logfile=expfull.log schemas=BANQUE;
Export: Release 10.2.0.1.0 - Production on Monday, 05 November, 2007 12:37:31
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
why this happend
|
|
|
|
Re: expdp error [message #278558 is a reply to message #278549] |
Mon, 05 November 2007 01:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | streams_pool_size with 15000 but in the spfile contains streams_pool_size = 4194304
why this happend ?
|
Min size is a granule which is 4M in your case (but maybe 8M on Windows, or 16M when SGA raises a threshold).
For the other error verify the directory and oracle instance owner privileges on it.
Regards
Michel
|
|
|