Oracle11.2.0.4.5升级psu至11.2.0.4.160119的注意事项

大家好，我是讯享网，很高兴认识大家。

需求描述：

因第三方监控软件扫描出当前数据库存在漏洞，客户方要求升级数据库至最新补丁。

当前版本：Oracle 11.2.0.4.5

升级后补丁：Oracle 11.2.0.4.

升级前准备：

安装此psu前，需停止所有节点数据库实例、EM及退出所有sqlplus界面（否则将报错某些进程被占用or active）

grid$ srvctl stopdatabase -d db_name

node1.oracle$export ORACLE_UNQNAME=db_name

node1.oracle$emctl stop dbconsole

升级补丁日志：

执行opatch apply打补丁的过程日志（略）：

Patching componentoracle.rdbms.rman, 11.2.0.4.0...

Patching componentoracle.rdbms, 11.2.0.4.0...

Verifying theupdate...

Applying sub-patch'' to OH '/u02/app/oracle/product/11.2.0home_1'

ApplySession:Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higherversion is found.

Patching componentoracle.sysman.agent, 10.2.0.4.5...

Patching componentoracle.ovm, 11.2.0.4.0...

Patching componentoracle.xdk, 11.2.0.4.0...

Patching componentoracle.rdbms, 11.2.0.4.0...

Patching componentoracle.nlsrtl.rsf, 11.2.0.4.0...

Patching componentoracle.xdk.parser.java, 11.2.0.4.0...

Patching componentoracle.sysman.console.db, 11.2.0.4.0...

Patching componentoracle.xdk.rsf, 11.2.0.4.0...

Patching componentoracle.rdbms.rsf, 11.2.0.4.0...

Patching componentoracle.sysman.oms.core, 10.2.0.4.5...

Verifying theupdate...

...

Patching inrolling mode.

The node 'rac2'will be patched next.

Please shutdownOracle instances running out of this ORACLE_HOME on 'rac2'.

(Oracle Home ='/u02/app/oracle/product/11.2.0home_1')

Is the node readyfor patching? [y|n]

升级中（后）发现的问题：

在执行opatch apply过程中，$ORACLE_HOME/bin下的oracle文件属组发生变化（由oracle:asmadmin变为oracle:oinstall）

cd$ORACLE_HOME/bin

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle asmadmin Mar 16 02:58 oracle

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle asmadmin Mar 16 02:58 oracle

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle asmadmin Mar 16 02:58 oracle

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle asmadmin Mar 16 02:58 oracle

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1 oracle asmadmin Mar 16 02:58oracle

[oracle@rac1 bin]$ll oracle <<<<<<--此时oracle文件属组由oracle:asmadmin变为oracle:oinstall

-rwsr-s--x 1 oracle oinstall Mar 16 03:46oracle

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle oinstall Mar 16 03:46 oracle

[oracle@rac1 bin]$

执行完opatch apply后，此时启动两节点数据库均报错如下：

SQL> startup

ORACLE instancestarted.

Total SystemGlobal Area bytes

Fixed Size bytes

Variable Size bytes

DatabaseBuffers bytes

Redo Buffers bytes

ORA-00205: errorin identifying control file, check alert log for more info

后台alert日志报错如下：

Wed Mar 1603:49:24 2016

Startingbackground process RSMN

Wed Mar 1603:49:24 2016

RSMN started withpid=31, OS id=6430

ORACLE_BASE fromenvironment = /u02/app/oracle

Wed Mar 1603:49:26 2016

ALTERDATABASE MOUNT

NOTE: Loadedlibrary: System

ORA-15025: couldnot open disk "/dev/raw/raw4"

ORA-27041: unableto open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

SUCCESS: diskgroupDATA was dismounted

ERROR: diskgroupDATA was not mounted

ORA-00210: cannotopen the specified control file

ORA-00202: controlfile: '+DATA/orcl/controlfile/current.260.'

ORA-17503:ksfdopn:2 Failed to open file +DATA/orcl/controlfile/current.260.

ORA-15001:diskgroup "DATA" does not exist or is not mounted

ORA-15040:diskgroup is incomplete

ORA-205 signalledduring: ALTER DATABASE MOUNT...

Wed Mar 1603:49:33 2016

ALTER SYSTEM SETlocal_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.115)(PORT=1521))'SCOPE=MEMORY SID='orcl1';

解决办法：

此时需要在grid用户下执行如下操作修改此文件的属组：

[root@rac1 bin]#su - grid

[grid@rac1 ~]$ cd$ORACLE_HOME/bin

[grid@rac1 bin]$./setasmgidwrap o=/u02/app/oracle/product/11.2.0home_1/bin/oracle

[grid@rac1 bin]$exit

logout

[root@rac1 bin]#su - oracle

[oracle@rac1 ~]$cd $ORACLE_HOME/bin

[oracle@rac1 bin]$ll oracle

-rwsr-s--x 1oracle asmadmin Mar 16 03:48 oracle

[root@rac1 bin]#su - grid

[grid@rac1 ~]$srvctl stop instance -d orcl -i orcl1

[grid@rac1 ~]$

SQL> startup

ORACLE instancestarted.

讯享网

Total System GlobalArea bytes

Fixed Size bytes

Variable Size bytes

DatabaseBuffers bytes

Redo Buffers bytes

Database mounted.

Database opened.

此时两节点数据库实例均启动成功。

验证补丁安装成功：

[oracle@*OPatch]$ ./opatch lsinventory

Oracle InterimPatch Installer version 11.2.0.3.4

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

OPatchversion : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log file location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-23_10-25-31AM_1.log

Lsinventory Outputfile location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-03-23_10-25-31AM.txt

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

InstalledTop-level Products (1):

Oracle Database11g 11.2.0.4.0

There are 1products installed in this Oracle Home.

Interim patches(1) :

Patch : applied on Mon Mar 14 17:18:05 CST 2016

Unique PatchID:

Patch description: "Database Patch Set Update : 11.2.0.4. ()"

Created on 14 Dec 2015, 03:31:48 hrs PST8PDT

Sub-patch ; "Database Patch Set Update :11.2.0.4.8 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.7 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.6 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.5 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.4 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.3 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.2 ()"

Sub-patch ; "Database Patch Set Update :11.2.0.4.1 ()"

Bugs fixed:

, , , ,, ,

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

OPatch succeeded.

参考MOS文章如下：

Database Will NotMount: ORA-15025, ORA-27041, 'Permission denied', ORA-15081 (文档 ID .1)

参考PSU readme.html文件完成剩余步骤（略）

Oracle11.2.0.4.5升级psu至11.2.0.4.160119的注意事项

相关推荐