Re: Upgrade 11.1.0.7 with compressed objects

Hi All,

Any negative impact of truncating following tables before upgrade?

 WRI$_OPTSTAT_HISTHEAD_HISTORY;
 WRI$_OPTSTAT_HISTGRM_HISTORY; Do these tables have impact on current stats , performance and SPM?

Thanks
Nitin

On Fri, Dec 29, 2017 at 8:10 AM, Nitin Saxena <ntnsxn7_at_gmail.com> wrote:

> Hi John,
>
> I did discuss with oracle again and they came with NO answer. In past I
> have been running those post upgrade scripts in restrict mode.
>
> Reason for asking is to reduce downtime. So that if it is possible to run
> those scripts then we can run in parallel and reduce downtime. I am in
> charge for that system.
>
> Testing the way but to mimic prod I wanted to try RAT(Real Application
> Testing or Database Replay) which I did in non prod environment. But
> running a capture against such a critical system is scary .
>
> Thanks for responding to my questions.
>
> Thanks
> Nitin
>
> On Fri, Dec 29, 2017 at 12:14 AM, John Hallas <
> john.hallas_at_morrisonsplc.co.uk> wrote:
>
>> If Oracle support say it is OK then take their word over mine.
>> I am not really sure why you are asking the question anyway. It is your
>> system - you are in charge.
>>
>> Testing is the only way to be sure but I appreciate that it would be
>> difficult to test with application load in a non-prod environment. Which is
>> one of the reasons why I said NO.
>>
>>
>>
>> On 27 December 2017 at 16:44, Nitin Saxena <ntnsxn7_at_gmail.com> wrote:
>>
>>> The reason I asked Oracle Support says it is fine to run following when
>>> users are making changes.
>>>
>>> _at_?/rdbms/admin/utlu112s.sql
>>> _at_?/rdbms/admin/catuppst.sql
>>> _at_?/rdbms/admin/catbundle.sql psu apply
>>> _at_?/rdbms/admin/utlrp
>>>
>>> Please guide or share any experience . This is to reduce the downtime.
>>>
>>> Thanks
>>> Nitin
>>>
>>> On Wed, Dec 27, 2017 at 5:44 AM, John Hallas <
>>> john.hallas_at_morrisonsplc.co.uk> wrote:
>>>
>>>> In a word NO.
>>>>
>>>> The application may or may not continue to work but these scripts
>>>> should be run with no users logged in or applications running
>>>>
>>>> John
>>>>
>>>> On 25 December 2017 at 01:35, Nitin Saxena <ntnsxn7_at_gmail.com> wrote:
>>>>
>>>>> Hello All,
>>>>>
>>>>> I am battling a upgrade currently. Current production is 11.1.0.7,
>>>>> which is obsolete and version number can tell that we couldn't upgrade this
>>>>> database due to no downtime provided.
>>>>>
>>>>> Current Challenges-
>>>>>
>>>>> Compressed objects are not supported with Goldengate classical extract
>>>>> which is the only extract mode compatible with 11.1 database version.
>>>>> Compressed Objects are not supported with Logical standby , so logical
>>>>> transient upgrade is also crossed from list.
>>>>> Compressed objects are not supported with Streams on 11.1.
>>>>>
>>>>>
>>>>> We have 26 such table and the biggest one is 1 TB and second biggest
>>>>> 500GB , Rest are tiny ones.
>>>>>
>>>>> We can't uncompress tables due to exclusive lock on tables and we
>>>>> don't have space on current box , more over it may be change sql plans on
>>>>> uncompressed .
>>>>>
>>>>> Finally we have proposed cold upgrade by shutting down primary for 12
>>>>> odd minutes.
>>>>>
>>>>> I have one question :
>>>>>
>>>>> Can I run following sqls when application is UP and running fine?
>>>>>
>>>>> _at_?/rdbms/admin/utlu112s.sql
>>>>> _at_?/rdbms/admin/catuppst.sql
>>>>> _at_?/rdbms/admin/catbundle.sql psu apply
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> --
>>>>> Nitin
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> *Technology Manager - Databases and System Management*
>>>>
>>>> Wm Morrison Supermarkets PLC
>>>>
>>>> Tel 0845 611 4589 (Int. 7949 4589)
>>>> Mob: 07876 790540
>>>>
>>>> E-mail: john.hallas_at_morrisonsplc.co.uk
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------
>>>> Wm Morrison Supermarkets Plc is registered in England with number
>>>> 358949. The registered office of the company is situated at Gain Lane,
>>>> Bradford, West Yorkshire BD3 7DL. This email and any attachments are
>>>> intended for the addressee(s) only and may be confidential.
>>>>
>>>> If you are not the intended recipient, please inform the sender by
>>>> replying to the email that you have received in error and then destroy the
>>>> email.
>>>> If you are not the intended recipient, you must not use, disclose, copy
>>>> or rely on the email or its attachments in any way.
>>>>
>>>> This email does not constitute a contract in writing for the purposes
>>>> of the Law of Property (Miscellaneous Provisions) Act 1989.
>>>>
>>>> Our Standard Terms and Conditions of Purchase, as may be amended from
>>>> time to time, apply to any contract that we enter into. The current version
>>>> of our Standard Terms and Conditions of Purchase is available at:
>>>> http://www.morrisons.co.uk/gscop
>>>>
>>>> Although we have taken steps to ensure the email and its attachments
>>>> are virus-free, we cannot guarantee this or accept any responsibility, and
>>>> it is the responsibility of recipients to carry out their own virus checks.
>>>> ------------------------------
>>>>
>>>
>>>
>>>
>>> --
>>> Cheers
>>> Nitin
>>>
>>
>>
>>
>> --
>>
>> *Technology Manager - Databases and System Management*
>>
>> Wm Morrison Supermarkets PLC
>>
>> Tel 0845 611 4589 (Int. 7949 4589)
>> Mob: 07876 790540
>>
>> E-mail: john.hallas_at_morrisonsplc.co.uk
>>
>>
>>
>>
>> ------------------------------
>> Wm Morrison Supermarkets Plc is registered in England with number 358949.
>> The registered office of the company is situated at Gain Lane, Bradford,
>> West Yorkshire BD3 7DL. This email and any attachments are intended for the
>> addressee(s) only and may be confidential.
>>
>> If you are not the intended recipient, please inform the sender by
>> replying to the email that you have received in error and then destroy the
>> email.
>> If you are not the intended recipient, you must not use, disclose, copy
>> or rely on the email or its attachments in any way.
>>
>> This email does not constitute a contract in writing for the purposes of
>> the Law of Property (Miscellaneous Provisions) Act 1989.
>>
>> Our Standard Terms and Conditions of Purchase, as may be amended from
>> time to time, apply to any contract that we enter into. The current version
>> of our Standard Terms and Conditions of Purchase is available at:
>> http://www.morrisons.co.uk/gscop
>>
>> Although we have taken steps to ensure the email and its attachments are
>> virus-free, we cannot guarantee this or accept any responsibility, and it
>> is the responsibility of recipients to carry out their own virus checks.
>> ------------------------------
>>
>
>
>
> --
> Cheers
> Nitin
>

-- 
Cheers
Nitin

--
http://www.freelists.org/webpage/oracle-l