Autoconfig in R12.2

By -

AutoConfig is a configuration tool that automates the configuration of an Oracle E-Business Suite instance.

The information required for configuring an Applications system is collected into an XML repository, called the Applications context.

There is one Applications context for each application tier, and one for each database tier.

When AutoConfig runs, it uses information from the Applications 

context file to generate all configuration files, and update database profiles. 

Autoconfig components:

Context file
Driver files
Template files

Context file:

Configure the XML repository and related information

XML file for each application and database server.

XML file location

Application:
/apps/applmgr/fs1/inst/apps/san/appl/admin/san.xml

Database:
Cd $ORACLE_HOME/appsutil/<conextfile.xml>

Template file:

Template file contains only name tags

All are replaced with the actual vales when during autoconfig run.

DRIVER FILE:

Every product top contains own driver file.

It’s mapping the templates and profiles.

Autoconfig mapping b/w template file and target config file.

Location:
 /apps/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/admin/driver/
/apps/oracle/TEST/fs1/EBSapps/appl/fnd/12.0.0/admin/driver

AutoConfig Frequently Asked Questions (FAQ)

What is AutoConfig?

AutoConfig is a configuration tool that automates the configuration of an Oracle E-Business Suite instance. The information required for configuring an Applications system is collected into an XML repository, called the Applications context. There is one Applications context for each application tier, and one for each database tier. When AutoConfig runs, it uses information from the Applications context file to generate all configuration files, and update database profiles. 


What are the basic components of AutoConfig?


Components
Location
Description
Applications Context
On the application tier:
<INST_TOP>/appl/admin
On the database tier:
<RDBMS ORACLE_HOME>/appsutil
 
An XML repository (<CONTEXT_NAME>.xml) contains information specific to that Applications instance.
Do not manually update this file!
AutoConfig Template Files
On the application tier:
<PROD_TOP>/admin/template
For example:
<AD_TOP>/admin/template
<FND_TOP>/admin/template
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/template
Include named tags which are replaced with instance-specific information from the Applications Context. There is one template file for each configuration file.

For example:
apps_nt.conf
apps_ux.conf
AutoConfig File Driver
On the application tier:
<PROD_TOP>/admin/driver

For example:
<AD_TOP>/admin/driver/adtmpl.drv
<FND_TOP>/admin/driver/fndtmpl.drv 
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/template
Used by AutoConfig to list the AutoConfig Template Files, their destination locations, and the commands to be executed, for example, the commands to update profile options. Every Product Top contains its own AutoConfig File Driver.
AutoConfig Scripts
On the application tier:
<AD_TOP>/bin
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/bin
Provide a simplified
interface to the AutoConfig APIs. 
For example:
adautocfg.sh/adautocfg.cmd
adconfig.sh/adconfig.cmd 

What are the different AutoConfig scripts and what do they do?

Scripts
Location
Description
adautocfg.sh
adautocfg.cmd
On the application tier:
<INST_TOP>/admin/scripts 
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/
scripts/<CONTEXT_NAME>
A wrapper script that calls adconfig.sh/adconfig.cmd. Instantiates template files with values specific to the instance (taken from the Applications for the application tier and the database context for the database tier). Updates configuration files and profile options.
adconfig.sh
adconfig.cmd
On the application tier:
<AD_TOP>/bin
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/bin/
A wrapper script that calls adconfig.pl. In earlier versions of AutoConfig adconfig.sh/ adconfig.cmd used to call the Java API to start AutoConfig.
adconfig.pl
On the application tier:
<AD_TOP>/bin
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/bin
 
A wrapper script that calls the Java API to start AutoConfig.
adchkcfg.sh
adchkcfg.cmd
On the application tier:
<AD_TOP>/bin
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/bin
Generates a report that highlights differences between the original config files and AutoConfig-generated config files. The report is named cfgcheck.html. It is located under:
On the application tier:
<INST_TOP>/admin/
/out/<MMDDhhmm>
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/out/
<CONTEXT_NAME>/<MMDDhhmm> 

When should I run AutoConfig?
You should run AutoConfig in the following cases:
  • You made updates to a context file (via Oracle Applications Manager).
  • An OracleMetaLink note instructs you to run AutoConfig as part of an upgrade, migration, cloning and/or configuration process.
  • The README of an Oracle patch instructs you to run AutoConfig after the application of the patch.
  • You apply any ADX product patch.
Which files and profile options are changed when I run AutoConfig?
Run the adchkcfg utility to get an HTML report that lists all the files and profile options that get changed when you run AutoConfig.

Where is the log file located that AutoConfig creates?
The log file that AutoConfig creates is located at:
On the application tier:
<INST_TOP>/admin/log/<MMDDhhmm>/adconfig.log
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>/adconfig.log
where: <MMDDhhmm> = (month, day, hour, and minute of the AutoConfig run)

How can I roll back an AutoConfig session?
All backup configuration files from each AutoConfig session are stored in: 
On the application tier:
<INST_TOP>/admin/out/<MMDDhhmm>
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/out/<CONTEXT_NAME>/<MMDDhhmm>
where: <MMDDhhmm> = (month, day, hour, and minute of the AutoConfig run) 
You can run restore.sh (UNIX) or restore.cmd (Windows) to roll back an AutoConfig session.

Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
Normally we are getting concurrent program running longer and concurrent request not picking jobs, etc. those are very frequent issue we expected from development team. Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance? Once asked above questions to development team in meanwhile we need to start basic sanity check in our environment. 1 Verify the status of the concurrent program select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’1234567’; 2 Find which concurrent manger ran a specific concurrent request select b.USER_CONCURR
Read more

How to run Gather Schema Statistics in R12.2

By -
Image
What is Gather Schema Statistics? Gather Schema Statistics program generates statistics that quantify the data distribution and storage characteristics of tables, columns, indexes, and partitions. The cost-based optimization (CBO)  uses these statistics to calculate the selectivity of prediction and to estimate the cost of each execution plan. Why Run the Gather Schema Statistics? When Data is update, insert, delete in table of user end Like (Technical User ,Finance User ,Ect) It become necessary to run the Gather Schema Statistics It’s recommended to Run GSS in Weekly Once or twice. How to run Gather Schema Statistics? Login application with sysadmin user Submit Request Window Navigate to: Concurrent > Requests Enter the parameters This can be run for specific schemas by specifying the schema name or enter ‘ALL’ to gather statistics for every schema in the database Submit the Gather Schema Statistics program Parameters: Schem
Read more

How to compile forms in R12.2

By -
STEP 1--> Login to app server STEP 2--> Go to  directory $AU_TOP/forms?US STEP 3--> Move to ".fmb" file STEP 4--> Execute the below command to generate ".fmx" frmcmp_batch userid=apps/<apps_pwd> module=<form_name>.fmb output_file=<form_name>.fmx module_type=form batch=no compile_all=special (EX):-   frmcmp_batch userid=apps/apps module=JAINTAXT.fmb output_file=$JA_TOP/forms/US/JAINTAXT.fmx module_type=form batch=no compile_all= special (O/p):   Created form file /oracle/CLONE/apps/fs2/EBSapps/appl/ja/12.0.0/forms/US/ JAINTAXT.fmx Refer: R12: How to Compile a Form in Release 12 (Doc ID 1085928.1)
Read more