Re: Upgrade 11.1.0.7 with compressed objects

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

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