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

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