http://onlineAppsDBA.com

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’s the most detailed explanation of patches I have come across as a newbie…Keep it up and going…Coming to the query part of admrgpch…Do I need to unzip/unbundle the patches in the source directory before merging them to destination???

Thankz & Regards,
Kabz

 

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.

 

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,

In using the FNDLOAD command, may i pls know how we could provide the password so while it is executing the FNDLOAD, the password is hidden through the output of ps -aex |grep

The FNDLOAD is currently being invoked from a shell script and run on backend server.

While this script is running and if a command ps -aex | grep is issued, the password parameter mentioned in the shell script with the FNDLOAD command is revealed. The client do not want this to happen and would want the password should be hidden.

Your inputs are appreciated in this regard.

Thanks,
Narasimha

 

Hi Atul,

Is there any way of finding the information of the individual patches in a merged patch set.Becuause it seems all tables like ad_patch_drivers ,ad_applied_patches etc contain the information of patch created with merge_name attributes of the admrgpch.I need the merge patch name & all the individual patch contain in the merge patch.

 

Hi Atul,
can we merge patches with different language patches?