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@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
Thank you Mikhail,
Charlotte
On Monday, June 22, 2020, 07:00:24 PM GMT+1, Mikhail Velikikh <
mvelikikh@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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
