由 dawei
一、准备工作
1，数据库环境
操作系统版本 : Redhat x64
数据库版本 : Oracle x64
Oracle database:
2，准备内容
OPatch : p6880880_122010_Linux-x86-
DB PSU : p24006101_121020_Linux-x86- 仅oracle12c单机使用。
二、更新OPatch
说明：更新database OPatch版本。
1. 更新OPatch版本，OPatch直接压缩替换就可以了。
(1) 上传p6880880_122010_Linux-x86-到/u01/software目录下,/u01/software给777权限。
(2) root用户下将原OPatch目录改名。
mv /u01/app/oracle/product//db_1/OPatch /u01/app/oracle/product//db_1/OPatchBK
2. oracle目录OPatch替换
(1) root用户
cd /u01/software/;chown oracle:oinstall p6880880_122010_Linux-x86-
(2) oracle用户
su - oracle
cd /u01/software/ ; unzip p6880880_122010_Linux-x86-
(3) root用户
cd /u01/software/; mv OPatch /u01/app/oracle/product//db_1/
(4) oracle用户测试
su - oracle
/u01/app/oracle/product//db_1/OPatch/opatch version
OPatch Version:
OPatch succeeded.
三、开始升级PSU
说明:
(1) 升级过程会自动关闭和启动集群。
(2) 先升级节点1 grid，再升级节点2 grid。
1. oracle用户下解压PSU补丁包
(1) root用户操作
cd /u01/software/;chown oracle:oinstall p24006101_121020_Linux-x86-
(2) oracle用户操作
# su - oracle
$ cd /u01/software/;unzip p24006101_121020_Linux-x86-
2. 测试兼容性,之前没有打过,这步也可以忽略。
su - oracle
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/24006101 -oh $ORACLE_HOME
----------------------------------------------------
Oracle Interim Patch Installer version
Copyright (c) 2016,Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product//db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product//db_1/
OPatch version :
OUI version :
Log file location : /u01/app/oracle/product//db_1/cfgtoollogs/opatch/opatch2016-12-14_00-49-41AM_
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
----------------------------------------------------
四、打database PSU补丁
1. 关闭数据库
[oracle@test ~]$ sqlplus /nolog
SQL*Plus: Release Production on Wed Dec 14 00:54:26 2016
Copyright (c) 1982,2014,Oracle. All rights reserved.
SQL> conn / as sysdba;
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
2. oracle database打补丁
$ /u01/app/oracle/product//db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/24006101
--------------------------------------------------------------
Oracle Interim Patch Installer version
Copyright (c) 2016,Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product//db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product//db_1/
OPatch version :
OUI version :
Log file location : /u01/app/oracle/product//db_1/cfgtoollogs/opatch/opatch2016-12-14_00-57-47AM_
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product//db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product//db_1'
Patching component,...
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/crs/install/tfa_setup"
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/rdbms/mesg/" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/rdbms/mesg/"
Skip copying to "/u01/app/oracle/product//db_1/rdbms/mesg/" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/rdbms/mesg/"
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/lib/" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/"
Skip copying to "/u01/app/oracle/product//db_1/lib/libccme_" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_"
Skip copying to "/u01/app/oracle/product//db_1/lib/libccme_" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_"
Skip copying to "/u01/app/oracle/product//db_1/lib/libccme_ecc_accel_" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_ecc_accel_"
Patching component,...
Applying sub-patch '20299023' to OH '/u01/app/oracle/product//db_1'
ApplySession: Optional component(s) [,] not present in the Oracle Home or a higher version is found.
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/u01/software/24006101/20299023/files/crs/install/tfa_setup"
Patching component,...
Applying sub-patch '20831110' to OH '/u01/app/oracle/product//db_1'
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/lib/libccme_ecc_accel_non_" because it is the same as
the file in incoming patch "/u01/software/24006101/20831110/files/lib/libccme_ecc_accel_non_"
Skip copying to "/u01/app/oracle/product//db_1/lib/libccme_ecc_non_" because it is the same as
the file in incoming patch "/u01/software/24006101/20831110/files/lib/libccme_ecc_non_"
Patching component,...
Applying sub-patch '21359755' to OH '/u01/app/oracle/product//db_1'
Patching component,...
Applying sub-patch '21948354' to OH '/u01/app/oracle/product//db_1'
Patching component,...
Applying sub-patch '22291127' to OH '/u01/app/oracle/product//db_1'
ApplySession: Optional component(s) [,...
Skip copying to "/u01/app/oracle/product//db_1/rdbms/admin/" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/"
Skip copying to "/u01/app/oracle/product//db_1/rdbms/admin/" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/"
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/rdbms/admin/" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/"
Applying sub-patch '23054246' to OH '/u01/app/oracle/product//db_1'
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/lib/" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/lib/"
Patching component,...
Skip copying to "/u01/app/oracle/product//db_1/bin/xmldiff" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmldiff"
Skip copying to "/u01/app/oracle/product//db_1/bin/xvm" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xvm"
Skip copying to "/u01/app/oracle/product//db_1/bin/xmlpatch" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmlpatch"
Skip copying to "/u01/app/oracle/product//db_1/bin/xsl" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xsl"
Skip copying to "/u01/app/oracle/product//db_1/bin/xmlcg" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmlcg"