Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g RAC automatically play GI PSU patch (11.2.0.4.8)     - Oracle DataGuard principles and basic configuration (Database)

- Security experience: to see how the experts deal with DDoS attacks (Linux)

- iTerm - let your command line can also be colorful (Linux)

- Let OS X support NTFS write file (Linux)

- Oracle database physical file backup / restore (Database)

- How Vim playing a mature IDE (Linux)

- Laravel configuration PhpStorm + Xdebug + Chrome settings Debug Environment (Server)

- Single Instance ASM under CRS-4124, CRS-4000 error handling (Database)

- Nginx + uWSGI + Django + Python Application Architecture Deployment (Server)

- Ubuntu 14.04 VirtualBox can not start solution (Linux)

- Shell commonly commands (Linux)

- Eclipse remove all comments and code spaces (Linux)

- Android basics summary article (Programming)

- git checkout generated in the use of temporary br (Linux)

- Why learn Java EE (Programming)

- Android screen rotation processing and ProgressDialog the best AsyncTask (Programming)

- PostgreSQL query lock and kill the process (Database)

- IIS virtual host of safety knowledge (Linux)

- Linux Shell Scripting multithreading (Programming)

- Kibana use installation (Linux)

 
         
  Oracle 11g RAC automatically play GI PSU patch (11.2.0.4.8)
     
  Add Date : 2018-11-21      
         
         
         
  First, the preparatory work

1, the database environment

Operating system version: RedHat 6.5 x64
Database version: Oracle 11.2.0.4 x64 RAC
Grid: 11.2.0.4
Oracle database: 11.2.0.4

2, ready to content

GI PSU: p21523375_112040_Linux-x86-64.zip
OPatch: p6880880_112000_Linux-x86-64.zip
DB PSU: p21352635_112040_Linux-x86-64.zip only a single instance.

OPatch Download:
https://updates.oracle.com/download/6880880.html

Description: GI PSU include DB PSU, CPU.

Second, update OPatch version must be updated

Description: OPatch version were updated two nodes.

1. Update OPatch version needs to be updated to 11.2.0.3.11, OPatch direct compression replace it.

(1) Upload p6880880_112000_Linux-x86-64.zip to / u01 / software directory, / u01 / software to 777 can also be used the / tmp directory.
(2) root user directory under the original OPatch renamed.

mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk
mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK

2. grid replacement OPatch directory

(1) root user
cd / u01 / software /; chown grid: oinstall p6880880_112000_Linux-x86-64.zip

(2) grid users

su - grid
cd / u01 / software /
unzip p6880880_112000_Linux-x86-64.zip

(3) root user

cd / u01 / software /
mv OPatch /u01/app/11.2.0/grid/

(4) grid user testing

su - grid
/u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

3. oracle directory OPatch replacement

(1) root user

cd / u01 / software /; chown oracle: oinstall p6880880_112000_Linux-x86-64.zip

(2) oracle user

su - oracle
cd / u01 / software /
unzip p6880880_112000_Linux-x86-64.zip

(3) root user

cd / u01 / software /
mv OPatch /u01/app/oracle/product/11.2.0/db_1/

(4) oracle user testing

su - oracle

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

Three, respectively, in Node 1 and Node 2 are generated ocm.rsp file.

# Su - oracle

$ Cd / u01 / software
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp
$ Ls

ocm.rsp

 

Fourth, start the upgrade package GI PSU

Note: Be sure to follow the order of a node of a fight.

Resolve GI PSU patch 1. grid user under

(1) root user operation

cd / u01 / software /; chown grid: oinstall p21523375_112040_Linux-x86-64.zip

(2) grid user operation

su - grid
cd / u01 / software /
unzip p21523375_112040_Linux-x86-64.zip

 

2. Compatibility Test

su - grid

$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352649 -oh $ ORACLE_HOME
$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352642 -oh $ ORACLE_HOME
$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352635 -oh $ ORACLE_HOME

Process skip ...

3, start the upgrade GRID

1 user root node sequentially executed on node 2.

# /u01/app/11.2.0/grid/OPatch/opatch Auto / u01 / software / 21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir / u01 / software -patchn 21523375 -oh / u01 / app /11.2.0/grid/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-12-25_10-09-05.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/cfgtoollogs/opatchauto2015-12-25_10-09-05.report.log

2015-12-25 10:09:05: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS ...
Stopped CRS successfully

patch / u01 / software / 21523375/21352635 apply successful for home /u01/app/11.2.0/grid
patch / u01 / software / 21523375/21352649 apply successful for home /u01/app/11.2.0/grid
patch / u01 / software / 21523375/21352642 apply successful for home /u01/app/11.2.0/grid

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

opatch auto succeeded.

 

4. Check upgrades

# Su - grid

$ /u01/app/11.2.0/grid/OPatch/opatch Lsinv
                                                    
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.


Oracle Home: /u01/app/11.2.0/grid
Central Inventory: / u01 / app / oraInventory
  from: /u01/app/11.2.0/grid/oraInst.loc
OPatch version: 11.2.0.3.11
OUI version: 11.2.0.4.0
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-25_10-31-49AM_1.log

Lsinventory Output file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-12-25_10-31-49AM.txt

-------------------------------------------------- ------------------------------
Local Machine Information ::
Hostname: db1
ARU platform id: 226
ARU platform description :: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.


Interim patches (3):

Patch 21352642: applied on Fri Dec 25 10:22:50 CST 2015
Unique Patch ID: 19203841
Patch description: "ACFS Patch Set Update: 11.2.0.4.8 (21352642)"
  Created on 3 Sep 2015, 00:03:11 hrs PST8PDT
  Bugs fixed:
    17510275, 21369858, 17172303, 16318126, 19690653, 18610307, ​​17503605
    17376318, 17203009, 20140148, 17721778, 17611362, 17164243, 19053182
    17696547, 17699423, 17488768, 18915417, 18155334, 19919907, 18321597
    18185024, 18168684, 17363999, 17636008, 18143006, 17428148, 20681968
    17,070,158, 17,475,946

Patch 21352649: applied on Fri Dec 25 10:19:11 CST 2015
Unique Patch ID: 19203841
Patch description: "OCW Patch Set Update: 11.2.0.4.8 (21352649)"
  Created on 2 Sep 2015, 23:43:49 hrs PST8PDT
  Bugs fixed:
    19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548
    17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892
    17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403
    17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001
    17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869
    18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251
    20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120
    16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690
    20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658
    18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091
    20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545
    18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838
    17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155
    19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223
    14671408, 18272135, 14207615, 17500165, 18875012, 18464784, 19558324
    18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825
    17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489
    17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493
    18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173
    18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968
    15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321
    16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500
    16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968
    16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761
    18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588
    16,798,862, 15,920,201

Patch 21352635: applied on Fri Dec 25 10:16:29 CST 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update: 11.2.0.4.8 (21352635)"
  Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set Update: 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update: 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update: 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update: 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update: 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update: 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514)"
  Bugs fixed:
    17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
    17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
    16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815
    17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514
    18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165
    18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060
    17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456
    16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271
    18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473
    18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480
    17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252
    13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721
    19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502
    20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582
    16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449
    17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721
    16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434
    19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943
    17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355
    18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574
    17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762
    16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426
    21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382
    20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544
    18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048
    16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
    16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
    18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975
    17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
    18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
    17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
    19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
    18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
    17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
    13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
    17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
    18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
    18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905
    18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
    17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
    19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514
    16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583
    18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
    17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
    16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
    16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
    16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536
    18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
    17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570
    17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576
    14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278
    17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259
    20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858
    17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213
    16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603
    16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511
    17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061

 

Rac system comprising of multiple nodes
  Local node = db1
  Remote node = db2

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

OPatch succeeded.

$ /u01/app/11.2.0/grid/OPatch/opatch Lspatches

21352642; ACFS Patch Set Update: 11.2.0.4.8 (21352642)
21352649; OCW Patch Set Update: 11.2.0.4.8 (21352649)
21352635; Database Patch Set Update: 11.2.0.4.8 (21352635)

OPatch succeeded.

 

Five, playing patch database PSU

1. Preparations

(1) Root user, the re-patch to give permission to PSU

cd / u01 / software /; chown oracle: oinstall p21523375_112040_Linux-x86-64.zip


(2) oracle user

su - oracle
cd / u01 / software /
unzip p21523375_112040_Linux-x86-64.zip


2. Oracle user under check compatibility

$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352635 -oh $ ORACLE_HOME

-------------------------------------------------- -
Example:
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home: /u01/app/11.2.0/grid
Central Inventory: / u01 / app / oraInventory
  from: /u01/app/11.2.0/grid/oraInst.loc
OPatch version: 11.2.0.3.11
OUI version: 11.2.0.4.0
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-18_16-21-46PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
-------------------------------------------------- -

 

3. Turn on the automatic patch root user and then click Node 1, Node 2 Master Executive.

# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch Auto / u01 / software / 21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf / u01 / software / ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir / u01 / software -patchn 21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.log

This 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/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.report.log

2015-12-25 10:43:07: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

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

patch / u01 / software / 21523375/21352635 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch / u01 / software / 21523375/21352649 / custom / server / 21352649 apply successful for home /u01/app/oracle/product/11.2.0/db_1

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

opatch auto succeeded.

 

4. Check upgrades

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch Lsinv
                                                    
Patch 21352635: applied on Fri Dec 18 17:38:24 CST 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update: 11.2.0.4.8 (21352635)"
  Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set Update: 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update: 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update: 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update: 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update: 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update: 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514)"
  Bugs fixed:
...

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch Lspatches

21352635; Database Patch Set Update: 11.2.0.4.8 (21352635)
21352642; ACFS Patch Set Update: 11.2.0.4.8 (21352642)
21352649; OCW Patch Set Update: 11.2.0.4.8 (21352649)
OPatch succeeded.

Sixth, upgrade the database data dictionary

Database startup and load the database to modify the SQL Files

$ Sqlplus / as sysdba
  
SQL * Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select open_mode from v $ database;

OPEN_MODE
--------------------
READ WRITE

SQL>
SQL>

SQL> @? / Rdbms / admin / catbundle.sql psu apply

SQL>
After the implementation of our updated information can be found PSU:
SQL>

set line 150
col ACTION_TIME for a30
col ACTION for a8
col NAMESPACE for a8
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a20
select * from dba_registry_history;
 

ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---- ------ ---------- ----- --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
22-DEC-15 03.53.27.330912 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
25-DEC-15 11.54.19.486765 AM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8

3 rows selected.

SQL>

Section: Auto play is quite smooth, no problems manually play in this record.
     
         
         
         
  More:      
 
- Present Situation and Development Trend of firewall products (Linux)
- Whisker Menu 1.4.3 Install menu Linux (Linux)
- Analysis of C ++ exception mechanism (Programming)
- Related to optimize the use of Btrfs file system on SSD (Linux)
- Java garbage collection (Programming)
- The difference between Linux su and sudo commands (Linux)
- Use MD5 transform algorithm to prevent exhaustive decipher passwords (Linux)
- RedHat Linux 6 desktop installation (Linux)
- Netcat Example (Linux)
- Linux ps command (Linux)
- File permissions under Linux (Linux)
- OpenGL Superb Learning Notes - Depth Texture and Shadows (Programming)
- C ++ Supplements - Virtual Function Principle (Programming)
- Linux netstat command to get started (Linux)
- HDFS Hadoop Distributed File System Works (Server)
- Installation Yarock 1.1.4 Music Player in Ubuntu (Linux)
- Eclipse Android development environment installation (Linux)
- Oracle Database Performance Optimization of memory disk (Database)
- FFmpeg compiled with only H264 decoding library (Programming)
- Ubuntu 14.04 can be used to create a WIFI hotspot for Android (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.