oracle12c安全补丁包,12C oracle 12.1.0.2版本打补丁

从support  1454618.1文档 中可以下载到各版本的补丁和PSU。

此次采用的是28349311 版本号的psu 和28440711 版本号的jvm。opatch版本号6880880_122010

操作步骤如下:

可以不停机操作,但是最好是单个节点打的时候,先停掉一个节点做备份。一个节点一个节点的打。

停掉单个节点后。使用root 的用户备份相关文件信息,

tar  -cvf oralcle.tar   /u01

1.更新opatch

更新GRID_HOME中的OPatch

[grid@gcepdb01 ~]$ cd $ORACLE_HOME

[grid@gcepdb01 grid]$ OPatch/opatch version

opatch version

OPatch Version: 12.2.0.1.3

OPatch succeeded. [grid@gcepdb01 grid]$

[grid@gcepdb01 grid]$ ls -ld OPatch/

drwxr-xr-x 10 grid oinstall 4096 Mar 21 15:22 OPatch/

[grid@gcepdb01 grid]$

[grid@gcepdb01 grid]$ unzip /u01/software/psu_patch/p6880880_122010__Linux-x86-64.zip

... snip ...

replace OPatch/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

... snip ...

[grid@gcepdb01 grid]$ OPatch/opatch version

OPatch Version: 12.2.0.1.13

OPatch succeeded.

[grid@gcepdb01 grid]$

修改PATH环境变量,将OPatch路径加入:

[root@gcepdb01 patch]# vi /home/grid/.bash_profile

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

[root@gcepdb01 u01]# su - grid

[grid@gcepdb01 ~]$ which opatch

/grid/app/12.1.0/grid/OPatch

[grid@gcepdb01 ~]$

2.42更新ORACLE_HOME中的OPatch:

[oracle@gcepdb01 ~]$ cd $ORACLE_HOME

[oracle@gcepdb01 dbhome_1]$ OPatch/opatch version

OPatch Version: 12.2.0.1.3

OPatch succeeded.

[oracle@gcepdb01 dbhome_1]$ ls -ld OPatch/

drwxr-xr-x 8 oracle oinstall 4096 Jul 30 14:50 OPatch/

[oracle@gcepdb01 dbhome_1]$ unzip /u01/software/psu_patch/p6880880_122010__Linux-x86-64.zip

... snip ...

replace OPatch/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

... snip ...

[oracle@gcepdb01 dbhome_1]$ OPatch/opatch version

OPatch Version: 12.2.0.1.13

OPatch succeeded.

[oracle@gcepdb01 dbhome_1]$

修改PATH环境变量,将OPatch路径加入:

[root@ gcepdb01 patch]# vi /home/oracle/.bash_profile

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

2. PSU补丁安装

grid  用户  解压到当前目录

unzip  p28349311_121020_Linux-x86-64.zip

Add the directory containing the opatchauto to the $PATH environment variable. For example:

# export PATH=$PATH:/OPatch

To patch the GI home and all Oracle RAC database homes of the same version:

# opatchauto apply /28349311

To patch only the GI home:

# opatchauto apply /28349311 -oh

To patch one or more Oracle RAC database homes:

# opatchauto apply /28349311 -oh ,

这里使用     opatchauto apply /28349311 这种方式

2.1 检测当前环境是否满足

/grid/app/12.1.0/grid/OPatch/opatchauto apply /software/28349311 -analyze

检测没有报错执行

2.2 打oralce和grid 的psu

/grid/app/12.1.0/grid/OPatch/opatchauto apply /software/28349311

2.3  检查GI补丁

[gcepdb01@grid:/home/grid]$opatch lspatches

28259950;ACFS PATCH SET UPDATE 12.1.0.2.181016 (28259950)

28259914;OCW PATCH SET UPDATE 12.1.0.2.181016 (28259914)

28259833;Database Patch Set Update : 12.1.0.2.181016 (28259833)

26983807;WLM Patch Set Update: 12.1.0.2.180116 (26983807)

OPatch succeeded

2.4 检测当前环境是否能安装JVM

(PATCH_TOP_DIR) you have created above. To do so, run the following command:

$ unzip -d p28440711_12102_.zip

(Only for Installation) Determine whether any currently installed interim patches conflict with this patch 28440711 as shown as follows:

$ cd /28440711

$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

2.5 检测通过后安装oracleJVM补丁

/oracle/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch apply /software/28440711

2.6   检查oralce补丁

[gcepdb01@oracle:/home/oracle]$opatch lspatches

28440711;Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)

28259833;Database Patch Set Update : 12.1.0.2.181016 (28259833)

28259914;OCW PATCH SET UPDATE 12.1.0.2.181016 (28259914)

OPatch succeeded.

2.7 检测数据库是否正常

crsctl stat res -t

数据库正常,到此,此次补丁操作已正常完成。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值