Wednesday Jan 12, 2011

Customized Database Listener Names Now Supported for EBS

The database listener name can now be configured using AutoConfig with newly introduced context variable s_db_listener. Prior to this certification it was not possible to use AutoConfig generated listener.ora files for managing listeners from SRVCTL when there were multiple RAC instances on the same server.

To use this feature E-Business Suite customers need to apply the following patch:
  • 11.5.10CU2 - Roll Up Patch 9535311 (RUP-U) or higher
  • 12.0.x - R12.TXK.A.delta.7 or higher
  • 12.1.x - R12.TXK.B.delta 3 or higher
There is a small difference between Oracle Database 10gR2/11gR1 and 11gR2 Listener names. In Oracle Database 10g Release 2 and 11g Release 1 NETCA creates the listener with the given name suffix nodename.

For example : If the given listener name is ebs then NETCA creates listener with ebs_<nodename>.

But in Oracle Database 11g Release 2 NETCA creates the listener with the given name.

To configure the listener with a customized name:
  • Create listener using NETCA
  • Update s_db_listener context variable with listener name.
  • Run Autoconfig.
References
E-Business Suite 11i
E-Business Suite 12
Related Articles

Sunday Jul 18, 2010

New Apps 11i AutoConfig + Templates Rollup Patch U Now Available

AutoConfig is an Oracle E-Business Suite systems administration tool that supports the automated configuration of E-Business Suite technology stack components.  A new AutoConfig update has been released for Oracle E-Business Suite Release 11i.

Screenshot of download page for TXK AutoConfig Rollup Patch U 9535311
EBS 11i Technology Stack Rollup U (Patch 9535311) for AutoConfig is now available for download. This Rollup patchset includes fixes and enhancements to the AutoConfig Engine, tools, and EBS configuration templates.  The new template files included in this patchset have no effect on an Oracle E-Business Suite configuration until the AutoConfig utility is run.

This cumulative patch includes all previously released AutoConfig updates, including the previous AutoConfig Rollup RUP T (Patch 8217898). RUP U can be applied without applying previous AutoConfig Rollup patchsets.

This Rollup includes the following features and enhancements:
  1. Applications password validation while using adcmctl and in other various
    commands.
  2. Mini AutoConfig: it is possible now to run AutoConfig using a customized driver.
  3. AutoConfig performance improvements.
  4. adchkcfg enhancements to remove false diffs/false positives
  5. Database 11gR2 support.
  6. Oracle HTTP Server (OHS) related changes for security and refining of aliases, log names changed as per standards
  7. Addition of ANTISAMY run-time rehosted JAR files.
  8. OHS performance improvements by removing loading of unwanted modules.
  9. For DB tier on Solaris 64-bit platform, use of 64-bit JVM during CVM phase
    of AutoConfig.
  10. Support for DB listener name customization.
  11. Support of Forms and Reports in the Icelandic language.
  12. Addition of LOCAL_LISTENER parameter to init.ora template.
  13. Introduction of FORMS60_RECORD_GROUP_MAX to restrict the number of records fetched by a List of Values (LOV).
  14. New context variables: s_httpd_pls_pid_file, s_icx_language, s_forms60_record_group_max, s_db_listener.
References
Related Articles

Wednesday Mar 31, 2010

New EBS 12.0 AutoConfig Rollup 7 Now Available

AutoConfig manages the configuration of E-Business Suite environments.  The seventh and latest rollup patch for the AutoConfig engine and tools for Oracle E-Business Suite Release 12.0 is now available for download.  The official (and admittedly-cryptic) name for this EBS 12.0 patch is:
Screenshot of download page for AutoConfig TXK patch 9386653
Not for EBS 12.1 environments

This patch can only be applied to Apps 12.0.x environments.  If you're running Apps 12.1.1 or 12.1.2, you can safely ignore this announcement.  Remember that there's an easy way to check whether an R12 patch is intended for 12.0 or 12.1:
What's new?

Notable enhancements in this release include:
  • Editable parameters for selected JVM settings
  • Configuration changes needed to support the latest Oracle Application Server 10g 10.1.3 and 10.1.4 updates
  • Configuration changes needed to support 11gR2 database
  • Automatic redeployment of the formsapp.ear file when applying TXK interim patches.  Automation ensures that the formsapp.ear used by EBS 12.0 is kept synchronized with the latest patches and changes
  • Enhancements to the Techstack Inventory reports
This patch also contains contains the TXK AutoConfig template files needed to configure the Technology Stack for Oracle E-Business Suite Release 12 instances.  These template files have no effect on the E-Business Suite configuration until the AutoConfig utility is run.

Almost 30 bugs are fixed in this release, including:
  • Improved support for HP-Itanium
  • Improved support for Slovenian, Croatian/Serbian/Bosnian, and Vietnamese NLS translations in Forms 10g
  • Fixes for cloning-related issues
  • Improved cookie handling for Oracle Single Sign-On-enabled EBS environments
See the rollup's README for a complete list of fixes in this patchset.

This Rollup patch is cumulative:  it includes all E-Business Suite 12.0 technology stack configuration fixes that we've previously released either individually or in previous patch sets. 

References
Related Articles

Friday Aug 21, 2009

Configuring SSL with a Configuration Wizard in EBS R12

E-Business Suite R12.1.1 provides Advanced Configuration wizards that make it easier to deploy features such as SSL and load-balancing.  Apps administrators can use these wizards to make configuration changes online through Oracle Applications Manager (OAM) and then run AutoConfig on the applications tier to make the changes effective.

SSL (Secure Sockets Layer) is one of the most commonly used configurations in EBS. I'll walk through the SSL Advanced Configuration Wizard in this article.

Accessing the Advanced Configuration Wizards

Launch the Oracle Applications Manager Site Map using the System Administrator responsibility, then select the AutoConfig link from the Administration tab.

Wizards_Welcome.png

Click on Launch Wizards. It brings up the launch pad for five wizards:

  1. Forms Socket Mode
  2. SSL
  3. SSL Accelerator
  4. HTTP Load Balancing
  5. OC4J Load Balancing

Wizards_Home.png

Start the SSL Configuration Wizard

The OAM General Collection Service must be activated before running any configuration wizards.  From the Administration tab of the Site Map, click on the 'Generic Services' link under the Application Services. Select 'OAM Generic Collect Services' and start it for the target instance. OAM submits a concurrent request for the same. Click on Verify to see if the service starts up fine. Once the service starts, you are ready to use the wizard.

From the Configuration Wizards launch pad, click on the 'Enable' button for SSL.

Select Nodes to be SSL-Enabled

Select the nodes on which you would like to enable SSL and click 'Next.'

SSL1.PNG

2. Set Context variables for SSL

Notice the tip at the bottom of the Parameters screen:  you should make sure that your digital certificates are properly imported into the Wallet of your EBS instance. For details about importing SSL certificates, see:

SSLParam.png

The wizard sets the following context variables to 'https':

  • URL protocol
  • Local URL protocol

It also sets values for the 'Web SSL directory' and the 'Active HTTP SSL port.' The subsequent screen gives the current and new values for these variables.

3. Validation

The wizard validates all settings when you click 'Next' after the user comparison of context values screen.  It checks that the Wallet and the required directory structures exist.

SSLValidation.png

Make sure that the Status is 'Success.' Check the log file in the 'View' link for any errors.

4. Confirmation Page

Clicking 'Next' will take you to the Confirmation Page in the train cart. Click on the link below to check the confirmation page.

View image


5. Submit the changes and run AutoConfig

Clicking the 'Submit' button on the Confirmation page displays the next action to be taken. You can review the context file on the applications tier for the changes that have been made.

The next step is to run AutoConfig to propagate the changes. You need to restart all application services to make the changes effective.

Once the service have been restarted, the EBS instance is ready to be used in SSL mode.

References

Related Articles

Wednesday Jul 22, 2009

New Apps 11i Autoconfig Rollup Patch T Now Available

A new AutoConfig update has been released for Oracle E-Business Suite Release 11i. EBS 11i Technology Stack Rollup T (Patch 8217898) for Autoconfig is now available for download. This Rollup includes fixes and enhancements to Autoconfig and its configuration templates. Screenshot of download page for TXK AutoConfig Rollup 8217898 This cumulative patch includes all previously released AutoConfig updates, including the previous Autoconfig Rollup - RUP-S 6372396. RUP T can be applied standalone. The release of this rollup patch is a bit of a sneak preview of things to come, as it will be included in the next EBS Applications Technology Family Pack - ATG PF-H RUP 7. This Rollup includes the following features and enhancements:
  • Vietnamese translation with Forms/Reports 6i for EBS R11i
  • Enable/disable MWA services via a new configuration variable
  • Turn on/off OXTA PROXY configuration
  • Set the SSL Loglevel via autoconifg variable
  • Templates changes required to support Secure Enterprise Search (SES) in 11i
  • Enhancements to context variables definitions in the inf file
References Related Articles

Tuesday May 26, 2009

15 New Technology Stack Enhancements in EBS 12.1.1

Now that our latest Applications Release 12.1.1 is available, here's a list of new technology stack configuration features you might be interested in learning about.  While you're reviewing new R12.1.1 content, please do not miss our newly revamped and user-friendly AutoConfig guide:

This updated AutoConfig guide has been restructured to present you more in-depth and practical information to get you get started quickly with AutoConfig and all its related utilities. Please check it out and let us know what you think about it!

Diagram showing the process by which the AutoConfig Build Context Utility consolidates data from the EBS database environment variables and context template to generate a context file

What's New in 12.1.1's Techstack Utilities?

Here's what's new in our Apps 12.1.1 technology stack tools and utilities:

Enhanced Support for Sharing Application Tier File System

  • Enables the sharing of the application tier file system amongst two or more Oracle E-Business Suite instances.
  • More information in My Oracle Support Knowledge Document 384248.1

Enhanced Support for Application Tier Load Balancing

  • Provides configuration support for major load balancing categories: DNS, OC4J Native, HTTP layer (hardware/software).
  • More information in My Oracle Support Knowledge Document 380489.1

Enhanced Support for DMZ Deployments

  • New demilitarized zone (DMZ) deployment options added, including support for forward proxies, reverse proxies with no external web tiers, and the use of hardware load-balancers without an external web tier.
  • More information in My Oracle Support Knowledge Document 380490.1

Network Traffic Encryption Capability

  • Provides AutoConfig support for securing the major communication routes with SSL.
  • More information in My Oracle Support Knowledge Document 376700.1

Advanced Configuration Wizards

  • Examples of such advanced configurations include DNS load balancing, HTTP load balancing, SSL setup on web server, SSL Accelerator setup, and others.

Oracle Connection Manager Technology Integration

  • Reverse proxy support for the database using Oracle Connection Manager
  • Oracle Connection Manager (CMAN) is a lightweight, highly-scalable program that works as a proxy server, forwarding connection requests to database servers or to the next proxy server. Oracle Connection Manager listener receives connection requests, evaluates them against a set of rules, and determines whether to deny or allow access.
  • More information in My Oracle Support Knowledge Document 558959.1

Support for Integrated SOA Gateway

  • More improvements and automation around integrating with Service Oriented Architectures (SOA) and web services.
  • More information in My Oracle Support Knowledge Document 556540.1

Technology Stack Inventory Validation Report

  • Allows administrators to review the versions of various installed technology components, patchsets and interim ("one-off") patches.

AutoConfig Profiler

AutoConfig Parallelization

  • AutoConfig can be run in parallel on different nodes of an Oracle E-Business Suite system, reducing the overall time needed to run AutoConfig.

AutoConfig Service Control Dependency Management :

  • Now it is possible to enable and disable specific OC4J instances on the Application Tier Servers.

AutoConfig Check Config Utility

AutoConfig Support for Oracle Database 11g

  • Support to run on and configure an Oracle 11g database using AutoConfig.

Build Context XML Utility

AutoConfig Search Utility

  • A new search utility that can be used to obtain detailed information about context variables and the templates that use them.
Note: The enhanced functionality above is not available as standalone downloads or for previous Apps releases.  They can only be obtained via Oracle E-Business Suite Release 12.1.1.

Other References

Related Articles

Friday May 22, 2009

Everything You Ever Wanted to Know About AutoConfig Variables

Luckily, you were not afraid to ask. AutoConfig supports the automated configuration of  E-Business Suite technology stack components, but tracking down specific AutoConfig variables in their associated configuration files can be a daunting task.  The AutoConfig Search Utility (formally known as the TXK Context Variable Information Utility) scans your AutoConfig infrastructure for a requested string and generates a detailed report about the relevant AutoConfig variables and their usage. The report contains, among other things, the following information about relevant AutoConfig variables:

  1. Description
  2. Current value
  3. Default value
  4. Relevant AutoConfig template files

You can use the utility to search for:

  • A complete context variable name
  • A string that contains the partial context variable name
  • A string that is mentioned in the context variable definition, default value, or templates

For example you can enter either "s_contextfile" or even the word "context."  If you search for just a word the report will include information on all context variables that have the given word in their name or in their definition.

We delivered the first version of the AutoConfig Search Utility in E-Business Suite Release 11i and 12.0.x.  We've enhanced and updated Phase II of the tool in Release 12.1.1.

In the first version, the scope of the AutoConfig Search Utility is limited to AD and FND products. In the latest version included with Release 12.1.1, we've expanded the tool's scope to include ALL product tops.  We've also enhanced the 12.1.1 version to allow you to drill down into all configuration files that include the variable.  The tool generates the report in HTML format on the application and database tier.

Running the AutoConfig Search Utility

Here's an example report generated when running the AutoConfig Search Utility from the Application tier for the search string "java" using the following command:

perl <FND_TOP>/bin/txkrun.pl -script=GenCtxInfRep -keyword=jdbc -outfile= txkContext_Apps.html

The 12.1.1 report looks like this:

Screenshot of sample EBS AutoConfig Search Utility report

Obtaining the AutoConfig Search Utility

You can download the AutoConfig Search Utility via the following patches:

Utility Version Release Patch Number and Description
Phase I 11i 6372396: TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH S (APRIL/MAY 2008)
Phase I 12.0 7207440:  R12.TXK.A - TXK - 12.0.4 Consolidated Patch 1
Phase II 12.1.1

R12.1.1 Rapid Install or 7303030: 12.1.1 Maintenance Pack

References

Related Articles

Tuesday Apr 07, 2009

Power Tools: Configuring EBS R12 Database Tiers with AutoConfig

[Editor's Note: This is the fourth and last of a series of four articles on new AutoConfig features. These articles are written by members of our AutoConfig Development team. This is your opportunity to interact directly with that team with your feedback on this tool.]

The AutoConfig Build Context utility (adbldxml.pl) has traditionally been used by administrators to rebuild the context file in Oracle E-Business Suite 11i. In Apps 11i, the AutoConfig Build Context utility was introduced to allow customers to migrate to AutoConfig easily. Later on, due to numerous changes in the 11i technology stack, it became hard to keep the utility in sync for the Applications tier. So it was not recommended to customers for discretionary use, but instead only when absolutely needed like in case of cross-platform migrations and database upgrades.

Diagram showing the process by which the AutoConfig Build Context Utility consolidates data from the EBS database environment variables and context template to generate a context file

Revived for Apps 12

The AutoConfig Build Context utility has been revived and re-introduced in Oracle E-Business Suite R12 for the database tier. It is essential for enabling AutoConfig on the database tier of an R12 E-Business Suite instance in the following scenarios:

How Does it Work?

The AutoConfig Build Context utility reads information from EBS database and environment variables and builds the context file out of the database context template ($ORACLE_HOME/appsutil/template/adxdbctx.tmp). This is illustrated in the figure above.

Running the AutoConfig Build Context Utility

The utility can be run by issuing the following command on the database tier:

perl $ORACLE_HOME/appsutil/bin/adbldxml.pl

Note: In R12, this utility is supported only on the database tier.

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:

References

Related Articles

Power Tools: Previewing AutoConfig Changes on All Tiers

[Editor's Note:  This is the third of a series of four articles on new AutoConfig features.  These articles are written by members of our AutoConfig Development team.  This is your opportunity to interact directly with that team with your feedback on this tool.]

When we first launched AutoConfig for E-Business Suite environments, it quickly became clear that your confidence in the tool would depend upon your ability to review its actions before committing to its changes to your environments. The AutoConfig Check Config tool (adchkcfg) is used to identify the potential changes that would take effect on an E-Business Suite instance during the next AutoConfig run.

Until now, that tool has only been reporting expected changes to the file system and the database profile values. The adchkcfg tool has now been enhanced to report information about important non-profile database updates also. The enhanced report will help customers understand potential system configuration changes, thus minimizing custom configuration errors.

What Does the Check Config Report Show?

The Check Config tool generates a report in both HTML and text format. The text report for the database changes can be used for quick reference from the command line.

Here is a screenshot of the new Check Config HTML report (click to enlarge):

Thumbnail of Check Config HTML Report

For complete samples of Check Config reports, download this file:

Generating a Check Config Report

The Check Config tool can be run by executing the following command on both the Application tier and the Database tier:

  • On UNIX:

    sh adchkcfg.sh contextfile=<context_file>
     
  • On Windows:

    adchkcfg.cmd contextfile=<context_file>

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:

Customers on 11i can get this new AutoConfig feature by installing:

Your Thoughts?

We're still working on improving this tool.  For example, we're working on ways to make it easier to ignore false positives by flagging diffs which are neither real or interesting.  Please share with us your experience on using this feature. Are there other improvements to this report that you would find useful? 

References

Related Articles

Tuesday Mar 31, 2009

Power Tools: Running AutoConfig in Parallel in EBS 12

[Editor's Note:  This is the second of a series of four articles on new AutoConfig features.  These articles are written by members of our AutoConfig Development team.  This is your opportunity to interact directly with that team with your feedback on this tool.]

Our last article discussed ways of tuning your AutoConfig runs via profiling reports that identify bottlenecks during template instantiation.  This article discusses another method of speeding up your AutoConfig runs.  In an R12 E-Business Suite instance, AutoConfig can now be run simultaneously across multiple nodes. This new feature significantly lowers maintenance downtime for multi-node installations. One beta customer of this feature improved the time it takes them to run AutoConfig across their dozen mid tiers by 45%.

How Does AutoConfig's Parallel Mode Work?

Executing AutoConfig in 'parallel mode' engages a locking mechanism so that processes running on individual nodes are synchronized. This mechanism prevents any conflicting updates to the database or the file system. The following figure illustrates AutoConfig running in parallel across multiple nodes:

Diagram showing how AutoConfig runs in parallel on EBS 12

Executing AutoConfig in Parallel Mode

The following command can be used to run AutoConfig in 'parallel mode'

Application Tier

perl $AD_TOP/bin/adconfig.pl contextfile=<CtxFile> [product=<product_top>] –parallel

Database Tier

perl $ORACLE_HOME/appssutil/bin/adconfig.pl contextfile=<CtxFile> –parallel

where

<CtxFile> is the absolute path to the context file
<product_top> is the Product short name

Note that while running AutoConfig simultaneously on multiple nodes, it is very important to ensure that the '-parallel' option is specified while starting AutoConfig on each node to prevent unstable and/or inconsistent filesystem and database states.

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:

This feature is currently not available for Oracle E-Business Suite 11i.  We currently do not have precise plans for delivery of this feature in 11i.

Your Thoughts?

Please let us know about your experience on using this new feature. We'd be very interested in hearing about how long it takes to run AutoConfig on your multi-node installations with and without the 'parallel' option. The new AutoConfig Performance Profiler feature can be used to collect this information. Also let us know of any issues you encounter while using this feature.

References

Related Articles

Power Tools: Optimizing AutoConfig Performance Through Profiling

[Editor's Note:  This is the first of a series of four articles on new AutoConfig features.  These articles are written by members of our AutoConfig Development team.  This is your chance to get the inside track on these advanced features and provide your feedback directly to our developers.]

Ever wonder what's taking up the time during a given AutoConfig run in your E-Business Suite environment?  Want to optimize the performance of your techstack configuration customizations?  The AutoConfig Performance Profiler gathers data about an AutoConfig run and generates a consolidated AutoConfig profile report in HTML format. The report lists all product tops processed by AutoConfig along with the total instantiation and execution time of the templates within them. A beta customer of this feature helped us fix an indexing issue to allow AutoConfig to run in one third of the time.

The generated performance report allows you to drill down on each product top and view the following:

  • Source and target location of individual templates
  • Time consumed to instantiate or execute each template
  • Execution report for each template

Here's a screenshot of the first few lines of the report:

Mini screenshot of AutoConfig Performane Profiler report

A complete sample performance profiler report can be found here.

Identitying AutoConfig Performance Bottlenecks

This report is useful in analyzing the source of AutoConfig performance bottlenecks. It also helps administrators optimize template customizations (if any). For example, if you have performed customizations to the context variable values or to any of the product templates and you find that AutoConfig is taking more time after the customization, you can use this feature and generate the profiler report to see where exactly the delay is occurring. The profiler report allows you to determine which phase or product took more time to execute.

Then by further clicking on the link for that phase or product, you can see more details at the template level. Going through these details, you can determine which templates are taking an unreasonable amount of time for instantiation or execution. You can use this to verify and optimize your customizations to the templates.

Generating AutoConfig Performance Profiler Reports

To generate the AutoConfig Performance Profiler report, you can run AutoConfig in 'profile mode' by issuing the following command:

Application Tier
 
perl $AD_TOP/bin/adconfig.pl contextfile=<CtxFile> [product=<product_top>] –profile

Database Tier
 
perl $ORACLE_HOME/appsutil/bin/adconfig.pl contextfile=<CtxFile> –profile

where

<CtxFile> is the absolute path to the context file
<product_top> is the Product short name

Note that the -profile option can be used alongside other AutoConfig command line parameters.

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:

Customers on 11i can get this new AutoConfig feature by installing:

Your Thoughts?

We would appreciate if you could share with us your experience on using this new feature. Please post your comments here or email your profiling results to Ivo Dumovic at:

ivo-dujmovic-email.png

We're eager to hear about your thoughts about how we can improve this feature.

References

Related Articles

Monday May 05, 2008

New Apps 11i AutoConfig + Templates Rollup Patch S Now Available

[June 18, 2008 Update: Mentioned the Oracle Diagnostics regression fix]

[May 6, 2008 Update: Clarified that Developer 6i patchset 18 was recommended in Jan2007 CPU]


[Editor's Note:  Ivo Dujmovic leads the hard-working Applications Technology Integration development team responsible for the E-Business Suite's technology stack and configuration management tools, including AutoConfig and its associated templates.  He's been providing deep technical guidance for this blog from the wings since its inception, so we're very lucky to have his direct contributions for this particular announcement.  I'm skipping the customary introductory article for him in the interest of getting this article published quickly, but we'll get a proper public welcome out for him soon.]


The latest TXK Rollup Patch S (Patch 6372396) is now released and is generally available for download from Oracle Metalink. The official name for this patch is:



TXK Rollup S: Screenshot of Metalink download page for TXK AutoConfig and Templates Rollup Patch S (APRIL/MAY 2008, Patch 6372396)



What's Included


This Rollup patch is cumulative:  it includes all E-Business Suite technology stack configuration fixes that we've previously released either individually or in patch sets such as  TXK Autoconfig Rollup Patch R (October/November 2007) and TXK AutoConfig Rollup Patch Q (Jul/Aug 2007).


But that's not all!  For completeness we have also added TXK Advanced Utilities Rollup Patch C (APRIL 2006) and other subsequent fixes in this area.


For more details about this patch's contents, see the README.  In the near future, we will also publish a couple of separate blog articles on the new features we are introducing.


Additional New Prerequisites


In addition to previous Oracle Home technology stack prerequisites (identified at patch-time via txkprepatchcheck utility), we have picked up a new ORACLE_HOME dependency on:




In the APPL_TOP, we picked up dependencies on fairly old and well-adopted rollups:



We know that part of the reason why our TXK RUPs enjoy such high adoption rates (thousands of downloads per quarter) is that they are self-contained. At this point in time, we have decided that taking up a wider set of well-adopted dependencies is a minimal price to pay for providing customers with all the latest technology configuration management functionality.


Please tell us if you find these additional requirements burdensome!

News:  TXK RUP S conflicts with Oracle
Diagnostics, introducing bug:

7126196  IZU_TOP GONE/LOST
AFTER AUTOCONFIG UPGRADE

If you use Oracle Diagnostics, please apply the patch for bug 7126196.


References


Related Articles


Wednesday Apr 23, 2008

Preparing for Apps 11i AutoConfig Updates

E-Business Suite Release 11i uses the Oracle9i Application Server 1.0.2.2.2-based components in its Applications tier. This includes an 8.0.6 ORACLE_HOME for the Developer 6i Forms and Reports run-time and an 8.1.7 ORACLE_HOME for the Apache and JServ-based run-time components. AutoConfig and its associated templates provide the configuration data for these ORACLE_HOMEs.

The latest version of AutoConfig is always included with the latest ATG Technology Stack rollup patches.  It's also possible to update the AutoConfig Engine and its associated templates separately if certain prerequisites are met.  You can download the latest version of AutoConfig via the TXK Rollup for Oracle E-Business Suite Release 11i:

In preparation for your AutoConfig upgrade, you can run the Technology Stack Rollup Validation Utility to get a report of the current component versions on your Release 11i Applications tier. The report also advises on the components on each tier that need to be upgraded before upgrading AutoConfig itself.

TXKRUPR:

Running the Technology Stack Rollup Validation Utility

The Technology Stack Rollup Validation Utility is a perl script that is run using the perl infrastructure delivered in the APPL_TOP by the TXK team.

Where to run

  • In a single-node install, run the utility on the Applications Tier Node.
  • In a multi-node install, run the utility on every Web/Forms, Admin/CP Node
  • The latest version of the Validation Utility is shipped with the TXK Rollup. Hence the script needs to be run from the location where the patch is unzipped.

Steps to run

  1. Source the Applications environment file as the owner of the application tier file system
  2. From the location where TXK Rollup patch was unzipped, change directory to fnd/patch/115/bin
  3. Run the Validation script as described in the table below
Unix
./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html 
-appspass=<apps database password>
Windows
%ADPERLPRG% txkprepatchcheck.pl -script=ValidateRollup

-outfile=%APPLTMP%txkValidateRollup.html

-appspass=<apps database password>

Note: The arguments for the perl script txkprepatchcheck.pl can be entered manually at the prompt also.

Interpreting the Report

The report generated in the location specified by the outfile argument contains:
  1. Overall PASS/FAIL status of the Utility.
  2. Report header table with information about the host, node type and configuration file, versions.
  3. Validation table for each of the HTTP Server, Forms Server, Concurrent Processing Server, and Administration Server Node types.
  4. For each of the node types, the dependent and relevant Technology Component is displayed with its version number and PASS/FAIL status.
Sample Reports

Report Header

TXKHeader1:

TXKHeader2:

Validation for HTTP Server Node

TXKHTTPServer:

Validation for Other Nodes

TXKOtherNodes:

Before Applying the TXP RUP

The AutoConfig upgrade, as delivered by TXK Rollup patches, can be be applied only when the report displays PASS for all entries in each table and an ALLPASS at the top. All WARNING/FAIL rows should be corrected with respective actions recommended in the report row before applying the patch.

References
  1. Using AutoConfig to Manage System Configurations withOracle Applications 11i (OracleMetalink Note 165195.1).
  2. Frequently Asked Questions About Using AutoConfig With Oracle Applications Release 11i (OracleMetalink Note 218089.1)
Related Articles

Saturday Jan 19, 2008

New AutoConfig Patchset Available for Apps 12

The fourth update to the Release 12 Autoconfig Templates and Engine is now available for download now via:
AutoConfig Update 4 screenshot: Screenshot of download page for E-Business Suite Release 12's AutoConfig R12 TXK.A.Delta.4 Patchset (Patch 6329757)

This patchset is cumulative and includes all previous R12 AutoConfig updates such as TXK.A.Delta.3 (patch number 6077487) released with the Oracle E-Business Suite Release 12.0.3 Release Update Pack.

TXK.A.Delta.4 can be applied standalone on top of base R12.0 or any of the later R12 Release Updates (12.0.1, 12.0.2, 12.0.3). This patchset is also included in:
If you have already applied either of the two 12.0.4 updates listed above, you don't need to apply this AutoConfig patch separately.  On the other hand, if you're looking for the latest AutoConfig templates and don't wish to apply the larger 12.0.4-related updates, this is a smaller and more granular alternative.

This Patchset contains fixes required for support of some of the upcoming Application Server and Database patchset certifications with E-Business Suite R12.  For more details, refer to the README of the Patchset.

Tuesday Aug 07, 2007

New AutoConfig Rollup Patch Q Now Available

The latest AutoConfig Rollup Patch Q (Patch 5985992) is now released and is generally available for download from Oracle Metalink.

AutoConfig Flowchart 3:

The official name for this patch is:
This Rollup patch is cumulative:  it includes all E-Business Suite technology stack configuration fixes that we've previously released either individually or in patchsets such as AutoConfig Rollup Patch P (Mar/Apr 2007, Patch 5759055).

This Rollup includes a large number of enhancements and fixes, including the following:
  • A new s_startServers context variable, used to customize the number of child processes created by Oracle HTTP Server on startup
  • Apache access_log now logs the amount of time taken by Oracle HTTP Server to serve
  • Enhancement allowing the use of the JConsole tool to locally monitor Apps 11i JVMs.  This feature is backported from Release 12.  You can find out more on enabling remote monitoring in this blog article.
  • Enhancements to the URL Firewall to allow iPayment servlet access for customers deploying the Oracle Lease Management (OKL) product as an external application.
  • Context file customizations from Oracle Application Manager (OAM) are now reported by the adchkcfg utility
  • Fixes for the Inventory Utility Report
  • TXK Pre-patch Check Utility reports all database nodes in RAC setups
  • During the execution of AutoConfig, the log file path will be printed at the beginning instead the end of the AutoConfig run.
  • Enabled context variable s_discostatus on Windows
  • Unset the environment variable LD_ASSUME_KERNEL for SLES10 or higher
  • Enabled adbldxml.pl to run on Solaris SPARC 64bit.
  • Enhancement to log files (stderr and stdout) to include JVM startup timestamps
  • Several changes to improve autoconfig performance
  • Corrected the issue of having to disable Discoverer 4i each time AutoConfig was run on Windows. Now the default setting for Discoverer 4i is set to disable.
  • Removed unwanted parameters from init.ora template to enhance performance of Release 11i with the 10gR2 database
  • Fixed bug in Autoconfig to run the job afcpgsm without errors.
  • Enabled AutoConfig to run in parallel on multiple middle tiers with Jserv load balancing enabled
For more details about this patch's contents, see the README.

Related

Tuesday May 08, 2007

New AutoConfig Rollup Patch P Now Available

The latest AutoConfig Rollup Patch P (Patch 5759055) is now available for download from Metalink. 

AutoConfig Flowchart 3:

The official name of this patch is:
This patch is cumulative:  it includes all E-Business Suite technology stack configuration fixes that we've previously released either individually or in patchsets such as AutoConfig Rollup O (the letter "O" and not the number zero). 

This patch is also included in the latest ATG RUP 5 patch.  If you've installed ATG RUP 5, you don't need to install AutoConfig Rollup Patch P separately.

This Rollup includes sixteen enhancements and fixes that affect areas such as:
  • Compatibility with Oracle Fusion Intelligence (running on Oracle Business Intelligence Enterprise Edition 10.1.3.2)
  • JDK upgrades
  • Technology validation scripts
  • 10gR2 Database configuration (for SGA sizes)
  • IBM AIX and zLinux compatibility
  • Cloning
For more details about this patch's contents, see the README.

Related

Thursday Feb 22, 2007

Additional Configuration and Deployment Options in Release 12

The AutoConfig utility provided with E-Business Suite Release 12 automates a wide variety of deployment options. However, there are a number of optional configurations that AutoConfig doesn't automate yet.  In this initial release, implementation of some of these optional configurations requires additional manual steps or the installation of additional patches.


Release 12 Techstack Overview: Overview of three-tier logical architecture for E-Business Suite Release 12, including the database, application server, and desktop tiers. 

If you plan to use any of the following deployment options, you may need to perform some additional manual steps:
For a brief discussion about these configurations, see Oracle E-Business Suite Release 12 Support for Additional
Configuration & Deployment Options
(Metalink Note 380483.1).

Related

Thursday Dec 21, 2006

New AutoConfig Rollup Patch O Now Available

As befits the holiday season, here's a little gift to you from the Applications Technology Group:  the latest AutoConfig Rollup Patch O (that's the letter O and not the number zero) is now available for download.


This new TXK (FND & ADX) AutoConfig Template Rollup Patch O (Patch 5478710)  for December 2006 is a cumulative patch.  Includes all E-Business Suite technology stack configuration fixes that we've previously released either individually or in patchsets such as Rollup N.  This Rollup fixes over three dozen issues that affect areas such as:
  • Real Application Clusters (RAC) configurations
  • Cloning, including cloning fixes for UTF-8 environments
  • Java Virtual Machine (JVM) configuration and stability
  • Platform-specific issues for HP Tru64 and Sun Solaris
  • JMailer + Oracle Application Manager integration
  • Context file generation and variable population
  • JDK 5.0 configurations
  • 10gR2 database configurations
  • Forms configurations
For complete details about the patch's contents, see the patch's README.

Related

Friday Aug 04, 2006

AutoConfig Template Rollup Patch N Now Available

Editor Dec 21 Update:  AutoConfig Rollup O is now available for download.  It includes AutoConfig Rollup N.

AutoConfig continues to be updated, so those of you who are using it in your E-Business Suite environments will be pleased to hear that the latest AutoConfig Template Rollup Patch has been released.


The TXK (FND & ADX) AutoConfig Template Rollup Patch N (Patch 5107107)  for August 2006 has just been released to Metalink.

This patch contains additional content on top of TXK AutoConfig Template Rollup Patch M (Patch 4709948).  This latest patch contains the latest enhancements and fixes to the actual AutoConfig engine, also.

For complete details about the patch's contents, see the patch's README.

References:

Tuesday Jun 06, 2006

Update: AutoConfig and Rollup Patches

[Editor:  This is an a elaborated and expanded version of a comment from one of our Applications Technology Group architects from the now-massive AutoConfig Comment thread]

AutoConfig Flow:

Just to update folks and clarify some delivery questions around AutoConfig and its templates:

In previous patches: 
  • The AutoConfig Engine and its associated utilities were released via patches bundled in the ADX product ID.
  • The E-Business Suite AutoConfig templates were released via patches bundled in the TXK product ID.
  • To get an up-to-date AutoConfig setup, you needed to download and install both sets of patches individually.
AutoConfig Engine and Templates in a Single Patch

We have now combined the AutoConfig Engine and the E-Business Suite Templates into a single patch for easier management. They are now being combined into TXK rollup patches, the first combined one being:
The Applications Technology Group produces Rollup patches for AutoConfig, Advanced Configurations, and Rehosted Technologies. These are released via patches in the TXK product ID.

These rollup patches get packaged together into a Minipack.

The last TXK Minipack (3219567 Patch 11i.TXK.B Technology Stack Minipack B) was released in November, 2004.  This was part of 11.5.10 and contained TXK AutoConfig Rollup I (Oct 2004) Patch 3594604.

Each subsequent Rollup patch (RUP) includes the previous one.

Hopefully this clarifies the delivery of AutoConfig code.

Enhancements for AutoConfig

On a separate note, I would like to thank everyone who posted comments about AutoConfig features. It took us a long time to get to this point and there are probably a lot more features you want. So if you can continue submitting here your favorite enhancement, we will do our best to include the most desirable ones.

Thanks,
Ivo Dujmovic
Director of TXK Development Team

Related Articles:

Friday Apr 21, 2006

Managing E-Business Suite Configurations with AutoConfig

Work is its own reward.  You can expect great rewards this year.

~ Paraphrased from Dilbert, Scott Adams

Historically, one of the biggest challenges facing any E-Business Suite system administrator was managing the countless configuration files for technology stack components. 

In the past, different E-Business Suite products would each have their own technology stack configuration recommendations.  For example, iProcurement might recommend that a certain parameter be set to a given value in httpd.conf.  Naturally, it's inevitable that a different product family would come along and recommend a completely contradictory setting for the same parameter. 

Further complicating things:  if the hapless system administrator chose to follow either recommendation, there was no guarantee that the new setting wouldn't break a third unrelated product.  It was enough to make grown sysadmins weep.

Enter stage left, AutoConfig

AutoConfig is a tool that automates the management of all configuration files for all E-Business Suite Release 11i technology stack components.  The Applications Technology Group now centrally controls all parameter settings for all configuration files for the E-Business Suite. 

You might reasonably have expected from the start, but there are over 200 products within the E-Business Suite, and gaining agreement from all development groups to centralize this kind of control within the Applications Technology Group was about as simple a political process as nominating a presidential candidate.  This took years.

That's all behind us now, and today, individual product families are no longer permitted to make recommendations for technology stack configurations of any kind, and any changes to known-good parameter settings are now centrally tested to ensure that they work with all 200 or so E-Business Suite products.  It's about time, and you're the main beneficiary.

Beneath the Hood:  AutoConfig

All of the information required for configuring an Applications instance is collected into two local XML repositories called the Applications Context and the Database Context.  This information describes your instance name, location of servers, and so on.  With the latest Rapid Installs, the information you originally provided at install time is the basis for the Applications and Database Context files.

When AutoConfig runs on the Application tier, it merges information from the Applications Context with presupplied configuration file templates to generate all application-tier configuration files and update database profiles.

When AutoConfig runs on the Database tier, it uses information from the Database Context file to generate all configuration files used on the Database tier.

If you're updating the configuration for an existing instance with AutoConfig, it will take a snapshot of your current configuration before installing the new configuration files.  You can roll back your configuration to any snapshot taken at any given date.  This allows you to experiment safely with different configuration options.  Didn't like the effect of the last change?  Just roll back to the previous AutoConfig snapshot.

But wait... there's more.  AutoConfig can also start and stop all technology stack components that it manages, and there are additional options for pregenerating test configuration files and examining the differences with your existing configuration.

AutoConfig Now Preserves Customizations

With all of these great features, as well as AutoConfig's devotion to motherhood and apple pie, the reluctance of sysadmins to use AutoConfig has been a source of some... ahh... perplexity within our team. 

After all, who wouldn't want to use a tool that guarantees a known-good configuration that works for all E-Business Suite products?  Who could possibly want the burden of managing configuration files themselves, with this as an alternative?

Well, a lot of you, as it turns out.  More than we expected, in fact. 

With some digging, we learned that you've invested in building your own custom configurations and don't want us overwriting your hard-earned changes.   Your customizations might address the need to:
  • Start additional services or processes when you start Oracle Applications services
  • Define and add zones to your JServ configuration
  • Extend Forms to integrate with a third party Java version
  • Develop customer applications that are maintained by AutoConfig
That's understandable, so we enhanced AutoConfig.  Your customizations are now preserved after running AutoConfig, and persist even after new AutoConfig templates are installed. 

So, What Did We Miss?

Despite all this, we still have the nagging impression that the majority of E-Business Suite system administrators still don't use AutoConfig.  We really don't know why.

Assuming that you're all rational, there must be good reasons.  Clearly, you have requirements that AutoConfig doesn't meet yet.

If you haven't switched over to AutoConfig yet, I would appreciate your posting a comment about new features that would encourage you to make the switch.

References:

Monday Apr 17, 2006

AutoConfig Template Rollup Patch M Now Available

This one's hot off the presses, also.  One of the major products from our team is AutoConfig, which I plan to devote a few future posts to.  For now, those of you who are already using AutoConfig in your E-Business Suite environments will be pleased to hear that the latest AutoConfig Template Rollup Patch has been released.


The TXK (FND) AutoConfig Template Rollup Patch M (Patch 4709948)  for April 2006 has just been released to Metalink.

This patch contains additional content on top of TXK AutoConfig Template Rollup Patch L (Patch 4489303).  This latest patch contains the latest enhancements and fixes to the actual AutoConfig engine, also.

For complete details about the patch's contents, see the README.

For details about AutoConfig, see, "Using AutoConfig to Manage System Configurations with Oracle Applications 11i" (Metalink Note 165195.1).

Related Article:

About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today