Re: Export Backup Failure

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: nagaraj.chk@xxxxxxxxx
  • Date: Wed, 11 May 2011 11:58:06 -0300

can you try removing the buffer line from the parfile?

hth
Alan.-


On Wed, May 11, 2011 at 8:36 AM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:

> 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: