Re: Upgrade 11.1.0.7 with compressed objects

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

> 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

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