11G RAC安装PSU补丁

所有节点都需要执行

解压opatch root用户 两节点都执行


unzip -o opatch.zip -d /opt/o<wiz_tmp_highlight_tag class="cm-searching">racle/products/11.2.0
unzip -o opatch.zip -d /opt/grid/products/11.2.0
chown -R grid.oinstall /opt/grid/products/11.2.0/OPatch
chown -R o<wiz_tmp_highlight_tag class="cm-searching">racle.oinstall /opt/o<wiz_tmp_highlight_tag class="cm-searching">racle/products/11.2.0/OPatch
/opt/grid/products/11.2.0/OPatch/opatch version
/opt/o<wiz_tmp_highlight_tag class="cm-searching">racle/products/11.2.0/OPatch/opatch version

解压patch root用户 

unzip -o PSU.zip -d /opt/grid
chown -R grid.oinstall /opt/grid/25476126
chmod -R 777 /opt/grid/25476126
安装PSU
su - grid
cd /opt/grid/products/11.2.0/OPatch/ocm/bin
./emocmrsp
 直接回车即可不用输入用户名之类的东西
su root  (使用grid的环境变量)两节点都执行执行完一节点后再次执行二节点 
opatch auto /opt/grid/25476126 -ocmrf /opt/grid/products/11.2.0/OPatch/ocm/bin/ocm.rsp
两个节点的<wiz_tmp_highlight_tag class="cm-searching">RAC安装PSU完成
当两个节点都安装完成后在一个节点上去执行以下操作即可

安装数据字典
待所有<wiz_tmp_highlight_tag class="cm-searching">RAC节点都安装完PSU后,开始进行升级数据字典的操作,只需要在一个<wiz_tmp_highlight_tag class="cm-searching">RAC节点执行。注意退出后使用O<wiz_tmp_highlight_tag class="cm-searching">racle用户去登录
cd $O<wiz_tmp_highlight_tag class="cm-searching">RACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> @catbundle.sql psu apply
SQL> QUIT
编译失效对象
O<wiz_tmp_highlight_tag class="cm-searching">racle用户登录dba下查询

select count(*) from dba_oBJECTs where status ='INVALID';(如果没有就不用执行以下操作)

cd $O<wiz_tmp_highlight_tag class="cm-searching">RACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> @utlrp.sql

select * from v$version ;

检查数据字典升级:
O<wiz_tmp_highlight_tag class="cm-searching">racle用户登录dba下查询
set line 150

col ACTION_TIME for a30

col ACTION for a8

col NAMESPACE for a8

col VERSION for a10

col BUNDLE_SERIES for a5

col COMMENTS for a20

select * from dba_registry_history;
查询完毕后显示结果正常PSU已安装完毕
posted @ 2017-10-19 14:48  Sean.Biang  阅读(1391)  评论(0编辑  收藏  举报