Re: Export Backup Failure
Date: Wed, 11 May 2011 17:06:55 +0530
Message-ID: <BANLkTimG6U=LmptHWW5+kwPn8qe6eX_siQ_at_mail.gmail.com>
Yea i did. However mostly they suggested to increase sort_area_size. But we did not get this issue in past. from yesterday we are encounter with ORA-00068: ORA-06512: -Naga
On Wed, May 11, 2011 at 4:53 PM, Howard Latham <howard.latham_at_gmail.com>wrote:
> Did you do a google search for the error message?
>
>
> On 11 May 2011 12:17, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>
>> No i did not apply CPU patch. I have only base version installed
>>
>>
>> -Naga
>>
>> On Wed, May 11, 2011 at 4:35 PM, Sreejith S Nair <
>> Sreejith.Sreekantan_at_ibsplc.com> wrote:
>>
>>> A search in MOS gives this link, Did you check this - *ORA-68 During
>>> Export After Applying CPU Patch [ID 382162.1]*
>>>
>>> HTH,
>>> Sreejith
>>>
>>>
>>>
>>> From: Nagaraj S <nagaraj.chk_at_gmail.com>
>>> To: oracle-l <oracle-l_at_freelists.org>
>>> Date: 05/11/2011 04:10 PM
>>> Subject: Export Backup Failure
>>> Sent by: oracle-l-bounce_at_freelists.org
>>> ------------------------------
>>>
>>>
>>>
>>> Hello,
>>>
>>> Export backup faling with below error. Kindly help here.
>>>
>>>
>>> Export: Release 10.2.0.1.0 - Production on Wed May 11 00:00:54 2011
>>>
>>> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>>>
>>>
>>> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
>>> - 64bit Production
>>> With the Partitioning, OLAP and Data Mining options
>>> EXP-00056: ORACLE error 68 encountered
>>> ORA-00068: invalid value 1000000 for parameter sort_area_size, must be
>>> between 7801677937 and 3819475968
>>> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 720
>>> ORA-06512: at line 1
>>> EXP-00056: ORACLE error 68 encountered
>>> ORA-00068: invalid value 1000000 for parameter sort_area_size, must be
>>> between 7801677937 and 3819475968
>>> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 720
>>> ORA-06512: at line 1
>>> EXP-00000: Export terminated unsuccessfully
>>>
>>> -Nagaraj
>>>
>>>
>>>
>>>
>>>
>>>
>>> DISCLAIMER:
>>>
>>> "The information in this e-mail and any attachment is intended only for
>>> the person to whom it is addressed and may contain confidential and/or
>>> privileged material. If you have received this e-mail in error, kindly
>>> contact the sender and destroy all copies of the original communication. IBS
>>> makes no warranty, express or implied, nor guarantees the accuracy, adequacy
>>> or completeness of the information contained in this email or any attachment
>>> and is not liable for any errors, defects, omissions, viruses or for
>>> resultant loss or damage, if any, direct or indirect."
>>>
>>>
>>>
>>>
>>>
>>
>
>
> --
> Howard A. Latham
>
> Sent from my Nokia N97
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 11 2011 - 06:36:55 CDT