Re: Error during impdp.

From: Niall Litchfield <>
Date: Tue, 6 Nov 2012 10:47:38 +0000
Message-ID: <>

You'll probably want to read Note 437924.1 which covers shared pool sizing and ASM. In your version Oracle has started adjusting the value of the processes parameter based on the hardware you are running on. This results in ASM needing more memory than may be set. There's a formula at the bottom of the note for sizing shared_pool for ASM in, our experience however is that you want to allocate more memory than that calculation. We've settled on 1g of shared pool for 64bit servers with 12-16 intel cores. I haven't yet done enough investigation to determine the factors that influence shared pool usage in ASM (My shortlist is client process count, disk group count, disk group size, disk count, disk size)

On Tue, Nov 6, 2012 at 5:42 AM, Nisha Mohan <>wrote:

> Hi ,
> I am facing the following error during impdp .Mine is a 2 node RAC of
> version on Redhat Linux.Kindly help me.I have given read and write
> permission to public on my DB directory.
> ORA-31693: Table data object "FDC"." _HISTORY_TABLE" failed to load/unload
> and is being skipped due to error:
> ORA-29913: error in executing ODCIEXTTABLEFETCH callout
> ORA-01115: IO error reading block from file (block # )
> ORA-01110: data file 12: '+DATA1/mwdb/datafile/fdclht_01.dbf'
> ORA-15055: unable to connect to ASM instance
> ORA-15055: unable to connect to ASM instance
> ORA-04031: unable to allocate 760 bytes of shared memory ("shared
> pool","unknown object","KKSSP^1355","kglss")
> Thanks and Regards,
> Nisha Mohan.A
> **************** CAUTION - Disclaimer *****************
> solely
> for the use of the addressee(s). If you are not the intended recipient,
> please
> notify the sender by e-mail and delete the original message. Further, you
> are not
> to copy, disclose, or distribute this e-mail or its contents to any other
> person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys
> has taken
> every reasonable precaution to minimize this risk, but is not liable for
> any damage
> you may sustain as a result of any virus in this e-mail. You should carry
> out your
> own virus checks before opening the e-mail or attachment. Infosys reserves
> the
> right to monitor and review the content of all messages sent to or from
> this e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
> --

Niall Litchfield
Oracle DBA

Received on Tue Nov 06 2012 - 11:47:38 CET

Original text of this message