Solved: Issue while applying patch using opatch

Dear Friends,

We are doing oracle upgrade from 10.2.0.4 to 11.2.0.3 on windows 20008

We have applied required below generic patch successfully sing opatch,

p12325243_112030_Generic.zip

p13508485_112030_Generic.zip

p13575265_112030_Generic.zip

p13580513_112030_Generic.zip

p9584028_112030_Generic.zip

p13834436_112030_Generic.zip

But we are facing issue while applying below patch

11203_Patch08_MSWIN-x86-64.zip

Log file location: C:\oracle\FNP\11203\cfgtoollogs\opatch\14223718_Oct_07_2012_0

1_45_50\apply2012-10-07_01-45-50AM_1.log

Recommended actions: OPatch needs to modify files which are being used by some p

rocesses.

OPatch failed with error code = 41

We restarted the server all the services are shutdown i double checked still same issue.

Also i would like to know what the difference between the generic patch and

11203_Patch08_MSWIN-x86-64.zip DO I HAVE TO APPLY THIS??

Kindly help to solve the issue.

Thanks

Tabrayz

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

hi Tabrayz,

please share the log (apply2012-10-07_01-45-50AM_1.log).

You can get the detail about patches from below sap note.

Note 1631931 - Oracle 11.2.0: Patches / Patch collections for 11.2.0.3

Regards,

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Abdul Jamil,

Please find below latest log.

[Oct 7, 2012 4:20:59 AM] OPatch invoked as follows: 'apply '

[Oct 7, 2012 4:20:59 AM] OUI-67077:

Oracle Home : C:\oracle\FNP\11203

Central Inventory : C:\Program Files\Oracle\Inventory

from : n/a

OPatch version : 11.2.0.3.1

OUI version : 11.2.0.3.0

OUI location : C:\oracle\FNP\11203\oui

Log file location : C:\oracle\FNP\11203\cfgtoollogs\opatch\14223718_Oct_07_2012_04_20_59\apply2012-10-07_04-20-59AM_1.log

[Oct 7, 2012 4:20:59 AM] Patch history file: C:\oracle\FNP\11203\cfgtoollogs\opatch\opatch_history.txt

[Oct 7, 2012 4:20:59 AM] Starting ApplySession at Sun Oct 07 04:20:59 PDT 2012

[Oct 7, 2012 4:20:59 AM] Starting Apply Session at Sun Oct 07 04:20:59 PDT 2012

[Oct 7, 2012 4:20:59 AM] OPatch will do the following:

[Oracle Home discovery] : Configure and Validate Oracle Home info.

[Prerequisite for apply] : Invoke prerequisites to see if patch can be applied.

[Patch conflict detection for apply patch] : Check if any conflict with already installed patches in Oracle Home.

[Oct 7, 2012 4:20:59 AM] --------------------- Oracle Home discovery ---------------------

[Oct 7, 2012 4:20:59 AM] OUI-67086:ApplySession applying interim patch '14223718' to OH 'C:\oracle\FNP\11203'

[Oct 7, 2012 4:20:59 AM] Applying interim patch '14223718' to OH 'C:\oracle\FNP\11203'

[Oct 7, 2012 4:20:59 AM] Starting to apply patch to local system at Sun Oct 07 04:20:59 PDT 2012

[Oct 7, 2012 4:21:00 AM] Verifying environment and performing prerequisite checks...

[Oct 7, 2012 4:21:02 AM] Start the Apply initScript at Sun Oct 07 04:21:02 PDT 2012

[Oct 7, 2012 4:21:02 AM] Finish the Apply initScript at Sun Oct 07 04:21:02 PDT 2012

[Oct 7, 2012 4:21:02 AM] --------------------- Prerequisite for apply ---------------------

[Oct 7, 2012 4:21:02 AM] Running prerequisite checks...

[Oct 7, 2012 4:21:02 AM] Patch "14223718" is ignored as it is not a "Fusion Applications patch".

[Oct 7, 2012 4:21:02 AM] Check if patch "14223718" is a no-op patch.

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.rdbms.tg4msql, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.rdbms.ic, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.has.cvu, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.has.crs, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] Opt. comp. not in OH inventory: oracle.usm, 11.2.0.3.0

[Oct 7, 2012 4:21:02 AM] [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.3.0 ] , [ oracle.rdbms.ic, 11.2.0.3.0 ] , [ oracle.has.cvu, 11.2.0.3.0 ] , [ oracle.has.crs, 11.2.0.3.0 ] , [ oracle.usm, 11.2.0.3.0 ]

[Oct 7, 2012 4:21:02 AM] None of the selected patches are no-op. patches..

[Oct 7, 2012 4:21:02 AM] Space Needed : 2463.222MB

[Oct 7, 2012 4:21:02 AM] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14223718

[Oct 7, 2012 4:21:02 AM] Patch 14223718: Optional component(s) missing : [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.3.0 ] , [ oracle.rdbms.ic, 11.2.0.3.0 ] , [ oracle.has.cvu, 11.2.0.3.0 ] , [ oracle.has.crs, 11.2.0.3.0 ] , [ oracle.usm, 11.2.0.3.0 ]

[Oct 7, 2012 4:21:02 AM] Following files are active :

C:\oracle\FNP\11203\oui\jlib\srvm.jar

[Oct 7, 2012 4:21:02 AM] Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following files are active :

C:\oracle\FNP\11203\oui\jlib\srvm.jar

[Oct 7, 2012 4:21:02 AM] OPatch will clean up 'restore.sh,make.txt' files and 'rac,scratch,backup' directories.

You will be still able to rollback patches after this cleanup.

Do you want to proceed? [y|n]

[Oct 7, 2012 4:21:05 AM] Y (auto-answered by -silent)

[Oct 7, 2012 4:21:05 AM] User Responded with: Y

[Oct 7, 2012 4:21:05 AM] Size of directory "C:\oracle\FNP\11203\.patch_storage" before cleanup is 9979859 bytes.

[Oct 7, 2012 4:21:05 AM] Deleting the directory "C:\oracle\FNP\11203\.patch_storage\14223718_May_21_2012_00_06_51\backup"

[Oct 7, 2012 4:21:05 AM] Deleted the directory "C:\oracle\FNP\11203\.patch_storage\14223718_May_21_2012_00_06_51\backup"

[Oct 7, 2012 4:21:05 AM] Size of directory "C:\oracle\FNP\11203\.patch_storage" after cleanup is 9979859 bytes.

[Oct 7, 2012 4:21:05 AM] UtilSession: Backup area for restore has been cleaned up. For a complete list of files/directories

deleted, Please refer log file.

[Oct 7, 2012 4:21:05 AM] [ Error during Prerequisite for apply phase ] Detail: OUI-67074:ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.

[Oct 7, 2012 4:21:05 AM] OUI-67035:System is intact, OPatch will not restore the system

[Oct 7, 2012 4:21:05 AM] Finishing ApplySession at Sun Oct 07 04:21:05 PDT 2012

[Oct 7, 2012 4:21:05 AM] Total time spent waiting for user-input is 0 seconds. Finish at Sun Oct 07 04:21:05 PDT 2012

[Oct 7, 2012 4:21:05 AM] Log file location: C:\oracle\FNP\11203\cfgtoollogs\opatch\14223718_Oct_07_2012_04_20_59\apply2012-10-07_04-20-59AM_1.log

[Oct 7, 2012 4:21:05 AM] Stack Description: oracle.opatch.PrereqFailedException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

[Oct 7, 2012 4:21:05 AM] StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)

[Oct 7, 2012 4:21:05 AM] StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:3856)

[Oct 7, 2012 4:21:05 AM] StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5932)

[Oct 7, 2012 4:21:05 AM] StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2063)

[Oct 7, 2012 4:21:05 AM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:583)

Thanks

Tabrayz

Hi Tabrayz,

You can find the file handle and identify the process at the OS level, by using process explorer. Please check the document, below;

http://support.microsoft.com/kb/232830

Best regards,

Orkun Gedik

Hi Orkun,

How to open process explorer can you please tell me the steps?

I have seen the link which you have given its asking to download process explorer.

Do i have to downlaod this on server and check??

Thanks

Tabrayz

Yes, you can download and execute the program, safely. Then, search for the filename and find the process that holding the handle of the file(s). After that you can decide whether you kill the process or not.

Best regards,

Orkun Gedik

hi Tabrayz,

OPatch failed with error code = 41

Please search the below highlighted file and rename it and then apply OPatch.

%ORACLE_HOME%\OPatch\jlib\oracle.opatch.classpath.jar

%ORACLE_HOME%\OPatch\jlib\oracle.opatch.classpath2.jar

Regards,

Hi Abdul Jamil,

Thank you so much issue os resolved after following your suggestion

Once again than you!!!

Thanks

Tabrayz

One more question

We applied generic patchs first then bundle patch is it ok? or we need to apply bundle first then generic

Thanks

Tabrayz

hi Tabrayz..

the below is sequence of oracle and its patch.

1. ORACLE Software

2. ORACLE_Patch

3. OPatch

4. Generic patch

5. MSWIN

please check above note also...

Respected Orkun... please have a look & confirm above sequence.

Regards,

Thanks !!

We followed the same

Dear Orkun,

Kindly comment

Thanks

Tabrayz

It is nice to hear the issue is resolved. The sequence is correct.

Best regards,

Orkun Gedik

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

Issue while applying patch using opatch

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: HTTP Receiver adapter with Dynamic value in UR...

How to create a rolling forecast in SAC? I have an...

In SAP Hana Cloud, do packages exist as database o...

Re: Mass Update a Zfield in Std Table with Split &...

Re: Change BW Query Initial Variable Input at runt...