Database Administrator's blog: Oracle 19c (19.19.0.0.0) Grid Home Patching

--===Oracle 19c (19.19.0.0.0) Grid Home Patching ============

[root@baprdg01 ~]# cd /u01/app/19.0.0.0/grid/crs/install

[root@baprdg01 install]#

[root@baprdg01 install]# ./rootcrs.sh -prepatch

Using configuration parameter file: /u01/app/19.0.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

/u01/app/grid/crsdata/baprdg01/crsconfig/crs_prepatch_baprdg01_2023-11-06_04-44-42PM.log

2023/11/06 16:45:34 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.

2023/11/06 16:47:13 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.

2023/11/06 16:47:15 CLSRSC-347: Successfully unlock /u01/app/19.0.0.0/grid

2023/11/06 16:47:17 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.

[root@baprdg01 install]#

[grid@baprdg01 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

[grid@baprdg01 OPatch]$

[grid@baprdg01 OPatch]$ ls -ld

drwxr-x--- 14 grid oinstall 4096 Nov 6 14:46 .

[grid@baprdg01 OPatch]$

--move OPatch Version: 12.2.0.1.17

[grid@baprdg01 OPatch]$ pwd

/u01/app/19.0.0.0/grid/OPatch

[grid@baprdg01 OPatch]$ cd ..

[grid@baprdg01 grid]$ mv OPatch/ bak_OPatch_6oct23

[grid@baprdg01 grid]$ ls -ltr

-- use OPatch Version: 12.2.0.1.33

[grid@baprdg01 grid]$ chmod -R 775 OPatch/

[grid@baprdg01 grid]$

[grid@baprdg01 grid]$ cd OPatch/

[grid@baprdg01 OPatch]$

[grid@baprdg01 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.33

OPatch succeeded.

[grid@baprdg01 OPatch]$

-- UNZIPPED_PATCH_LOCATION: /d01/soft/GI_Patch/35037840

[root@baprdg01 bin]# ./crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'baprdg01'

CRS-2673: Attempting to stop 'ora.crsd' on 'baprdg01'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'baprdg01'

CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'baprdg01'

CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.cvu' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.chad' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.qosmserver' on 'baprdg01'

CRS-2677: Stop of 'ora.cvu' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'baprdg01'

CRS-2677: Stop of 'ora.asm' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'baprdg01'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'baprdg01'

CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.scan3.vip' on 'baprdg01'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.baprdg01.vip' on 'baprdg01'

CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.scan2.vip' on 'baprdg01'

CRS-2677: Stop of 'ora.scan1.vip' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.scan3.vip' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.baprdg01.vip' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.scan2.vip' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.chad' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'baprdg01'

CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'baprdg01' succeeded

CRS-33677: Stop of resource group 'ora.asmgroup' on server 'baprdg01' succeeded.

CRS-2677: Stop of 'ora.qosmserver' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'baprdg01'

CRS-2677: Stop of 'ora.ons' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'baprdg01'

CRS-2677: Stop of 'ora.net1.network' on 'baprdg01' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'baprdg01' has completed

CRS-2677: Stop of 'ora.crsd' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.crf' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'baprdg01'

CRS-2677: Stop of 'ora.crf' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.asm' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'baprdg01'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.evmd' on 'baprdg01'

CRS-2677: Stop of 'ora.ctssd' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.evmd' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'baprdg01'

CRS-2677: Stop of 'ora.cssd' on 'baprdg01' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'baprdg01'

CRS-2673: Attempting to stop 'ora.gpnpd' on 'baprdg01'

CRS-2677: Stop of 'ora.gpnpd' on 'baprdg01' succeeded

CRS-2677: Stop of 'ora.gipcd' on 'baprdg01' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'baprdg01' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@baprdg01 bin]#

[root@baprdg01 bin]# cd

[root@baprdg01 ~]#

[grid@baprdg01 grid]$ cd OPatch/

[grid@baprdg01 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.39

OPatch succeeded.

[grid@baprdg01 OPatch]$

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35042068

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050331

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050325

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35107512

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/33575402

[grid@baprdg01 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35042068

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-28-51PM_1.log

Verifying environment and performing prerequisite checks...

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

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-29-12PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 35042068

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 = '/u01/app/19.0.0.0/grid')

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

User Responded with: Y

Backing up files...

Applying interim patch '35042068' to OH '/u01/app/19.0.0.0/grid'

ApplySession: Optional component(s) [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.precomp.lang, 19.0.0.0.0 ] , [ oracle.precomp.common, 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.rsf, 19.0.0.0.0...

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

Patching component oracle.slax.rsf, 19.0.0.0.0...

Patching component oracle.ordim.jai, 19.0.0.0.0...

Patching component oracle.bali.jewt, 11.1.1.6.0...

Patching component oracle.bali.ewt, 11.1.1.6.0...

Patching component oracle.help.ohj, 11.1.1.7.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

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

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

Patching component oracle.rdbms, 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.blaslapack, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 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.duma, 19.0.0.0.0...

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

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

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

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

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

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

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

Patching component oracle.perlint, 5.28.1.0.0...

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

Patching component oracle.rdbms.crs, 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.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.rhp.db, 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.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.tfa, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

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

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

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

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

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

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

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

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

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

Patching component oracle.ovm, 19.0.0.0.0...

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

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

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

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

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

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...

Patch 35042068 successfully applied.

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

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

Log file location: /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-29-12PM_1.log

OPatch succeeded.

[grid@baprdg01 ~]$

[grid@baprdg01 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050331

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-36-44PM_1.log

Verifying environment and performing prerequisite checks...

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

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-37-07PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 35050331

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 = '/u01/app/19.0.0.0/grid')

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

User Responded with: Y

Backing up files...

Applying interim patch '35050331' to OH '/u01/app/19.0.0.0/grid'

ApplySession: Optional component(s) [ oracle.has.db.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.has.common, 19.0.0.0.0...

Patching component oracle.rhp.crs, 19.0.0.0.0...

Patching component oracle.has.cvu, 19.0.0.0.0...

Patching component oracle.has.crs.cvu, 19.0.0.0.0...

Patching component oracle.has.rsf, 19.0.0.0.0...

Patching component oracle.rhp.common, 19.0.0.0.0...

Patching component oracle.has.crs, 19.0.0.0.0...

Patching component oracle.has.common.cvu, 19.0.0.0.0...

Patching component oracle.has.db, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.xag, 19.0.0.0.0...

Patch 35050331 successfully applied.

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

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

Log file location: /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-37-07PM_1.log

OPatch succeeded.

[grid@baprdg01 ~]$

[grid@baprdg01 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050325

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-38-46PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 35050325

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 = '/u01/app/19.0.0.0/grid')

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

User Responded with: Y

Backing up files...

Applying interim patch '35050325' to OH '/u01/app/19.0.0.0/grid'

Patching component oracle.usm, 19.0.0.0.0...

Patch 35050325 successfully applied.

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

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

Log file location: /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-38-46PM_1.log

OPatch succeeded.

[grid@baprdg01 ~]$

[grid@baprdg01 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35107512

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-40-29PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 35107512

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 = '/u01/app/19.0.0.0/grid')

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

User Responded with: Y

Backing up files...

Applying interim patch '35107512' to OH '/u01/app/19.0.0.0/grid'

Patching component oracle.tomcat.crs, 19.0.0.0.0...

Patch 35107512 successfully applied.

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

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

Log file location: /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-40-29PM_1.log

OPatch succeeded.

[grid@baprdg01 ~]$

[grid@baprdg01 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/33575402

Oracle Interim Patch Installer version 12.2.0.1.39

Oracle Home : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version : 12.2.0.1.39

OUI version : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-42-27PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 33575402

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 = '/u01/app/19.0.0.0/grid')

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

User Responded with: Y

Backing up files...

Applying interim patch '33575402' to OH '/u01/app/19.0.0.0/grid'

Patching component oracle.wlm.dbwlm, 19.0.0.0.0...

Patch 33575402 successfully applied.

Log file location: /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-11-07_17-42-27PM_1.log

OPatch succeeded.

[grid@baprdg01 ~]$

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35042068

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050331

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35050325

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/35107512

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local /d01/soft/GI_Patch/35037840/33575402

--== in case of patch rollback =======

[grid@baprdg01 ~]$/u01/app/19.0.0.0/grid/OPatch/opatch nrollback -id 35042068,35050331,35050325,35107512,33575402

--===end =============

--== Post patching ===

[root@baprdg01 bin]# /u01/app/19.0.0.0/grid/rdbms/install/rootadd_rdbms.sh

[root@baprdg01 bin]#

[root@baprdg01 bin]# /u01/app/19.0.0.0/grid/rdbms/install/rootadd_rdbms.sh

[root@baprdg01 bin]#

[root@baprdg01 bin]# /u01/app/19.0.0.0/grid/crs/install/rootcrs.sh -postpatch

Using configuration parameter file: /u01/app/19.0.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

/u01/app/grid/crsdata/baprdg01/crsconfig/crs_postpatch_apply_inplace_baprdg01_2023-11-08_10-47-39AM.log

2023/11/08 10:47:49 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [526767740].

CRS-2672: Attempting to start 'ora.drivers.acfs' on 'baprdg01'

CRS-2676: Start of 'ora.drivers.acfs' on 'baprdg01' succeeded

2023/11/08 10:49:34 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2023/11/08 10:49:35 CLSRSC-672: Post-patch steps for patching GI home successfully completed.

[root@baprdg01 bin]#

[root@baprdg01 bin]# /u01/app/19.0.0.0/grid/bin/crsctl stat res -t

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

Name Target State Server State details

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE baprdg01 STABLE

ora.chad

ONLINE ONLINE baprdg01 STABLE

ora.net1.network

ONLINE ONLINE baprdg01 STABLE

ora.ons

ONLINE ONLINE baprdg01 STABLE

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

Cluster Resources

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

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE baprdg01 STABLE

2 ONLINE OFFLINE STABLE

3 ONLINE OFFLINE STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE baprdg01 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE baprdg01 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE baprdg01 STABLE

ora.OCRVOTE.dg(ora.asmgroup)

1 ONLINE ONLINE baprdg01 STABLE

2 OFFLINE OFFLINE STABLE

3 OFFLINE OFFLINE STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE baprdg01 Started,STABLE

2 OFFLINE OFFLINE STABLE

3 OFFLINE OFFLINE STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE baprdg01 STABLE

2 OFFLINE OFFLINE STABLE

3 OFFLINE OFFLINE STABLE

ora.baprdg01.vip

1 ONLINE ONLINE baprdg01 STABLE

ora.cvu

1 ONLINE ONLINE baprdg01 STABLE

ora.qosmserver

1 ONLINE ONLINE baprdg01 STABLE

ora.scan1.vip

1 ONLINE ONLINE baprdg01 STABLE

ora.scan2.vip

1 ONLINE ONLINE baprdg01 STABLE

ora.scan3.vip

1 ONLINE ONLINE baprdg01 STABLE

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

[root@baprdg01 bin]#

-=== in case of error ==

[root@baprdg01 ~]# /u01/app/19.0.0.0/grid/bin/crsctl start has

CRS-6706: Oracle Clusterware Release patch level ('2965637783') does not match Software patch level ('2676783881'). Oracle Clusterware cannot be started.

CRS-4000: Command Start failed, or completed with errors.

[root@baprdg01 ~]# /u01/app/19.0.0.0/grid/crs/install/roothas.sh -unlock

[root@baprdg01 ~]#/u01/app/19.0.0.0/grid/bin/clscfg -localpatch

[root@baprdg01 ~]#/u01/app/19.0.0.0/grid/crs/install/roothas.sh -lock

[root@baprdg01 ~]# /u01/app/19.0.0.0/grid/crs/install/roothas.sh -unlock

Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params

The log of current session can be found at:

/d01/app/grid/crsdata/badbdr-test/crsconfig/haunlock__2022-12-12_11-23-59PM.log

2022/12/12 23:24:11 CLSRSC-347: Successfully unlock /d01/app/19c/grid

[root@baprdg01 ~]# /u01/app/19.0.0.0/grid/bin/clscfg -localpatch

clscfg: EXISTING configuration version 0 detected.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

[root@baprdg01 ~]# /u01/app/19.0.0.0/grid/crs/install/roothas.sh -lock

Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params

The log of current session can be found at:

/d01/app/grid/crsdata/badbdr-test/crsconfig/halock__2022-12-12_11-27-23PM.log

2022/12/12 23:27:26 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'

root@badbdr-test:~# /d01/app/19c/grid/bin/crsctl start has

CRS-4123: Oracle High Availability Services has been started.

[root@baprdg01 ~]#

--====End ==

[grid@baprdg01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 8 10:58:52 2023

Version 19.19.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.19.0.0.0

SQL>

Database Administrator's blog

Pages

Tuesday, November 7, 2023

Oracle 19c (19.19.0.0.0) Grid Home Patching

No comments:

Post a Comment