dbTalk Databases Forums  

[9i] Not enough large pool during export

comp.databases.oracle comp.databases.oracle


Discuss [9i] Not enough large pool during export in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Volker Zink
 
Posts: n/a

Default [9i] Not enough large pool during export - 08-20-2004 , 07:44 AM






I have a problem with a 9i.2 database. During export i always get
following error (its in german):

....
.. Kontext-Namespaces werden exportiert
.. Exportieren der Fremdfunktions-Bibliotheksnamen
.. Synonyme vom Typ PUBLIC werden exportiert
EXP-00008: ORACLE-Fehler 4031 gefunden
ORA-04031: 4032 Bytes des gemeinsamen Speichers konnten nicht
zugewiesen werden ("large pool","unknown
object","ioc_make_sub2","ioc_allocate_pal")
EXP-00000: Der Export-Vorgang endete mit Fehlern

The export-command is

exp user/pw@db file=db.exp log=db.log full=y

The first time i saw the error i increased the large pool from 40M to
56M. Didn't help. I increased it even further to 104M
(shutdown/startup after the change included). Still i get the same
error during export. And always at the same line (Synonyme vom Typ
PUBLIC werden exportiert/Synonyms of type PUBLIC are being exported).
Fortunately this is not a production database. I have databases in
production with a large_pool_size of 56M and never had a problem with
export, even if they have large amounts of data compared to the
database which causes the problem.

So whats wrong? I assume its not the large pool.

Thanks

Volker

Reply With Quote
  #2  
Old   
Steve
 
Posts: n/a

Default Re: [9i] Not enough large pool during export - 08-24-2004 , 02:20 PM






Volker.Zink (AT) porabo (DOT) ch (Volker Zink) wrote in message news:<fd05ec4d.0408200444.39891230 (AT) posting (DOT) google.com>...
Quote:
I have a problem with a 9i.2 database. During export i always get
following error (its in german):

...
. Kontext-Namespaces werden exportiert
. Exportieren der Fremdfunktions-Bibliotheksnamen
. Synonyme vom Typ PUBLIC werden exportiert
EXP-00008: ORACLE-Fehler 4031 gefunden
ORA-04031: 4032 Bytes des gemeinsamen Speichers konnten nicht
zugewiesen werden ("large pool","unknown
object","ioc_make_sub2","ioc_allocate_pal")
EXP-00000: Der Export-Vorgang endete mit Fehlern

The export-command is

exp user/pw@db file=db.exp log=db.log full=y

The first time i saw the error i increased the large pool from 40M to
56M. Didn't help. I increased it even further to 104M
(shutdown/startup after the change included). Still i get the same
error during export. And always at the same line (Synonyme vom Typ
PUBLIC werden exportiert/Synonyms of type PUBLIC are being exported).
Fortunately this is not a production database. I have databases in
production with a large_pool_size of 56M and never had a problem with
export, even if they have large amounts of data compared to the
database which causes the problem.

So whats wrong? I assume its not the large pool.

Thanks

Volker
Hello Volker,
I found this in some older thread:

- increasing the JAVA_POOL_SIZE to the default one 20 mb

maybe you should try this

Steve


Reply With Quote
  #3  
Old   
Volker Zink
 
Posts: n/a

Default Re: [9i] Not enough large pool during export - 08-25-2004 , 04:29 AM



steve_germany (AT) yahoo (DOT) de (Steve) wrote in message news:<7003c5c8.0408241120.6d52200b (AT) posting (DOT) google.com>...
Quote:
Volker.Zink (AT) porabo (DOT) ch (Volker Zink) wrote in message news:<fd05ec4d.0408200444.39891230 (AT) posting (DOT) google.com>...
I have a problem with a 9i.2 database. During export i always get
following error (its in german):

...
. Kontext-Namespaces werden exportiert
. Exportieren der Fremdfunktions-Bibliotheksnamen
. Synonyme vom Typ PUBLIC werden exportiert
EXP-00008: ORACLE-Fehler 4031 gefunden
ORA-04031: 4032 Bytes des gemeinsamen Speichers konnten nicht
zugewiesen werden ("large pool","unknown
object","ioc_make_sub2","ioc_allocate_pal")
EXP-00000: Der Export-Vorgang endete mit Fehlern

The export-command is

exp user/pw@db file=db.exp log=db.log full=y

The first time i saw the error i increased the large pool from 40M to
56M. Didn't help. I increased it even further to 104M
(shutdown/startup after the change included). Still i get the same
error during export. And always at the same line (Synonyme vom Typ
PUBLIC werden exportiert/Synonyms of type PUBLIC are being exported).
Fortunately this is not a production database. I have databases in
production with a large_pool_size of 56M and never had a problem with
export, even if they have large amounts of data compared to the
database which causes the problem.

So whats wrong? I assume its not the large pool.

Thanks

Volker

Hello Volker,
I found this in some older thread:

- increasing the JAVA_POOL_SIZE to the default one 20 mb

maybe you should try this

Steve
That did the trick.

Thanks.

Volker


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.