DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-4031 running export

  1. 11-12-2002, 05:55 AM #1
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141

    Unhappy ORA-4031 running export

    Hi all !

    Full database export fails with the following errors :

    . exporting default and system auditing options
    EXP-00008: ORACLE error 4031 encountered
    ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN:1 := "SYS"."DBMS_AQ_E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
    EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.audit_sysprivs_exp

    There was no changes in the system and everything worked fine until yesterday. Any ideas what is going on ?
    Thanks a lot in advance.
    Reply With Quote Reply With Quote
  2. 11-12-2002, 06:06 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    What version of the database are you running? there is a bug relating to this error which appears in 8.1.7 (fixed in 8.1.7.2 and above)

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 11-12-2002, 06:12 AM #3
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141
    It is the 8.1.7.0.0 release ...
    Is there any other solution than migrating to solve the problem ? Because it is quit urgent, we absolutly have to export the database today !
    Thanks a lot inf advance for your replies ...
    Reply With Quote Reply With Quote
  4. 11-12-2002, 06:34 AM #4
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    How about exporting individual schemas instead of exporting whole database. Though lengthy but I guess it should work...

    Sameer
    Reply With Quote Reply With Quote
  5. 11-12-2002, 06:44 AM #5
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141
    Unfortunatly, the full database export is a part of our everyday batch script, so we cannot rewrite it right now and we need to save the whole database and not only the database's schemas (including tablespace definition, roles, database links...).
    Reply With Quote Reply With Quote
  6. 11-12-2002, 08:43 AM #6
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141
    Does anyone has experienced the same problem ?
    Reply With Quote Reply With Quote
  7. 11-12-2002, 09:15 AM #7
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")

    Cause: More shared memory is needed than was allocated in the shared pool.

    Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.

    Does using what the action says help?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  8. 11-12-2002, 09:21 AM #8
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If the issue is related to the bug 1397603 then the following workaround will allow to to perform the export:

    add the following to your init.ora and bounce the db

    _db_handles_cached = 0

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  9. 11-12-2002, 09:42 AM #9
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141
    Thanks a lot for your advices ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width