May 19, 2021

Upgrading Oracle Database 19.3 to 19.9

Let us look at how to Upgrade Oracle 19.3 to 19.9 Database on.

Description:-

Below are the step-by-step method of upgrading Oracle Database Home from 19.3 to 19.9 on a latest Linux OS.

Below are some of the prerequisites:

1. OPatch utility version should be 12.2.0.1.19 or later to apply this patch. If Opatch is lower version , then need to upgrade Opatch before proceeding for DB Upgrade.

2. DB home mount point should have atleast 6GB of free space.

Step 1: Verify existing OPatch version.

/opt/oracle/product/19.3.0/db_1/OPatch

$ ./opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

Step 2: Install OPatch utility “6880880”: as the required OPatch(12.2.0.1.19 or later ) is not available in the above step.

• Backup the Old OPatch utility

$ cd $ORACLE_HOME

$ mv OPatch/ OPatch_backup

After this step there won’t be any OPatch folder present in $ORACLE_HOME.

Step 3: Download the patch file (p6880880_190000_Linux-x86-64.zip ) from Oracle support site and copy it in ORACLE_HOME location. And extract the files.

$ cp p6880880_190000_Linux-x86-64.zip $ORACLE_HOME

$ unzip p6880880_190000_Linux-x86-64.

Post extracting , verify the latest OPatch version.

$ cd OPatch

$ ./opatch version

OPatch Version: 12.2.0.1.24

OPatch succeeded.

Step 4: Download and Install the DB patch 31771877 to upgrade 19.3 to 19.9

Stop the listener and all DB’s running under 19.3 ORACLE_HOME.

Place the patch in any location. Suggest to use a different location other than /opt/oracle for space constraints.

$ mv p31771877_190000_Linux-x86-64.zip /oradata/upgrade_path

$ cd /oradata/upgrade_path

$ ls -ltr

total 1391308

-rw-r--r-- 1 oracle dba 1424692091 Apr 8 01:21 p31771877_190000_Linux-x86-64.zip

$ unzip p31771877_190000_Linux-x86-64.zip

…..

….

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/spike/SpikeCacheSize.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/spike/SpikeLdapUpdate.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/SendIt.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/scraper.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/checker.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/autosr.class

inflating: 31771877/files/suptools/tfa/release/tfa_home/ext/tnt/lib/tnt.jar/oracle/rat/tfa/toaster.class

inflating: PatchSearch.xml

Step 5: Apply the patch

$ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.24

Oracle Home : /opt/oracle/product/19.3.0/db_1

Central Inventory : /opt/oracle/oraInventory

from : /opt/oracle/product/19.3.0/db_1/oraInst.loc

OPatch version : 12.2.0.1.24

OUI version : 12.2.0.7.0

Log file location : /opt/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2021-04-08_13-06-05PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 31771877

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/opt/oracle/product/19.3.0/db_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Applying interim patch '31771877' to OH '/opt/oracle/product/19.3.0/db_1'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.usm.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.bali.ice, 11.1.1.7.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...

Patch 31771877 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [31771877].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /opt/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2021-04-08_13-06-05PM_1.log

OPatch succeeded.

Step 6: Verified the applied patch

-bash-4.2$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.24

Oracle Home : /opt/oracle/product/19.3.0/db_1

Central Inventory : /opt/oracle/oraInventory

from : /opt/oracle/product/19.3.0/db_1/oraInst.loc

OPatch version : 12.2.0.1.24

OUI version : 12.2.0.7.0

Log file location : /opt/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2021-04-08_13-12-47PM_1.log

Lsinventory Output file location : /opt/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-04-08_13-12-47PM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: pedoradb01

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c 19.0.0.0.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 31771877 : applied on Thu Apr 08 13:08:20 IST 2021

Unique Patch ID: 23869227

Step 7: Start the DB and listener.

-$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 8 13:13:38 2021

Version 19.9.0.0.0

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 3154113400 bytes

Fixed Size 8901496 bytes

Variable Size 855638016 bytes

Database Buffers 2281701376 bytes

Redo Buffers 7872512 bytes

Database mounted.

Database opened.

Search This Blog

Tuning Oracle DB

Upgrading Oracle Database 19.3 to 19.9

Let us look at how to Upgrade Oracle 19.3 to 19.9 Database on.

Step 1: Verify existing OPatch version.

Step 2: Install OPatch utility “6880880”: as the required OPatch(12.2.0.1.19 or later ) is not available in the above step.

Step 4: Download and Install the DB patch 31771877 to upgrade 19.3 to 19.9

Step 5: Apply the patch

Step 6: Verified the applied patch

Step 7: Start the DB and listener.

Enjoy Upgrading!!.

Comments

Post a Comment

Popular Posts

SYSAUX Tablespace Grows Rapidly After Upgrading Database to 12.2.0.1 Due To Statistics Advisor

OSD kill succeeded for process ....in alert log