Upgrade to Oracle 19.12 from Oracle 19.x by example

Upgrade to Oracle 19.12 from Oracle 19.x by example

Minimum space required:

6Gb for p33494256 and p6880880 patches

16Gb for /software/oracle

Steps:

as root user

1.

mkdir /starhome/iu/workarea/oracle_home_backup

chown oracle:dba /starhome/iu/workarea/oracle_home_backup

mkdir /starhome/iu/workarea/ora_upgrade

chown oracle:dba /starhome/iu/workarea/ora_upgrade

as oracle user

2.

cp -rp $ORACLE_HOME/ /starhome/iu/workarea/oracle_home_backup/

3.

cd /starhome/iu/workarea/ora_upgrade

sftp p6880880_190000_Linux-x86-64.zip ora_upgrade/

unzip -d TOP_6880880 p6880880_190000_Linux-x86-64.zip

cd $ORACLE_HOME/OPatch/

rm -rf *

cd /starhome/iu/workarea/ora_upgrade/TOP_6880880/OPatch

mv ./* $ORACLE_HOME/OPatch/

4.

cd /starhome/iu/workarea/ora_upgrade

unzip -d TOP_33494256 p33494256_190000_Linux-x86-64.zip

cd TOP_33494256/33494256

NOTE - Stop Oracle Server and Listener and Golden Gate before applying patch!!!

$ORACLE_HOME/OPatch/opatch apply -report

$ORACLE_HOME/OPatch/opatch apply

Expected result: 

Patch 33494256 successfully applied.

...

...

OPatch succeeded.

4. 

cd /starhome/iu/workarea/ora_upgrade

rm -rf TOP_6880880

rm -rf TOP_33494256

The issue with GG+oracle SE lower than 19.12:
In case using Golden gate on oracle 19.x on SE - there is an error when starting EXTRACT

2024-02-05 13:13:18  ERROR   OGG-02030  Failed to set logmining server parameters back to default values.

2024-02-05 13:13:18  ERROR   OGG-02042  OCI Error 23605.

The Reason: 

Golden gate start the EXTRACT in PARALLEL mode, but parallel functionality is not available in SE, and no way to control this parameter.

The Solution:

Upgrade Oracle SE to 19.12 or higher.

Clean up old patches

Old patches are stored under  $ORACLE_HOME/.patch_storage, and can use up space.

By default only 2 patches are required:

- Previous patch, for rollback

- Current Patch

Older patches are not required, and these should be cleaned up manually using OPatch utility:

Step 1. List Inactive Patches

opatch util listorderedinactivepatches

Step 2. Delete Inactive Patches

opatch util deleteinactivepatches

Example:

oracle@orahost:/software/oracle>% cd $ORACLE_HOME/OPatch

oracle@orahost:/software/oracle/1910/OPatch>% ./opatch util listorderedinactivepatches

Oracle Interim Patch Installer version 12.2.0.1.41

Copyright (c) 2024, Oracle Corporation.  All rights reserved.

Oracle Home       : /software/oracle/1910

Central Inventory : /software/oracle/oraInventory

   from           : /software/oracle/1910/oraInst.loc

OPatch version    : 12.2.0.1.41

OUI version       : 12.2.0.7.0

Log file location : /software/oracle/1910/cfgtoollogs/opatch/opatch2024-02-12_04-26-16AM_1.log

Invoking utility "listorderedinactivepatches"

List Inactive patches option provided

The oracle home has the following inactive patch(es) and their respective overlay patches:

The number of RU chains is  1

***** There are 2 inactive RU patches in chain 1

-Inactive RU/BP 29517242:Database Release Update : 19.3.0.0.190416 (29517242), installed on: Thu Apr 18 07:21:17 UTC 2019, with no overlays

-Inactive RU/BP 32819074:Database Release Update Revision : 19.10.2.0.0 (32819074), installed on: Wed Oct 20 14:09:36 UTC 2021, with no overlays

-Active RU/BP 33494256:Database Release Update Revision : 19.12.2.0.220118 (33494256), installed on: Mon Feb 12 04:19:12 UTC 2024, with no overlays

OPatch succeeded.

oracle@orahost:/software/oracle/1910/OPatch>% ./opatch util deleteinactivepatches

Oracle Interim Patch Installer version 12.2.0.1.41

Copyright (c) 2024, Oracle Corporation.  All rights reserved.

Oracle Home       : /software/oracle/1910

Central Inventory : /software/oracle/oraInventory

   from           : /software/oracle/1910/oraInst.loc

OPatch version    : 12.2.0.1.41

OUI version       : 12.2.0.7.0

Log file location : /software/oracle/1910/cfgtoollogs/opatch/opatch2024-02-12_04-27-54AM_1.log

Invoking utility "deleteinactivepatches"

Inactive Patches Cleanup option provided

Delete Inactive Patches .......

***** There are 2 inactive RU patches in chain 1

***** 1 inactive patches will be deleted

-To be deleted inactive RU/BP 29517242:Database Release Update : 19.3.0.0.190416 (29517242), installed on: Thu Apr 18 07:21:17 UTC 2019, with no overlays

-To be retained inactive RU/BP 32819074:Database Release Update Revision : 19.10.2.0.0 (32819074), installed on: Wed Oct 20 14:09:36 UTC 2021, with no overlays

-Active RU/BP 33494256:Database Release Update Revision : 19.12.2.0.220118 (33494256), installed on: Mon Feb 12 04:19:12 UTC 2024, with no overlays

Do you want to proceed? [y|n]

Y

User Responded with: Y

Deleted RU/BP patch: 29517242

OPatch succeeded.