Home » RDBMS Server » Server Utilities » expdp error
expdp error [message #278325] Sat, 03 November 2007 00:35 Go to next message
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 #278426 is a reply to message #278325] Sun, 04 November 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

ORA-04031: unable to allocate 32 bytes of shared memory ("streams pool",

Do you have Streams in use?
Anyway, this error comes becomes streams pool is too small (or fragmented but I doubt about this). Enlarge this pool.
If you don't use Streams, set streams_pool_size to 0.

Regards
Michel

Re: expdp error [message #278530 is a reply to message #278426] Sun, 04 November 2007 22:42 Go to previous messageGo to next message
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 #278532 is a reply to message #278530] Sun, 04 November 2007 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Increase sga_target and streams_pool_size with scope=spfile and restart the instance.

Regards
Michel
Re: expdp error [message #278536 is a reply to message #278325] Mon, 05 November 2007 00:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel , I think restart is not necessary. There will be immediate affect.
Re: expdp error [message #278548 is a reply to message #278536] Mon, 05 November 2007 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't increase sga_target over sga_max_size without a restart.

By the way, shiju_t_v, if you set sga_max_size (that is if it is not calculated by Oracle), you have to also increase it.

Regards
Michel
Re: expdp error [message #278549 is a reply to message #278532] Mon, 05 November 2007 01:03 Go to previous messageGo to next message
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 #278553 is a reply to message #278325] Mon, 05 November 2007 01:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check permission in the directory.
Re: expdp error [message #278558 is a reply to message #278549] Mon, 05 November 2007 01:18 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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
Previous Topic: Import undo
Next Topic: During Import Err
Goto Forum:
  


Current Time: Tue Dec 24 23:46:18 CST 2024