RE: Error during impdp.

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 6 Nov 2012 05:21:13 -0500
Message-ID: <02d601cdbc08$7338e080$59aaa180$_at_rsiz.com>



I see your version information IS there. I should put a filter on my fingers before I drink my coffee.

I hope my other comments helped.

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Tuesday, November 06, 2012 5:11 AM To: NishaMohan_A_at_infosys.com; oracle-l_at_freelists.org Subject: RE: Error during impdp.

From the error message stack it appears you are getting a shared memory allocation error. At a glance I'm not sure whether that is in your instance or the ASM instance.

Without your version and patch details it is impossible to know whether some bugs may apply (6224011 and 8813366 are possibilities), or whether you simply do not have enough shared pool available.

The possibilities are wide ranging. Is ASM still available for other sessions? You could simply have too little memory in the ASM configuration, or it could be some complicated subpool issue with a high CPU count.

Figuring out *where* (which instance) you are running out of shared_pool to allocate and *why* I would think is your next step.

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nisha Mohan
Sent: Tuesday, November 06, 2012 12:43 AM To: oracle-l_at_freelists.org
Subject: Error during impdp.

Hi ,
I am facing the following error during impdp .Mine is a 2 node RAC of version 11.2.0.3 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 ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended 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***

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 06 2012 - 11:21:13 CET

Original text of this message