Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

13

积分

0

好友

4

主题
1#
发表于 2013-6-3 16:38:39 | 查看: 4281| 回复: 1
本帖最后由 dba.liu 于 2013-6-3 21:38 编辑

oracle 11g单实例使用asm需要先安装grid,用来管理asm。按照10g RAC的习惯,打PSU是crs和db要分别打上。
但是这种11g单实例的情况,打PSU的话,grid要打什么PSU?

使用Grid PSU安装时报错:
# /oracle/grid/11.2.0.3/OPatch/./opatch auto 16083653 -oh /oracle/grid/11.2.0.3 -ocmrf /oracle/grid/11.2.0.3/OPatch/ocm/bin/config.rsp
Executing /oracle/grid/11.2.0.3/perl/bin/perl /oracle/grid/11.2.0.3/OPatch/./crs/patch11203.pl -patchdir . -patchn 16083653 -oh /oracle/grid/11.2.0.3 -ocmrf /oracle/grid/11.2.0.3/OPatch/ocm/bin/config.rsp -paramfile /oracle/grid/11.2.0.3/crs/install/crsconfig_params
/oracle/grid/11.2.0.3/crs/install/crsconfig_params
/oracle/grid/11.2.0.3/crs/install/s_crsconfig_defs

This is the main log file: /oracle/grid/11.2.0.3/cfgtoollogs/opatchauto2013-06-03_16-12-51.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle/grid/11.2.0.3/cfgtoollogs/opatchauto2013-06-03_16-12-51.report.log

2013-06-03 16:12:51: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/grid/11.2.0.3/crs/install/crsconfig_params
Clusterware is either  not running or not configured. You have the following 2 options
1. Configure and Start the Clusterware on this node and re-run the tool
2. or Run the tool with the -och <CRS_HOME_PATH> option and then invoke  tool with -oh <comma seperated ORACLE_HOME_LIST> to patch the RDBMS home

改用-och
# /oracle/grid/11.2.0.3/OPatch/./opatch auto 16083653 -ocmrf /oracle/grid/11.2.0.3/OPatch/ocm/bin/config.rsp -och /oracle/grid/11.2.0.3
Executing /oracle/grid/11.2.0.3/perl/bin/perl /oracle/grid/11.2.0.3/OPatch/./crs/patch11203.pl -patchdir . -patchn 16083653 -ocmrf /oracle/grid/11.2.0.3/OPatch/ocm/bin/config.rsp -och /oracle/grid/11.2.0.3 -paramfile /oracle/grid/11.2.0.3/crs/install/crsconfig_params
/oracle/grid/11.2.0.3/crs/install/crsconfig_params
/oracle/grid/11.2.0.3/crs/install/s_crsconfig_defs

This is the main log file: /oracle/grid/11.2.0.3/cfgtoollogs/opatchauto2013-06-03_16-13-51.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle/grid/11.2.0.3/cfgtoollogs/opatchauto2013-06-03_16-13-51.report.log

2013-06-03 16:13:51: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/grid/11.2.0.3/crs/install/crsconfig_params
Successfully unlock /oracle/grid/11.2.0.3
The opatch Applicable check failed for /oracle/grid/11.2.0.3.  The patch is not applicable for /oracle/grid/11.2.0.3
patch ./16083653/16315641  apply failed  for home  /oracle/grid/11.2.0.3
CRS-4123: Oracle High Availability Services has been started.


如果使用RDBMS的PSU来安装,则一直提示.patch_storage被锁:
$ /oracle/grid/11.2.0.3/OPatch/./opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/grid/11.2.0.3
Central Inventory : /oracle/oraInventory
   from           : /oracle/grid/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /oracle/grid/11.2.0.3/cfgtoollogs/opatch/opatch2013-06-03_16-26-45PM_1.log

OPatchSession cannot load inventory for the given Oracle Home /oracle/grid/11.2.0.3. Possible causes are:
   No read or write permission to ORACLE_HOME/.patch_storage
   Central Inventory is locked by another OUI instance
   No read permission to Central Inventory
   The lock file exists in ORACLE_HOME/.patch_storage
   The Oracle Home does not exist in Central Inventory

UtilSession failed: Locker::lock() mkdir /oracle/grid/11.2.0.3/.patch_storage
Log file location: /oracle/grid/11.2.0.3/cfgtoollogs/opatch/opatch2013-06-03_16-26-45PM_1.log

OPatch failed with error code 73

至于ORACLE DB HOME的PSU则顺利安装完成。


2#
发表于 2013-6-5 09:59:01
后来发现是/oracle/grid/11.2.0.3/.patch_storage的11.2.0.3的目录权限问题,修改后已经安装上,用的是DB的PSU。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 19:06 , Processed in 0.063494 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569