Re: Export Backup Failure

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 11 May 2011 11:58:06 -0300
Message-ID: <BANLkTikodNv6FFLHkXWdpA=Vdu0gxkRwKA_at_mail.gmail.com>

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_at_gmail.com> 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_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-l

Received on Wed May 11 2011 - 09:58:06 CDT