Patching Commonly asked questions

Good work…keep going

The blog is good,but your web site is better.Waiting to see the updates there.
Sam
http://appstech-sam.blogspot.com

Hi Atul
While Patching, As Per documents
1. We have to set the environment variables
2. We should enable Maintenance Mode
3. Stop Services (current Mgr, Forms Server, web server)
4. Apply Patches thru ad Patch (As per Read me file) & review the log files
5. Disable Maintenance Mode (adadmin)
My seniors skipped 1 & 3.
Please explain why he had skip the above 1 & 3 steps
Thanks & Regards
KK

KK,
Thats very valid question . No you should never skip setting Environment Variables. Since mostly env. variable files are called from user profile so as soon as you login to applications from o.s. user it automatically sets environment variables thats why ur seniors might not be seeting env. variables.

Enable maintenance mode was introduced in I suppose Ad.I.2 you can skip that by option=hotpatch so like adpach options=hotpatch

There is no need to stop services but if your patch changes any executable which your services might be using you see unexpected behaviour during patch applications.

Oracle is recommending to stop but its not necessary so for a starter its better to stop services & as you grow in apps dba you can decide to stop or not

Atul
http://teachmeoracle.com

This is my first post/comment on ur blog..I must say Hats-Off to u…Keep up the good work..Coming to the query part?? can u put some light on .lgi files which are created along with .log files during patch application…

Thankz and Regards
Kabz

Kabz,
Thanks a lot for your compliments. Coming to your query about lgi file while patch , I can never forget this question because I was not aware of this five years ago when someone asked me this question during Apps Interview 🙂

lgi stands for log information ( lgi ) this stores informative message while patching which can be helpful to understand what patch is actually doing. Though I never came across anyone till now who ever opened this file.

Atul

Hi Atul,
Is there a way we can login when maintence mode is on??

Hi Atul,
Is there a way we can login when maintence mode is on??

Yes you can login but application will behave strangely like responsibility missing or functions/menus not available

Hi,

Can we get the date/time as when we’ve applied the patches on apps environments?

Thanks,

Arvind

@ Arvind,
Yes this is possible , check patch history from OAM (Oracle Application Manager)

or

patch history table apps.ad_bugs (column LAST_UPDATE_DATE)

Hi,

I have applied MLR#8 over the SOA 10.1.3.4. After applying the patch the BPEL console does not allow to initiate a BPEL process. It throws “java.io.IOException: Failed to read WSDL from http://host:port/orabpel/default/BPEL_HELLOWORLD/1.0/BPEL_HELLOWORLD.xsd:WSDL not found”. This is the same case with all the deployed BPEL Processes. When checked the status
opmnct status -app
Shows that the orabpel is down. How do I resolve this issue.

Thanks in advance

@ Deeksha,
Could you please post patch number for MLR#8 for SOA 10.1.3.4 which you applied ?

Hi Atul,
I am not able to unzip the patch that I have copied to my node.I gave all permissions but still I am not able to unzip the patch.
issue:
either this file is not a zipfile or it constitutes one disk of multi part archive.

and it is giving like patch is a plain executable

can you give the reason for thai and how to solve the issue in 11i.

Thanks.

@ S.KAKOLLU,
This means patch did not download properly. Download again

Hi Atul, I am trying to apply hrglobal.drv patch using adpatch utility. Is there a syntax I need to use? I ran adpatch but its been running for some time, I did not provide any parameter. Please let me know.