Thursday, August 5, 2010

AutoConfig in Oracle Apps 11i / R12 / 12i

In Oracle Applications 11i & R12 (12i) all the configuration parameters are captured in two context files:
-> Application context file called the .xml contains the configuration information for the
application tier & is located in $APPl_TOP/admin for each node of application tier.
->Database context file called the .xml contains the configuration information for the database
tier & is located in $ORACLE_HOME/appsutil/.

Details stored in the context file contains host names,domain name , directory structure, port
numbers used ……

The AutoConfig feature of Oracle application manager(OAM) is used to update & manage context files.

Updating Context file
:-
Suppose we want to update the active port from to 80 , for this we will edit the application context file as follows:
Step 1 :Start all services
$ $COMMON_TOP/admin/scripts//adstrtal.sh APPS/
Step 2 :log on to OAM & click site map.
Step 3:Click AutoConfig from the list of System Configuration features in the Administration tab.
Step 4 : Click the Edit Parameter button for the application tier context file to access the Context File Parameters page & then click the system tab.
Step 5 : Click the Focus icon (blue triangle) for oa_web_server. This expands oa_web_server and shows the web server related parameters.
Step 6:Update the Web Port (s_active_webport) parameter from <> to 80.
Step 7 : Save it & answer the tab.Then logout of OAM. AutoConfig Script

The autoconfig script uses information from the context file to generate all applications configuration files & updates database profiles. It is located in
Application tier: $COMMON_TOP/admin/scripts/CONTEXT_NAME/adautoconfig.sh
Database tier: $ORACLE_HOME/appsutil/scripts/CONTEXT_NAME/adautoconfig.sh

Now we run the autoconfig script to reconfigure the oracle application system with the updated Applications context.
Step 1 : Stop all services
$ $COMMON_TOP/admin/scripts//adstpall.sh APPS/
Step 2:Run the autoconfig script, $adautocfg.sh & respond to the prompts.
Step 3:Check log files for any errors.log file for autoconfig is adconfig.log & is located in
/admin//log/MMDDhhmm/
Step 4: Restart all services :
$ $COMMON_TOP/admin/scripts//adstrtal.sh APPS/

Rolling back an autoconfig session:-
Each execution of AutoConfig creates a roll back script in case you want to revert back to the previous configuration settings. For this we perform the following steps:
Step 1 :Shut down all services:
$ cd $COMMON_TOP/admin/scripts/
$ adstpall.sh APPS/
Step 2:Restore AutoConfig session.
$ cd $APPL_TOP>/admin//out/MMDDhhmm
$ restore.sh
Step 3 : Restart all services:
$ $COMMON_TOP/admin/scripts//adstrtal.sh APPS/
Restoring the AutoConfig updated files and restarting the services allows you to log on to OAM.

Restoring the previous configuration:-
Now we run OAM AutoConfig to restore the Applications Context.
Step 1 :Log on to the Oracle Application Manager (OAM) & click site map.You will be able to log on but some services will be down.
Step 2: Click AutoConfig from the list of System Configuration features in the Administration tab.
Step 3 : Click the Show History button for the application tier context file to access the Context File History page.
Step 4 :Click the Show Differences from Current Configuration button to see the recently updated parameters & Select Restore Previous Value for the Web Port and Discoverer Port parameters.
Step 5 :Save & respond the tabs. Log out of OAM.
Step 6 :Shut down all services:
$ cd $COMMON_TOP/admin/scripts/
$ adstpall.sh APPS/
Step 7 :Run the AutoConfig script, adautocfg.sh & Respond to the prompts.
Step 8 : View the log file and check for any errors.
Step 9 : Restart all services:
$ $COMMON_TOP/admin/scripts//adstrtal.sh APPS/
Step 10 :Log on to the Oracle Application Manager (OAM)
If the status of some services appears to be down, click the Refresh icon to update the status.

------------------------------------------------------------------------------------------------
http://easyoracleapps.wordpress.com/2010/03/page/3/
------------------------------------------------------------------------------------------------

Wednesday, August 4, 2010

How to Merge Patches Using admrgpch

Couple of things you should consider when it comes to merge patches:

- AD patches can be merged with other AD patches, but AD patches and non-AD patches
cannot be merged.

- You can merge any non-AD patch with any other non-AD patch.

- You can merge patches with their listed prerequisite patches.

- You can merge individual patches with mini-packs and maintenance releases.

- You should not merge patches which have manual steps in them, mostly forms,
workflow, ias patches have manual steps and these need to be applied individually.

- AD Merge Patch will not merge patches of different releases, platforms or parallel
modes

- Check AD Merge Patch log files.
After AD Merge Patch runs, check the admrgpch.log file for errors. The file
is located in the current working directory (where AD Merge Patch was run).

- Create Source and destination directory
Copy all the patche to source directory
and run the below scripts ($ Admrgpch s- -d )
admrgpch -s /home/applmgr/patch10g/source -d /home/applmgr/patch10g/dest
-merge_name srikanth



ADMGRPCH is a utility to merge multiplie patches i.e Auto patch compatable patches into a single integrated patch.

This executable is located in AD_TOP/bin

Syntax: -

$ Admrgpch s- -d

Source: -Where patches to merge have been located

Destinitation: – Where admgrpch will create the merged patch.

It reads the all drivers and Readme files and merge into a single driver file

Actions in the merge patch are grouped by product then by patch number.

Log file located in the current directory where we run the admgrpch.

We can merge only same releases, same platforms or same parallel modes and if they are not incompatable patches.

Applsum.txt contain all the information that which patch has been applied to appl_top.