Sunday, July 30, 2017

Apply patch 18706472 using Opatch auto in RAC

OPatch:

Opatch apply is used to apply single patch
Opatch napply is used to apply multiple patch at the same time.

==========================================================


export GRID_HOME=/u01/app/11.2.0/grid_1
export PATH=$PATH:$GRID_HOME/OPatch:$GRID_HOME/bin


[grid@rac2 OPatch]$
[grid@rac2 OPatch]$ export PATH=$PATH:$GRID_HOME/OPatch:$GRID_HOME/bin
[grid@rac2 OPatch]$
[grid@rac2 OPatch]$ opatch version
OPatch Version: 11.2.0.3.15

OPatch succeeded.
[grid@rac2 OPatch]$
[grid@rac2 OPatch]$
[grid@rac2 OPatch]$


[grid@rac2 bin]$
[grid@rac2 bin]$
[grid@rac2 bin]$ ./emocmrsp -no_banner -output /u01/oracle_software/grid_patch.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
The OCM configuration response file (/u01/oracle_software/grid_patch.rsp) was successfully created.
[grid@rac2 bin]$
[grid@rac2 bin]$
[grid@rac2 bin]$



[grid@rac2 oracle_software]$
[grid@rac2 oracle_software]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./18706472/
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/11.2.0/grid_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0/grid_1/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid_1/cfgtoollogs/opatch/opatch2017-07-30_03-15-27AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac2 oracle_software]$
[grid@rac2 oracle_software]$
[grid@rac2 oracle_software]$


[root@rac2 ~]# cd /u01/oracle_software/
[root@rac2 oracle_software]#
[root@rac2 oracle_software]#
[root@rac2 oracle_software]# opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./18706472/
The user is root. OPatch cannot continue if the user is root.

OPatch failed with error code 255
[root@rac2 oracle_software]#



[grid@rac2 oracle_software]$
[grid@rac2 oracle_software]$ opatch lspatches
18031731;ACFS Patch Set Update : 11.2.0.4.2 (18031731)
18031740;OCW Patch Set Update : 11.2.0.4.2 (18031740)
18031668;Database Patch Set Update : 11.2.0.4.2 (18031668)

OPatch succeeded.
[grid@rac2 oracle_software]$




[root@rac2 oracle_software]#
[root@rac2 oracle_software]# opatch auto /u01/oracle_software/18706472 -ocmrf /u01/oracle_software/grid_patch.rsp
Executing /u01/app/11.2.0/grid_1/perl/bin/perl /u01/app/11.2.0/grid_1/OPatch/crs/patch11203.pl -patchdir /u01/oracle_software -patchn 18706472 -ocmrf /u01/oracle_software/grid_patch.rsp -paramfile /u01/app/11.2.0/grid_1/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid_1/cfgtoollogs/opatchauto2017-07-30_03-20-01.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid_1/cfgtoollogs/opatchauto2017-07-30_03-20-01.report.log

2017-07-30 03:20:01: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid_1/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch /u01/oracle_software/18706472/18522509  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1
patch /u01/oracle_software/18706472/18522515/custom/server/18522515  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1

Stopping CRS...
Stopped CRS successfully

patch /u01/oracle_software/18706472/18522509  apply successful for home  /u01/app/11.2.0/grid_1
patch /u01/oracle_software/18706472/18522515  apply successful for home  /u01/app/11.2.0/grid_1
patch /u01/oracle_software/18706472/18522514  apply successful for home  /u01/app/11.2.0/grid_1

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Started RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatch auto succeeded.
[root@rac2 oracle_software]#


[grid@rac2 oracle_software]$ opatch lspatches
18522514;ACFS PATCH SET UPDATE : 11.2.0.4.3 (18522514)
18522515;OCW Patch Set Update : 11.2.0.4.3 (18522515)
18522509;Database Patch Set Update : 11.2.0.4.3 (18522509)

OPatch succeeded.
[grid@rac2 oracle_software]$





opatch log 
============================

[grid@rac2 cfgtoollogs]$ cat opatchauto2017-07-30_03-20-01.report.log
***********  Configuration Data  ***********
* It shows only those targets that will be patched in this session *


crs_home=/u01/app/11.2.0/grid_1      owner=grid      opatch_ver=11.2.0.3.15
rac_home=/u01/app/oracle/product/11.2.0/dbhome_1      owner=oracle      opatch_ver=11.2.0.3.15

*********** Steps to be executed as owner unless specified as root ***********


1: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckComponents -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/oracle/product/11.2.0/dbhome_1

2: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckComponents -ph /u01/oracle_software/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0/dbhome_1

3: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/oracle/product/11.2.0/dbhome_1

4: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /u01/oracle_software/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0/dbhome_1

5: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckComponents -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/11.2.0/grid_1

6: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckComponents -ph /u01/oracle_software/18706472/18522515 -oh /u01/app/11.2.0/grid_1

7: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckComponents -ph /u01/oracle_software/18706472/18522514 -oh /u01/app/11.2.0/grid_1

8: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/11.2.0/grid_1

9: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /u01/oracle_software/18706472/18522515 -oh /u01/app/11.2.0/grid_1

10: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /u01/oracle_software/18706472/18522514 -oh /u01/app/11.2.0/grid_1

11: /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl stop dbconsole

12: /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl stop agent

13: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckApplicable -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/oracle/product/11.2.0/dbhome_1

14: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckApplicable -ph /u01/oracle_software/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0/dbhome_1

15: /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/dbhome_1 -s /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/stophome.txt -n rac2 -f

16: /u01/oracle_software/18706472/18522515/custom/server/18522515/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/dbhome_1

17: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /u01/oracle_software/18706472/18522509 -local -silent -ocmrf /u01/oracle_software/grid_patch.rsp -oh /u01/app/oracle/product/11.2.0/dbhome_1 -invPtrLoc /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

18: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /u01/oracle_software/18706472/18522515/custom/server/18522515 -local -silent -ocmrf /u01/oracle_software/grid_patch.rsp -oh /u01/app/oracle/product/11.2.0/dbhome_1 -invPtrLoc /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

19: /u01/oracle_software/18706472/18522515/custom/server/18522515/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/dbhome_1

20: /u01/app/11.2.0/grid_1/crs/install/rootcrs.pl -unlock : run as root

21: /sbin/fuser -k /u01/app/11.2.0/grid_1/bin/crsctl.bin : run as root

22: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckApplicable -ph /u01/oracle_software/18706472/18522509 -oh /u01/app/11.2.0/grid_1

23: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckApplicable -ph /u01/oracle_software/18706472/18522515 -oh /u01/app/11.2.0/grid_1

24: /u01/app/11.2.0/grid_1/OPatch/opatch prereq CheckApplicable -ph /u01/oracle_software/18706472/18522514 -oh /u01/app/11.2.0/grid_1

25: /u01/app/11.2.0/grid_1/OPatch/opatch napply /u01/oracle_software/18706472/18522509 -local -silent -ocmrf /u01/oracle_software/grid_patch.rsp -oh /u01/app/11.2.0/grid_1 -invPtrLoc /u01/app/11.2.0/grid_1/oraInst.loc

26: /u01/app/11.2.0/grid_1/OPatch/opatch napply /u01/oracle_software/18706472/18522515 -local -silent -ocmrf /u01/oracle_software/grid_patch.rsp -oh /u01/app/11.2.0/grid_1 -invPtrLoc /u01/app/11.2.0/grid_1/oraInst.loc

27: /u01/app/11.2.0/grid_1/OPatch/opatch napply /u01/oracle_software/18706472/18522514 -local -silent -ocmrf /u01/oracle_software/grid_patch.rsp -oh /u01/app/11.2.0/grid_1 -invPtrLoc /u01/app/11.2.0/grid_1/oraInst.loc

28: /u01/app/11.2.0/grid_1/bin/emctl start dbconsole

29: /u01/app/11.2.0/grid_1/rdbms/install/rootadd_rdbms.sh : run as root

30: /u01/app/11.2.0/grid_1/crs/install/rootcrs.pl -patch : run as root

31: /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole

32: /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start agent

33: /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0/dbhome_1 -s /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/stophome.txt -n rac2

[grid@rac2 cfgtoollogs]$

By -
Labels: , ,

No comments:

Post a Comment

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Subscribe to: Post Comments (Atom)

Create Resource Manager , Resource Group / Consumer groups in Oracle Database to limit CPU resources

  Step to create Resource Manager  consumer groups in Oracle Database  1. First confirm the exact PROGRAM values     SELECT program, ...