Re: RU First or Last?

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