Reducing Patch Timing Contd…

Hi Atul,

Thanks for the info.Just want to know this. Is there any way (apart from using defaults file) to hide the password for system and apps being printed while applying patch.

Appreciate your efforts here.Keep up the good work. And please do write more on RMAN.

Hi,
Apps & system password are now a days stored in obfuscated format in log files . You might be using old version. Whats ur apps version.

Atul

Hi Atul,

That

Kabz,
Nice Q’s, You need to uzip them and put entire patch directory ( for all patches you want to merge) in to source directory .

Atul

Hi,

In reply to your question “Hi,
Apps & system password are now a days stored in obfuscated format in log files . You might be using old version. Whats ur apps version.”… Just to be more clear with my question, while applying adpatch, it asks for system and apps password. When I type in the passwords, it displays them. I want to suppress the display of passwords while applying adpatch and not in the log file (yes in the log file it is obfuscated)

Apologies for Misunderstanding,
As far as I am aware I don’t the way to obfuscate password in any of ad utilities on screen. I’ll try to find answer & update here or on my blog.

I have to answer on what’s meaning of Y in FNDCPASS or FNDLOAD utilities.

Atul

to hide password use

adpatch flags=hidepw
Note: it is flags not options

Also you mention that avoid compiledb which in my opinion is wrong, forms libraries/reports are dependant on plsql objects if the objects are not valid then forms compilation takes time since it has to attempt to compile the object then.

To reduce Downtime
1. Increase Batch Size Parameter during adpatch
2. Increase ADJREMX and ADJRIMX Parameters to minimum 1 Gig so XML Uploads happen faster
3. Set parallel_max_servers to 10 in init.ora parameter.

Murali,
Thanks a lot for sharing this information with all.

Other parameters you suggested

1. Increase Batch Size Parameter during adpatch – Thats perfect.

2. Increase ADJREMX and ADJRIMX Parameters to minimum 1 Gig so XML Uploads happen faster – You need to see if you have additianl 1GB memory available on server .

3. Set parallel_max_servers to 10 in init.ora parameter.
I need to look into it how it can help in patching & how parallel max serevrs comes in to picture . Would you like to share more on this .

Murali,
About nocompiledb , Its not that if you use nocompiledb your objects will becoem invalid . They will still be valid (Only thing is database will not specifically try to compile any invalid objects ) and I agree to some extent that if underlying objects is invalid then you need to compile that database object.

Wish to hear such comments more often & I urge other readers as well to comment in case you think otherwise on any topic or want to add somthing which might be useful for others.

Atul

parallel_max_servers helps in how many threads the Upgrades happen, if you look at the Timing Report in your Development environment you can identify top time consumting jobs usually which are INV, ONT, AP, AR, GL and WF whic have tons of records. parallel_max_threshold parameter in adpatch is dependant on this.

also to reduce patching downtime for NLS Patches refer
252422.1

Thanks Murali,
I’ll wind up your suggestions together & update with your name soon in coming posts about patch timing.
Thanks once again for your inputs.

Atul

Hi Atul
Thanks for this great information ,i also wanted to know how do i find out if my patch will execute compiledb or compilejsp so that i can use the option nocompiledb or nocompilejsp.
sadiq

Sadiq,
Most of the patch execute compile db & compile jsp in end but its tough to say . You can open patch & try to read drv file .

Atul
http://teachmeoracle.com/forum

Thanx Atul for reply
sadiq

Can we merge any/all the patches??? suppose we have patches for diff products or we have diff family packs. can we use admrgpch option to merge these patches together? If no, why?

Thanks

AD patchset is exception to merging rest all other patches you can merge.
Yes you can merge different family pack patches including prereq & post req except AD

thanks for replying. 1 more question is why cant we merge AD patches with any other patches?

can we know if we can merge pre reqs of a patch with it? if yes, how does admrgpch figure out the order of applying the patches?

Yes anonymous,
You can merge patch with its prereq. Patch is collection of file (shell script, sql, jsp….) and order of applying these files (called as task).The admerge merges steps in patch task list & adpatch picks them based on file version .

Hello Atul,

We are on 11.5.10.2 and have applied ATG RUP 4 patches recently and we found that the system and apps passwords are not displayed anymore while running adpatch.

Thanks,
Dhilip Ranganathan.

Hi Atul,

Suppose i have created a merge patch with 10 no. Of patches. How to know in which sequence it is going to apply.

Regards,
Jagadish.