Re: Export Backup Failure

  • From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
  • To: Howard Latham <howard.latham@xxxxxxxxx>
  • Date: Wed, 11 May 2011 17:06:55 +0530

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@xxxxxxxxx>wrote:

> Did you do a google search for the error message?
>
>
> On 11 May 2011 12:17, Nagaraj S <nagaraj.chk@xxxxxxxxx> 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@xxxxxxxxxx> 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@xxxxxxxxx>
>>> To:        oracle-l <oracle-l@xxxxxxxxxxxxx>
>>> Date:        05/11/2011 04:10 PM
>>> Subject:        Export Backup Failure
>>> Sent by:        oracle-l-bounce@xxxxxxxxxxxxx
>>> ------------------------------
>>>
>>>
>>>
>>> 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
>
>

Other related posts: