Re: RU First or Last?

From: Charlotte Hammond <"Charlotte>
Date: Tue, 23 Jun 2020 17:20:52 +0000 (UTC)
Message-ID: <845106006.2523069.1592932852401_at_mail.yahoo.com>

Hello,

No - it's not the latest opatch - it's the one that comes with the 18c base install. However if I wanted to upgrade it I'd have to download a new one into the unzipped but uninstalled 18c home before I run the installer. This is becoming a bit convoluted for my liking! I think I'll just run opatch apply separately after installing 18c (I presume this is what -applyRU does behind the scenes anyway?). Thanks,Charlotte On Tuesday, June 23, 2020, 12:51:34 PM GMT+1, Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

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

Received on Tue Jun 23 2020 - 19:20:52 CEST

This message: [ Message body ]
Next message: Mark J. Bobak: "Re: Installing Oracle 19c (19.7) on Oracle Linux 8.2......"
Previous message: Mikhail Velikikh: "Re: RU First or Last?"
In reply to: Mikhail Velikikh: "Re: RU First or Last?"
In reply to Charlotte Hammond: "Re: RU First or Last?"
Next in thread: Noveljic Nenad: "RE: Query performance issue after 19c upgrade"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message