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]$

No comments:

Post a Comment