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

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

0

积分

0

好友

5

主题
1#
发表于 2013-1-22 12:44:48 | 查看: 4560| 回复: 5
本帖最后由 KFC 于 2013-1-22 12:49 编辑

平台redhat5.5+11g r2(2.0.2)x86_64,2个节点,测试机
操作内容:11.2.0.2升级到11.2.0.2.3

在1节点执行没什么异常
2节点执行如下:
[grid@racnode2 OPatch]$  /u01/app/11.2.0/grid/OPatch/opatch napply -oh  /u01/app/11.2.0/grid -local /home/grid/patc/12419353
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.2.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-01-22_11-01-11AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   12419353  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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



Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '12419353' to OH '/u01/app/11.2.0/grid'

Patching component oracle.crs, 11.2.0.2.0...

Copy failed from '/home/grid/patc/12419353/files/bin/crsd.bin' to '/u01/app/11.2.0/grid/bin/crsd.bin'...  
Please verify all applications associated with the Oracle Home '/u01/app/11.2.0/grid' are shut down. If this is AIX, please perform solution documented in Note 739963.1 on https://myoraclesupport.oracle.com.

Do you want to retry copying the file? [y|n]

OPatch failed with error code 130  --这步执行了ctrl+c导致

停完相关服务再次执行报
[grid@racnode2 OPatch]$  /u01/app/11.2.0/grid/OPatch/opatch napply -oh  /u01/app/11.2.0/grid -local /home/grid/patc/12419353
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.2.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-01-22_11-12-31AM_1.log

OPatchSession cannot load inventory for the given Oracle Home /u01/app/11.2.0/grid. 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: Lock file left by a different patch, OPatch will not try re-using the lock file.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-01-22_11-12-31AM_1.log

OPatch failed with error code 73


2#
发表于 2013-1-22 13:10:38
UtilSession failed: Lock file left by a different patch
The lock file exists in ORACLE_HOME/.patch_storage

执行:

cd $ORACLE_HOME/.patch_storage

ls -l

回复 只看该作者 道具 举报

3#
发表于 2013-1-22 13:13:30
本帖最后由 KFC 于 2013-1-22 13:15 编辑

[grid@racnode2 ~]$ cd $ORACLE_HOME/.patch_storage
[grid@racnode2 .patch_storage]$ ls -l
total 24
drwxr-xr-x 6 grid oinstall 4096 Jan 22 11:01 12419353_Jul_17_2011_08_05_53/
-rw-r--r-- 1 grid oinstall 1861 Jan 22 11:01 interim_inventory.txt
-rw-r--r-- 1 grid oinstall   93 Jan 22 11:01 LatestOPatchSession.properties
drwxr-xr-x 3 grid oinstall 4096 Jan 22 11:01 NApply/
-rw-r--r-- 1 grid oinstall   56 Jan 22 11:01 patch_locked
-rw-r--r-- 1 grid oinstall   52 Jan 22 11:01 record_inventory.txt

回复 只看该作者 道具 举报

4#
发表于 2013-1-22 13:14:14
果然有两组日志

回复 只看该作者 道具 举报

5#
发表于 2013-1-22 13:16:23
把  patch_locked rm掉 然后重试

回复 只看该作者 道具 举报

6#
发表于 2013-1-22 14:06:18
可以了,thank you!

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-16 08:45 , Processed in 0.047689 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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