| |
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.
Third, start the upgrade package GI PSU
1. premise
(1) to play the next grid root user needs to close grid (two nodes perform)
cd /u01/app/11.2.0/grid/bin
./crsctl stop has
Resolve GI PSU patch 2. 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
3. grid user under test compatibility for playing multiple CPU environment.
$ 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
-------------------------------------------------- -
Example of the following:
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.
Fourth, start the upgrade GRID
1. successively Node 1, Node 2 Master Executive.
Step 1: Execute the script must be executed, or can not succeed, ensure CRS is turned off.
Alternatively, you can view the patch README file.
[Root @ db1 bin] # /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
Using configuration parameter file: / grid / grid_home / crs / install / crsconfig_params
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully unlock / grid / grid_home
[Root @ db1 bin] #
Step 2: Download the patch (currently 11.2.0.4.8 PSU), prepare for upgrade
su - grid
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352649
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352642
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352635
Press Y during three
2. Check upgrades
$ /u01/app/11.2.0/grid/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/11.2.0/grid/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.
3. The two nodes start crs
Note: Because it is hand to play PSU, the need to manually shut down and restart operation.
# Cd /u01/app/11.2.0/grid/bin
# ./crsctl Start has
CRS-4123: Oracle High Availability Services has been started.
Five, playing patch database PSU
1. Preparations
(1) Root user, the re-patch to give permission to PSU
cd / u01 / software /
rm -rf 21523375
chown oracle: oinstall p21523375_112040_Linux-x86-64.zip
(2) oracle user
su - oracle
cd / u01 / software /; unzip p21523375_112040_Linux-x86-64.zip
(3) Oracle user under check compatibility for playing multiple CPU environment.
$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352635 -oh $ ORACLE_HOME
-------------------------------------------------- -
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home: /u01/app/oracle/product/11.2.0/db_1
Central Inventory: / u01 / app / oraInventory
from: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version: 11.2.0.3.11
OUI version: 11.2.0.4.0
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-21_09-25-57AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
-------------------------------------------------- -
2. oracle database patch or a patch with the same
su - oracle
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352635
See patch situation:
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches
Sixth, upgrade the database data dictionary
1. Start Database
(1) to play the next grid root user needs to close grid (two nodes perform)
cd /u01/app/11.2.0/grid/bin
./crsctl start has
Or directly execute the following command, while closing two nodes.
./crs_start -all
$ Sqlplus / as sysdba
SQL * Plus: Release 11.2.0.4.0 Production on Fri Mar 15 13:40:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01565: error in identifying file '+ DATA / orcl / spfileorcl.ora'
ORA-17503: ksfdopn: 2 Failed to open file + DATA / orcl / spfileorcl.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
Description: Unable to start the database through queries because oracle permissions are changed to oracle: oinstall. Resolved in the following way.
Run the following command on all nodes in the cluster Review:
# Chown oracle: asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
# Chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
SQL> startup
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2255832 bytes
Variable Size 687866920 bytes
Database Buffers 1795162112 bytes
Redo Buffers 20054016 bytes
Database mounted.
Database opened.
SQL> @? / Rdbms / admin / catbundle.sql psu apply
Wait intermediate process.
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
24-DEC-15 04.58.29.381100 PM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8
3 rows selected.
SQL>
SQL> |
|
|
|