Re: RU First or Last?

From: Charlotte Hammond <"Charlotte>
Date: Tue, 23 Jun 2020 10:47:15 +0000 (UTC)
Message-ID: <55417075.2315780.1592909235687_at_mail.yahoo.com>



 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
Received on Tue Jun 23 2020 - 12:47:15 CEST

Original text of this message