Wednesday 23 October 2019

grid patch --- Patch 24412235 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.161018 (Oct2016)


  • Scenario Preview:
We found bug at OS level during installation of SLES 12 SP4 , Cluster verification utility tools were not showing outputs , As per oracle support , This is due to OS kernel issue.

So we have to start installation process using grid user before running ./roost.sh.  apply patch at local level on both machine one by one.

 Set Grid home environment.


[grid@srv1 24412235]$ export ORACLE_HOME=/u01/app/12.1.0/grid/
[grid@srv1 24412235]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[grid@srv1 24412235]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

Grid patch command:


[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24007012

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24006101

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/23854735

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/21436941

###############################################################################
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24007012
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-30-17PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   24007012

Do you want to proceed? [y|n]
y
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/12.1.0/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Applying interim patch '24007012' to OH '/u01/app/12.1.0/grid'


Patching component oracle.usm, 12.1.0.2.0...
Patch 24007012 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-30-17PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24006101
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-35-18PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101

Do you want to proceed? [y|n]
y
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/12.1.0/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.xdk, 12.1.0.2.0 ] , [ oracle.oraolap, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/12.1.0/grid'

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.has.crs, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/12.1.0/grid'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/12.1.0/grid'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.xdk, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.oraolap, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 12.1.0.2.0 ] , [ oracle.ctx, 12.1.0.2.0 ] , [ oracle.xdk, 12.1.0.2.0 ] , [ oracle.ctx.atg, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

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

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Composite patch 24006101 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-35-18PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/23854735
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-39-38PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-40-06PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   23854735

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
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/12.1.0/grid')


Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...

Applying interim patch '23854735' to OH '/u01/app/12.1.0/grid'

Patching component oracle.crs, 12.1.0.2.0...


Patching component oracle.has.db, 12.1.0.2.0...

Patching component oracle.has.common, 12.1.0.2.0...
Patch 23854735 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-40-06PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/21436941
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-46-41PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21436941

Do you want to proceed? [y|n]
y
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/12.1.0/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21436941' to OH '/u01/app/12.1.0/grid'

Patching component oracle.wlm.dbwlm, 12.1.0.2.0...
Patch 21436941 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-46-41PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$

No comments:

Post a Comment