oracle11g rac psu,Oracle11g rac 打PSU

racle11g rac psu,Oracle11g rac 打PSU"/>

oracle11g rac psu,Oracle11g rac 打PSU

1:升级Opatch

到OPatch目录下：

备份之前的OPatch目录：

mv OPatch/  /tmp/OPatch_20150922

unzip  ***

opatch version

2:升级grid

(1) root用户下打grid需要关闭grid(两节点都执行)

cd /u01/app/11.2.0/grid/bin

./crsctl stop cluster

(2):

grid用户下测试兼容性，针对多次打CPU的环境中

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir

/u01/software/21523375/21352649 -oh $ORACLE_HOME

输出:

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

(3):

开始升级GRID

依次节点1，节点2上人执行

第1步: 执行脚本, 一定要执行，否则无法成功，确保CRS是关闭状态

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

输出:

Using configuration parameter file: /grid/grid_home/crs/install/crsconfig_params

CRS-4544: Unable to connect to OHAS

CRS-4000: Command Stop failed, or completed with errors.

Successfully unlock /grid/grid_home

(4):解压补丁包升级:

su - grid

/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/21523375/21352649

过程中按照提示输入:

./opatch version

./opatch lsinventory

opatch lspatches

(5):两节点启动crs

# ./crsctl start has

3:  打database PSU补丁

Oracle用户下检查兼容性,针对多次打CPU的环境中

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir

/u01/software/21523375/21352635 -oh $ORACLE_HOME

打PSU:

su - oracle

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local

/u01/software/21523375/21352635

升级数据库数据字典

3:更新dba_registry_history视图信息

SQL>@?/rdbms/admin/catbundle.sql psu apply

SQL>select action_time,action,namespace,version,id from dba_registry_history;

注:如果启动数据库时报错:请更改权限:

SQL> startup

ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora

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

ORA-15040: diskgroup is incomplete

ORA-15040: diskgroup is incomplete

ORA-15040: diskgroup is incomplete

说明：无法启动数据库，经过查询是因为oracle权限被更改为oracle:oinstall。通过如下方式解决。

在集群的所有节点上执行如下命令修改：

# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle

# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

阅读(700) | 评论(0) | 转发(0) |