RE: Error during impdp.
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Nov 2012 05:21:13 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mark W. Farnham
Sent: Tuesday, November 06, 2012 5:11 AM
To: NishaMohan_A@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Nisha Mohan
Sent: Tuesday, November 06, 2012 12:43 AM
To: oracle-l@xxxxxxxxxxxxx
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***
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
