error code 74 when applying oracle CPU patches

I was asked to apply oracle 2010 Jan CPU patches to one important database server, and I wasn’t worry at all since I applied several servers days before. But today, I got error , see error message below,

————————————-

ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveF
ilesAndExecutables” failed.
System intact, OPatch will not attempt to restore the system
——————————————————————————–

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 9169460 is a superset of the patch(es) [  8307238 ] in OH D:\Oracle\ora1020
——————————————————————————–

OPatch failed with error code = 74

Execution of ‘cmd /C “D:\dowinst\2010Jan_CPU\9169460\custom\scripts\post.bat” -a
pply 9169460 ‘:

Return Code = 0

The local system has been patched and can be restarted.

——————————————————————————–

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 9169460 is a superset of the patch(es) [  8307238 ] i
n OH D:\Oracle\ora1020
2) OUI-67294:
********************************************************************************
***********
oracle Configuration Manager is installed but not configured.  OCM enables oracl
e to
provide superior, proactive support for our customers. oracle strongly recommend
s customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installati
on and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
********************************************************************************
***********

——————————————————————————–

OPatch Session completed with warnings.

OPatch completed with warnings.
————————————-

Key message,
1) OUI-67078:Interim patch 9169460 is a superset of the patch(es) [  8307238 ] in OH D:\Oracle\ora1020
OPatch failed with error code = 74

I tried hard to find a solution from network , but no good solution, and I turn to metalink, nothing useful found, and here is the solution in metalink,
—————————————–
The error message was just to let you know that the patch you are applying <#######> was a superset of previous patch(es) (<#######> and <#######>) and that it was rolling back those 2 previous patches. Review the opatch log file and verify there were no error messages after the previous patch(es) were rolled back.

The opatch log shows it ended with Return Code = 0 and there were no other ora- or error messages which means the patch was applied successfully.
—————————————–

I thought someone may apply some patches to this server, but finally, I got the reason,

there are still some processes are using oralce_HOME, you need to clean all the processes who is using/locking oracle_HOME files.

windows:
taskkill /F /IM sqlplus.exe   ## this is to kill all the sqlplus.exe process
taskkill /F /IM rman.exe
taskkill /F /PID process_id  ## if you find a process which is using some file under oracle_home, use this command to kill it.

after killing all the processes which are using/locking oracle_HOME files, apply the patch again, it runs perfectly.
So sometimes, oracle error messages are fake.

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>