Re: Upgrade 11.1.0.7 with compressed objects

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

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