[9i] Not enough large pool during export

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Volker Zink
    #1

    [9i] Not enough large pool during export

    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-Bibliotheksname n
    .. 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_ma ke_sub2","ioc_a llocate_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
    Tags: None
    • Steve
      #2
      Re: [9i] Not enough large pool during export

      Volker.Zink@por abo.ch (Volker Zink) wrote in message news:<fd05ec4d. 0408200444.3989 1230@posting.go ogle.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-Bibliotheksname n
      . 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_ma ke_sub2","ioc_a llocate_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

        Comment

        • Volker Zink
          #3
          Re: [9i] Not enough large pool during export

          steve_germany@y ahoo.de (Steve) wrote in message news:<7003c5c8. 0408241120.6d52 200b@posting.go ogle.com>...
          Volker.Zink@por abo.ch (Volker Zink) wrote in message news:<fd05ec4d. 0408200444.3989 1230@posting.go ogle.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-Bibliotheksname n
          . 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_ma ke_sub2","ioc_a llocate_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

            Comment

            Previous template Next
            Working...