Install the environment and patch version:
Oracle version: 11.2.0.4
Linux version: Red Hat Enterprise Linux Server Release 7.6 (MAIPO)
PSU version number: p31718723_112040_linux-x86-64.zip
OJVM version number: p31668908_112040_linux-x86-64.zip
OPATCH version: p6880880_112000_linux-x86-64_11.2.0.3.27.zip
Patch download link:
link:
Extraction code: 57Z7
Pay attention to the premature points before playing (the focus can be saved!):
1, backup (can save live)! ! !
2, turn off the database
3, first playGI psu
4, play againDB psu
5、gridUsers playACFS(In GI PSUAfter finishingCan only play)
6, play dockSpecifypatchinstallation manual：（opatch auto -oh $ORACLE_HOME）
7, stop CRS before playing OJVM, hit the node stop that node, there is at least one node in the problem
8, first put a node patch after playing the second node
Be sure to read ReadMe carefully! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !
First, backup! ! !
1, package Oracle software package backup
# cd /u01/app/oracle/product/11.2.0.4/ # tar -pzcvf oraclehome1.tar *2, pack the GRID software package backup
# cd /u01/app/11.2.0.4/grid/# tar -cvf gihome.tar *I hope that you can't use it, but there is no problem, the production environment, the patch is exhausted, the database is abolished, which is also very dangerous.
Second, close the database
# su - oracle$ sqlplus / as sysdbaSQL> shutdown immediateThird, bring Oracle with Grid OPATCH backup
In fact, change a name.
Back up Oracle_Home under Opatch:# su - oracle$ cd $ORACLE_HOME/OPatch/$ mv OPatch OPatch20201214$ exitBackup Grid_home under Opatch (Environment variables are also Oracle_home)：# su - grid$ cd $ORACLE_HOME/OPatch/$ mv OPatch OPatch20201214$ exitFourth, root users upload patch authorization and decompress
1, change patch media permissions
Because the patch media of the just uploaded media is root, in order to make Oracle users and GRID users can decompress the installation patches, change the patch media privilege:# chmod 777 /u01/software/p31668908_112040_Linux-x86-64.zip# chmod 777 /u01/software/p31718723_112040_Linux-x86-64.zip# chmod 777 /u01/software/p6880880_112000_Linux-x86-64_11.2.0.3.27.zip2, unzip patch and opatch (install Opatch)
Using GRID users to extract P31718723_112040_linux-x86-64.zip (PSU):# su - grid$ unzip /u01/software/p31718723_112040_Linux-x86-64.zip -d /u01/software Unzip OPATCH to Grid_Home:$ unzip /u01/software/p6880880* -d $ORACLE_HOME/ View OPATCH Version:$ opatch versionOPatch Version: 11.2.0.3.27OPatch succeeded.$ exitUse Oracle users to extract P31668908_112040_linux-x86-64.zip (OJVM):# su - oracle$ unzip /u01/software/p31668908_112040_Linux-x86-64.zip -d /u01/software Unzip OPATCH to Oracle_Home:$ unzip /u01/software/p6880880* -d $ORACLE_HOME/ View OPATCH Version:$ opatch versionOPatch Version: 11.2.0.3.27OPatch succeeded.$ exitV. Start installing patch
Unzip P31718723_112040_linux-x86-64.zip's directory, readme For the instructions for patching objects:
1, play 31718723 (PSU) patch
See Also
Acer Aspire P3-171-3322Y2G06as(1) Playing GI PSU
----gi psu----Root users do three patchs of GI's 29938455 (OCW), 29509309 (ACFS), 31537677 (DB PSU), 31537677 (DB PSU), execute the following command# <GRID_HOME> OPatch/opatch auto <UNZIPPED_PATCH_LOCATION> /31718723 -oh <GRID_HOME>The output is as follows:
# /u01/app/11.2.0.4/grid/OPatch/opatch auto /u01/software/31718723 -oh /u01/app/11.2.0.4/gridExecuting /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 31718723 -oh /u01/app/11.2.0.4/grid -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2020-12-14_11-22-22.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2020-12-14_11-22-22.report.log2020-12-14 11:22:22: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch /u01/software/31718723/29938455 apply successful for home /u01/app/11.2.0.4/grid patch /u01/software/31718723/31537677 apply successful for home /u01/app/11.2.0.4/grid patch /u01/software/31718723/29509309 apply successful for home /u01/app/11.2.0.4/grid Starting CRS...Installing Trace File AnalyzerCRS-4123: Oracle High Availability Services has been started.opatch auto succeeded.#View the Grid patch already installed:
# su - grid$ opatch lspatches29509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309)31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)OPatch succeeded.$ (2) play DB PSU
----db psu---- ROOT users do two patchs of GI's 29938455 (OCW), 31537677 (DB PSU) of GI# <ORACLE_HOME> OPatch/opatch auto <UNZIPPED_PATCH_LOCATION> /31718723 -oh <ORACLE_HOME>The output is as follows:
# /u01/app/oracle/product/11.2.0.4/OPatch/opatch auto /u01/software/31718723 -oh /u01/app/oracle/product/11.2.0.4Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 31718723 -oh /u01/app/oracle/product/11.2.0.4 -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2020-12-14_11-39-41.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2020-12-14_11-39-41.report.log2020-12-14 11:39:41: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0.4 ...Stopped RAC /u01/app/oracle/product/11.2.0.4 successfullypatch /u01/software/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0.4 patch /u01/software/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0.4 Starting RAC /u01/app/oracle/product/11.2.0.4 ...Started RAC /u01/app/oracle/product/11.2.0.4 successfullyopatch auto succeeded.# 2, play 31668908 (OJVM) patch
(1) stop CRS service
One stop, one by one, so at least to ensure a node is safe (especially the production environment!)
Stop current CRS# /u01/app/11.2.0.4/grid/bin/crsctl stop crs CRS status# /u01/app/11.2.0.4/grid/bin/crsctl status resource -t(2) OJVM should use Opatch under Oracle users to play
# su - oracle$ opatch apply <UNZIPPED_PATCH_LOCATION> /31668908The output is as follows:
$ opatch apply /u01/software/31668908Oracle Interim Patch Installer version 11.2.0.3.27Copyright (c) 2020, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0.4Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/oraInst.locOPatch version : 11.2.0.3.27OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-12-14_11-58-40AM_1.logVerifying environment and performing prerequisite checks...OPatch continues with these patches: 31668908 Do you want to proceed? [y|n]yUser Responded with: YAll checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = '/u01/app/oracle/product/11.2.0.4')Is the local system ready for patching? [y|n]yUser Responded with: YBacking up files...Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0.4'ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.javavm.server, 11.2.0.4.0...Patching component oracle.precomp.common, 11.2.0.4.0...Patching component oracle.rdbms, 11.2.0.4.0...Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component oracle.javavm.client, 11.2.0.4.0...Patching component oracle.dbjava.jdbc, 11.2.0.4.0...Patching component oracle.dbjava.ic, 11.2.0.4.0...Patch 31668908 successfully applied.Log file location: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-12-14_11-58-40AM_1.logOPatch succeeded.$View installed Oracle patches
# su - oracleLast login: Mon Dec 14 11:46:56 CST 2020 on pts/4[csxgdb2][oracle@csxgdb2 ~]$ opatch lspatches31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)OPatch succeeded.$When the patch of the GI and DB of this single node is complete, the second node is the same as the same operation,
For details, please refer to the patch to extract the file readme, thank you.
