Error while export using expdp
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Error while export using expdp

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339

    Error while export using expdp

    Hi All,

    We are getting the below error while doing EXPDP kindly some one suggest.

    ORA-39127: unexpected error from call to export_string :=SYS.LT_EXPORT_PKG.schema_info_exp('SYS',1,1,'10.02.00.00.00',newbloc
    k)
    ORA-04031: unable to allocate 46640 bytes of shared memory ("shared pool","LTADM","PL/SQL MPCODE","BAMIMA: Bam Buffer")
    ORA-06508: PL/SQL: could not find program unit being called: "SYS.LTADM"
    ORA-06512: at "SYS.LT_EXPORT_PKG", line 843
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_METADATA", line 5419
    Thanks/Gopu

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    seems streams_pool_size is small.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    right now it is 12M, how much would you suggest to increase ?

    SQL> sho parameter streams_pool_size ;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    streams_pool_size big integer 12M
    Last edited by gopu_g; 10-08-2009 at 03:14 AM.
    Thanks/Gopu

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    16M will be good.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Hi Vijay,


    Thanks for the suggestion...
    Since this is a production database, before making the changes i wanna confirm this.
    Can you explain me that how this error is related to "streams_pool_size"
    Last edited by gopu_g; 10-08-2009 at 03:28 AM.
    Thanks/Gopu

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Hi Gopu,

    this error usually comes if you are using streams and streams pool size is small. I had the same issue around a month back and resolved it by increasing the streams_pool_size.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  7. #7
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Thanks for the answer....Good one.

    I had google it and sharing with u the answer i got.
    -------------------------------------------------

    Oracle Data Pump uses Streams functionality to communicate between processes. If the SGA_TARGET initialization parameter is set, then the STREAMS_POOL_SIZE initialization parameter is automatically set to a reasonable value.

    If the SGA_TARGET initialization parameter is not set and the STREAMS_POOL_SIZE initialization parameter is not defined, then the size of the streams pool automatically defaults to 10% of the size of the shared pool.

    When the streams pool is created, the required SGA memory is taken from memory allocated to the buffer cache, reducing the size of the cache to less than what was specified by the DB_CACHE_SIZE initialization parameter. This means that if the buffer cache was configured with only the minimal required SGA, then Data Pump operations may not work properly. A minimum size of 10M is recommended for STREAMS_POOL_SIZE in order to ensure successful Data Pump operations.
    Thanks/Gopu

  8. #8
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks for sharing Gopu. Please update if this change resolved your issue or not.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  9. #9
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Sure vijay, for that it will take some 2-3 days, we have to get the approval from the Top GUYS . I will let you know Once it is done.
    Once more thanks for your quick support.
    Thanks/Gopu

Posting Permissions

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



Click Here to Expand Forum to Full Width