Re: RU First or Last?

Are you using the latest OPatch for the 18c release? https://updates.oracle.com/download/6880880.html

On Tue, 23 Jun 2020 at 11:47, Charlotte Hammond < charlottejanehammond_at_yahoo.com> wrote:

> Sorry, my fault for muddying the waters:
>
> Yesterday I was talking about an 18c->19c upgrade.
> Today I was trying out a separate 11g->18c upgrade on a different database
> (but I did think the -applyRU switch should be applicable to both upgrades?)
>
> Thanks,
> Charlotte
>
> On Tuesday, June 23, 2020, 10:55:10 AM GMT+1, Mikhail Velikikh <
> mvelikikh_at_gmail.com> wrote:
>
>
> Hello Charlotte,
>
> Are you trying to upgrade to 18c or 19c?
> That patch 30783603 is for 18c: Bug 30783603 - Combo of 18.9.0.0.200114
> OJVM PSU and 18.9.0.0.200414 DB PSU (Apr 2020) (Doc ID 30783603.8)
>
> I installed a new 19.7 home the other day and that is the command which my
> automation script ran:
>
> ./runInstaller \
> -silent \
> ORACLE_HOME_NAME=DB_19_7_0_1 \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> oracle.install.option=INSTALL_DB_SWONLY \
> ORACLE_BASE=/u01/app/oracle \
> ORACLE_HOME=/u01/app/oracle/product/db_19.7.0.1 \
> UNIX_GROUP_NAME=oinstall \
> oracle.install.db.InstallEdition=EE \
> oracle.install.db.OSDBA_GROUP=dba \
> oracle.install.db.OSOPER_GROUP=oper \
> oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
> oracle.install.db.OSDGDBA_GROUP=dgdba \
> oracle.install.db.OSKMDBA_GROUP=kmdba \
> oracle.install.db.OSRACDBA_GROUP=racdba \
> -applyRU \
> /u01/app/oracle/stage/*30869156* \
> -applyOneOffs \
>
> /u01/app/oracle/stage/28001632,/u01/app/oracle/stage/30352715,/u01/app/oracle/stage/30528947,/u01/app/oracle/stage/
> *30805684*
>
> If you would like to apply only the latest RU and the OJVM patch, these
> are the patches that I would keep:
> DATABASE RELEASE UPDATE 19.7.0.0.0 (Patch 30869156)
> OJVM RELEASE UPDATE 19.7.0.0.0 (Patch 30805684)
>
> The command may look something like this - I would advise to amend the
> directories and the groups accordingly to your environment - it can be the
> 'dba' group everywhere:
>
> ./runInstaller \
> -silent \
> ORACLE_HOME_NAME=DB_19_7_0_1 \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> oracle.install.option=INSTALL_DB_SWONLY \
> ORACLE_BASE=/u01/app/oracle \
> ORACLE_HOME=/u01/app/oracle/product/db_19.7.0.1 \
> UNIX_GROUP_NAME=oinstall \
> oracle.install.db.InstallEdition=EE \
> oracle.install.db.OSDBA_GROUP=dba \
> oracle.install.db.OSOPER_GROUP=oper \
> oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
> oracle.install.db.OSDGDBA_GROUP=dgdba \
> oracle.install.db.OSKMDBA_GROUP=kmdba \
> oracle.install.db.OSRACDBA_GROUP=racdba \
> -applyRU \
> /u01/app/oracle/stage/*30869156* \
> -applyOneOffs \
> /u01/app/oracle/stage/*30805684*
>
> Best regards,
> Mikhail Velikikh
>
>
>
> On Tue, 23 Jun 2020 at 10:38, Charlotte Hammond <
> dmarc-noreply_at_freelists.org> wrote:
>
> OK, so I'm looking at this -applyRU switch now with the April 2020 RU/OJVM
> Combo and runInstaller is complaining:
>
> [INS-32829] The path (<my path>/30783603/30872794/bundle.xml) provided in
> the (-applyRU) argument value does not exist.
>
> Indeed it doesn't - I can't see that bundle.xml file anywhere in the zip
> file. I tried downloading the RU on its own and it wasn't there either.
>
> What am I missing here?
>
> Thanks,
> Charlotte
>
>
>
>
>
> On Monday, June 22, 2020, 07:07:55 PM GMT+1, Charlotte Hammond <
> charlottejanehammond_at_yahoo.com> wrote:
>
>
> Ha! Ha!
>
> ...and if I'd actually read the recent messages in this list before
> posting I'd have seen Tim Hall referemce the new -applyRU switch for just
> this purpose!
>
> Thank you!
> Charlotte
>
>
> On Monday, June 22, 2020, 07:04:48 PM GMT+1, Charlotte Hammond <
> charlottejanehammond_at_yahoo.com> wrote:
>
>
> Thank you Mikhail,
> Charlotte
>
> On Monday, June 22, 2020, 07:00:24 PM GMT+1, Mikhail Velikikh <
> mvelikikh_at_gmail.com> wrote:
>
>
> Hello,
>
> (1) apply the chosen RU to the 19c home before upgrading, or
>
>
> This is an Oracle recommended approach that I always follow:
>
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/database-preparation-tasks-to-complete-before-upgrades.html#GUID-46F09541-C36A-4790-B3D3-E0E336A7BBC3
>
> Before starting upgrades, update your new release Oracle Database to the
> latest Oracle bundle patch, patch set update (BP or PSU), or Release Update
> (Update), or Release Update Revision (Revision).
>
>
> OJVM is required if that makes a difference
>
>
> It should be present in the 19c home then. There is the OJVM_STATUS
> pre-upgrade check that fails if OJVM is missing in the new home:
> Database Preupgrade tool check list. (Doc ID 2380601.1)
>
> Best regards,
> Mikhail Velikikh
>
>
>
> On Mon, 22 Jun 2020 at 18:20, Charlotte Hammond <
> dmarc-noreply_at_freelists.org> wrote:
>
> Hello - quick advise question please! What's the best approach when
> upgrading 12c to 19c? Should I:
>
> (1) apply the chosen RU to the 19c home before upgrading, or
> (2) should I upgrade first and then apply the RU?
>
> This is a basic upgrade with the dbupgrade script (nothing fancy). I
> presume both would work but I'm unsure what the best practice is (OJVM is
> required if that makes a difference).
>
> Thank you!
> Charlotte
>
>

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