oracle emocmrsp,Oracle 12.1.0.1 GI+DATABASE打PSU-CSDN博客

12.1.0.1 打Patch Set Update 12.1.0.1.9 (Oct2015)

机器：两台OLE6.5的，并且安装好12.1.0.1的RAC

前期准备：下载好p6880880_121010_Linux-x86-64(OPATCH工具包)，p21551666_121010_Linux-x86-64(GI和DATABASE的PSU)

实施过程：

首先升级GI软件的OPATCH工具

su - grid

--我的p6880880_121010_Linux-x86-64放在/u01/app/opatch/目录下

cd /u01/app/opatch/

unzip p6880880_121010_Linux-x86-64

[grid@rac1 opatch]$ which crs_stat

/u01/app/grid/12.1.0.1/bin/crs_stat

--将原先的OPatch 工具进行备份

su -

cd /u01/app/grid/12.1.0.1/

mv OPatch/ OPatch_bak

---将解压好的OPatch复制到/u01/app/grid/12.1.0.1/ 进行opatch升级

mv /u01/app/opatch/OPatch/ /u01/app/grid/12.1.0.1

su - grid

[grid@rac1 OPatch]$ ./opatch version

OPatch Version: 12.1.0.1.9

OPatch succeeded.

--database软件的opatch升级

su - oracle

cd /u01/app/opatch/

--同样的以ORACLE用户来解压OPatch工具

unzip p6880880_121010_Linux-x86-64

[oracle@rac1 opatch]$ which sqlplus

/u01/app/oracle/12.1.0/db_1/bin/sqlplus

mv /u01/app/oracle/12.1.0/db_1/OPatch /u01/app/oracle/12.1.0/db_1/OPatch_bak

mv /u01/app/opatch/OPatch/ /u01/app/oracle/12.1.0/db_1

cd /u01/app/oracle/12.1.0/db_1/OPatch

[oracle@rac1 OPatch]$ ./opatch version

OPatch Version: 12.1.0.1.9

OPatch succeeded.

以上升级OPatch工具均要在两个节点上进行

接下来升级GI

升级前可以先对GI软件进行备份

su -

crsctl stop crs

然后把GI软件tar

其实就算补丁打失败了也可以rollback

cd /u01/app/grid/12.1.0.1/OPatch/ocm/bin/

[grid@rac1 bin]$ chmod u+x emocmrsp

[grid@rac1 bin]$ ./emocmrsp

OCM Installation Response Generator 10.3.7.0.0 - Production

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

The OCM configuration response file (ocm.rsp) was successfully created.

[grid@rac1 bin]$

[grid@rac1 bin]$ ls -l

total 16

-rwxr-x--- 1 grid oinstall 9063 Nov 27 2009 emocmrsp

-rw-r--r-- 1 grid oinstall 621 Oct 28 11:26 ocm.rsp

[oracle@rac1 OPatch]$ cd /u01/app/oracle/12.1.0/db_1/OPatch

[oracle@rac1 bin]$ ls -l

total 12

-rwxr-x--- 1 oracle oinstall 9063 Nov 27 2009 emocmrsp

[oracle@rac1 bin]$ chmod u+x emocmrsp

[oracle@rac1 bin]$ ls -l

total 12

-rwxr-x--- 1 oracle oinstall 9063 Nov 27 2009 emocmrsp

[oracle@rac1 bin]$./emocmrsp

OCM Installation Response Generator 10.3.7.0.0 - Production

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

The OCM configuration response file (ocm.rsp) was successfully created.

----检查每个数据库的库存信息的一致性。

/u01/app/grid/12.1.0.1/OPatch/opatch lsinventory -detail -oh /u01/app/grid/12.1.0.1

/u01/app/oracle/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/12.1.0/db_1

/u01/app/grid/12.1.0.1/OPatch/opatchauto apply /u01/app/patch/21551666 -ocmrf /u01/app/grid/12.1.0.1/OPatch/ocm/bin/ocm.rsp

--开始升级GI和database(我是GI+DATABASE一起打psu的，也可以分开打)

[root@rac1 ~]# /u01/app/grid/12.1.0.2/OPatch/opatchauto apply /u01/app/patch/21551666 -ocmrf /u01/app/grid/12.1.0.2/OPatch/ocm/bin/ocm.rsp

OPatch Automation Tool

OPatchauto Version : 12.1.0.1.9

OUI Version : 12.1.0.1.0

Running from : /u01/app/grid/12.1.0.2

opatchauto log file: /u01/app/grid/12.1.0.2/cfgtoollogs/opatchauto/21551666/opatch_gi_2015-10-28_15-21-23_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /u01/app/patch/21551666

Grid Infrastructure Patch(es): 17077442 17303297 21352619

DB Patch(es): 17077442 21352619

Patch Validation: Successful

Grid Infrastructure home:

/u01/app/grid/12.1.0.2

DB home(s):

/u01/app/oracle/12.1.0/db_1

Performing prepatch operations on CRS Home... Successful

Applying patch(es) to "/u01/app/oracle/12.1.0/db_1" ...

Patch "/u01/app/patch/21551666/17077442" successfully applied to "/u01/app/oracle/12.1.0/db_1".

Patch "/u01/app/patch/21551666/21352619" successfully applied to "/u01/app/oracle/12.1.0/db_1".

Applying patch(es) to "/u01/app/grid/12.1.0.2" ...

Patch "/u01/app/patch/21551666/17077442" successfully applied to "/u01/app/grid/12.1.0.2".

Patch "/u01/app/patch/21551666/17303297" successfully applied to "/u01/app/grid/12.1.0.2".

Patch "/u01/app/patch/21551666/21352619" successfully applied to "/u01/app/grid/12.1.0.2".

Performing postpatch operations on CRS Home... Successful

SQL changes, if any, are applied successfully on the following database(s): rac

Apply Summary:

Following patch(es) are successfully installed:

GI Home: /u01/app/grid/12.1.0.2: 17077442,17303297,21352619

DB Home: /u01/app/oracle/12.1.0/db_1: 17077442,21352619

opatchauto succeeded.

---以上步骤分别在两台机器上都要操作。

--升级完后要对数据库进行应用，RAC只要在其中一个实例上运行就可以了

su - oracle

cd $ORACLE_HOME/OPatch

./datapatch -verbose

cd $ORACLE_HOME/rdbms/admin

sqlplus / as sysdba

SQL> @utlrp.sql

set line 200

col COMMENTS for a20

col ACTION_TIME for a30

SELECT * FROM dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS

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

16-SEP-15 11.26.40.379388 AM APPLY SERVER 12.1.0.1 0 PSU Patchset 12.1.0.0.0

28-OCT-15 04.55.43.831149 PM APPLY SERVER 12.1.0.1 9 PSU PSU 12.1.0.1.9

28-OCT-15 04.55.47.057407 PM APPLY SERVER 12.1.0.1 9 PSU PSU 12.1.0.1.9

28-OCT-15 04.55.49.236190 PM APPLY SERVER 12.1.0.1 9 PSU PSU 12.1.0.1.9

28-OCT-15 04.55.50.409272 PM APPLY SERVER 12.1.0.1 9 PSU PSU 12.1.0.1.9

--查询结果是数据库已经应用了补丁了。