Pythian has openings for MySQL and MS SQL Server DBAs in each of our offices in Ottawa, Canada; Boston, USA; Dubai, UAE; and Hyderabad, India. If you are a MySQL and/or SQL Server DBA and would like to evaluate this opportunity, please send us your résumé with an introductory paragraph to hr@pythian.com.

What’s New in 11i TXK AutoConfig and Templates Rollup Patch S

By Vasu Balla May 10th, 2008 at 12:51 pm
Posted in Group Blog PostsOracle E-Business Suite
Tags:

You might have already seen the blog update on Steven Chan’s site. TXK AutoConfig and Templates Rollup Patch S (6372396) was released on May 5th.

This patch differs from traditional TXK autoconfig template patch releases in that the ATG team decided to include some other important TXK patches also with this release. One of these is TXK Advanced Utilities Rollup Patch C (5011249).

This Advanced Utilities patch brings some import scripts that can be used to implement advanced topologies. The important benefit here is that these scripts can be run from command line. For complete details, refer to Metalink note 277574.1, Running Configuration Wizards from the Command Line in Oracle Applications 11i.

As a side effect of this generous inclusion of import updates, the patch size has increased from 16mb (RUP R) to 65mb (RUP S).

This Rollup Patch has also brought in some new Context variables. These new XML tags in Rollup Patch S are:

  1. s_jdbc_connect_descriptor_generation: The value of this variable determines whether the jdbc connect descriptor is regenerated and whether the value of the context variable s_apps_jdbc_connect_descriptor is updated. Acceptable values for this context variable are true (the default) or false. Set this value to false when using a custom apps jdbc connect descriptor
  2. s_apcprestart: This variable is used to specify the complete path of the script to be executed before the Apache service is started.
  3. s_ccmmaxsyspathlen: (Windows-specific) This context variable is used for setting the maximum length of the Windows System Path.

In my case, the first tag, s_jdbc_connect_descriptor_generation, brings a very important benefit. One of our customers uses a customized jdbc string in the DBC file to control load-balancing on the DB RAC nodes. This context variable is going help us save some time after every autoconfig run, which by default updates the jdbc url in the DBC file

The second variable, s_apcprestart, will help customers who want to automate some of the work done before the startup of Apache, such as cleanup of the jsp cache in $COMMON_TOP/_pages etc.

The third variable, s_ccmmaxsyspathlen, is Windows-specific. It looks as though it is introduced to deal with some length limitations in Windows.

I have another simple tip that can help you identify the new variables being brought in by the TXK rollup patches

The details of all XML tags are in the XML file in APPL_TOP. To put that another way, all context variables in the APPL_TOP context file are documented in $AD_TOP/admin/template/adctxinf.tmp. This file has a lot of good info on each context variable’s significance, such as whether it is editable or not. Here’s an example:

    <oa_doc oa_level="detail" oa_var="s_long_running_jvm" title="Long Running JVM" tooltip="Long Running JVM" description="Sets the parameter 'wrapper.bin.parameters=-DLONG_RUNNING_JVM' in jserv.properties. This JVM property indicates the lifespan of the JVM. Setting it to TRUE enables Distributed caching whereas setting it to FALSE disables distributed caching, which has implications on Oracle Applications E-Business Suite (That is, if an object is invalidated in a specific middle tier, the invalidation event is not propagated to all middle tiers). Please refer to Oracle MetaLink Document 275879.1 for more details on Java Cache Framework." editable="Yes"/>

If you have any comments, either positive or negative, feel free to post them here.

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Slashdot
  • Google
  • del.icio.us
  • Facebook
  • bodytext
  • Technorati
  • TwitThis
  • Reddit
  • Spurl
  • De.lirio.us
  • Furl
  • blogmarks
  • Ma.gnolia
  • E-mail this story to a friend!

6 Responses to “What’s New in 11i TXK AutoConfig and Templates Rollup Patch S”

  1. Lukas Says:

    Vasu, the most enlightening information for me is that there actually is a documentation of the context variables. I looked for it many times and I gave up all hope couple years ago. Thanks for bringing it to the light!

  2. Neil Campbell Says:

    Thanks for this Vasu,

    it might also be worth pointing out that TXK Advanced Utilities Rollup Patch C (5011249). is included with ATG_PF.H RUP 5 and / or ATG_PF.H RUP 6.

    Regards

    Neil

  3. Vasu Balla Says:

    Hi Lukas,
    Very Happy that my blog helped my fellow pythian.
    Vasu

  4. Vasu Balla Says:

    Hi Neil,
    Thats a point to note too. the latest ATG family pack rollups (rup5 & 6) have this Advanced Utilities patch included. Customer who are lucky to apply atg_pf.h.rup5 or 6 have these nice tools . But one of our customer, who is upgrading to 11.5.10.2, decided not to go with latest ATG rup, as its increasing the upgrade cutover time. the increasing number of Product family packs that people need to apply after 11.5.10.2 upgrade, and Oracle showing no interest in releasing CU3, making customer take these kind of decisions.

    vasu

  5. Get to Know the 11i Context File Better Says:

    […] my previous post on TXK rollup patch, you already know the significance of adctxinf.tmp file in $AD_TOP/admin/template directory. It has […]

  6. Naresh Says:

    Thanks Vasu..Its good to know,where can we look for the description of those tiny xml tags.,its really helpful.

    -Naresh

Leave a Reply

Filling out the following captcha not only allows us to cut down on automated blogspam but also helps digitize books. Please feel free to send comments on this approach directly to Paul at vallee@pythian.com.

NOTE: After submitting your comment, verify that it is added to the blog. New comments will be marked as "waiting for moderation" (we only moderate for spam). If the level of spam is as low as we hope, we will bypass this step.