Re: 12c to 19c - Upgrade

From: samuel guiñales cristobal <samuelg.cristobal_at_gmail.com>
Date: Mon, 7 Dec 2020 12:13:42 +0100
Message-ID: <CAESzQCEfccF3Nuc21gWpZPTvCSH2KmJy5W6-W6Suvp79xLYJKg_at_mail.gmail.com>



Hi,
_at_ Sanjay Mishra dbua silent mode on ansible mandatory, works fine, upgraded more than 20 databases same way for the moment.

_at_Arun Chugh

*>>Can you please share Jenkin and Ansible experience...* Transient logical standby rolling upgrade implemented with more than 20 steps run in jenkins, less than a minute of loss of service, only for failover(semi TLS metod) production db19c. All coded with ansible so allows us upgrade same way with out manual interaction inside machines.

https://www.oracle.com/technetwork/database/availability/database-rolling-upgrade-3206539.pdf https://mikedietrichde.com/2018/05/09/transient-logical-standby-rolling-upgrades-overview/

ansible code depend teams, but need invest time to code/test after test and built manual steps.
After the effort of coding/test, the operations are simple, without errors(no manual interaction), in less time. it's worth it if you have this time, for some companies if you want develop global solutions is a must.

Un saludo

---
Samuel Guiñales Cristobal <samuelg.cristobal_at_gmail.com>




On Mon, 7 Dec 2020 at 11:46, Arun Chugh <arun.chugh1610_at_gmail.com> wrote:


> Hi Samuel,
> Can you please share Jenkin and Ansible experience, and related documents.
>
> Also share any example if you have it handy.
>
> Thanks in advance !!!
>
> On Mon, Dec 7, 2020, 16:12 samuel guiñales cristobal <
> samuelg.cristobal_at_gmail.com> wrote:
>
>> Hi,
>>
>> This year we have lot databases from 12.2 to 19c with semi transient
>> rolling upgrade method using data guard to upgrade near zero downtime,
>> all automated via jenkins with ansible code everything with out manual
>> steps.
>>
>> Only 19.3/19.4/19.5 bug after upgrade with the oracle unified audit
>>
>> Regards
>> ---
>> Samuel Guiñales Cristobal <samuelg.cristobal_at_gmail.com>
>>
>>
>>
>>
>> On Sat, 5 Dec 2020 at 10:45, Ls Cheng <exriscer_at_gmail.com> wrote:
>>
>>> Hi
>>>
>>> I have upgraded about 50 databases from 11g, 12cR1, 12cR2 and 18c to 19c
>>> this year with autoupgrade, it is the way to go.
>>>
>>> It has some minor problems such as you cannot tell it NOT to run utlrp.
>>>
>>> BR
>>>
>>> On Fri, Dec 4, 2020 at 1:01 AM Sanjay Mishra <
>>> dmarc-noreply_at_freelists.org> wrote:
>>>
>>>> Can anyone share his experience using dbua in silent mode from 12c(12.1
>>>> or 12.2) to 19c ?
>>>>
>>>> Tx
>>>> Sanjay
>>>>
>>>
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 07 2020 - 12:13:42 CET

Original text of this message