Oracle 12c 单机安装PSU(12.1.0.2.161018)

一、准备工作

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 , ...

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_setu