The steps for configuring the APPS Tier to the new Database Tier

1.Bring down the Application Services
cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
adstpall.sh apps/[APPSpwd]
2. Modify the below parameters according to the New Database Tier
  s_dbhost
  s_dbdomain
  s_dbport
2. After modifying the above values run autoconfig on the APPS Tier.
cd $AD_TOP/bin
perl adconfig.pl contextfile='absolute path/*.xml'
or
cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
adautocfg.sh
3. Start the Application Services
adstrtal.sh apps/[APPSpwd]

Known Issues :
Sometimes the CM wont start as it will be pointing to the older nodes so we need to change it manually in Oracle
Applications Dashboard and restart all the Managers.

Oracle Applications Patching

How to apply the Patch in 11i

We have two types of Patches

1.Cold Patch (Applying the patch after bringing down the Application Services)

2.Hot Patch (Applying the patch during all the Services are up)
Steps for applying the cold adpatch

1. Bring the Applications down

COMMON_TOP/admin/scripts/context_name/adstpall.sh

2. Enable the maintenance mode

3. Download the patch from the Oracle Support and place it in your server
4. Go to the directory where the patch is unzipped
cd <patchnumber>
run
adpatch workers=8 interactive=yes options=novalidate,noautoconfig,nocompilejsp,nocompiledb

or

adpatch

Will prompt for patch location: chose default
Next prompt is for patch driver: enter patchnumber.drv

Once patch is applied check

Select * from ad_applied_patches where patch_name = ‘patchnumber’;

5.disable the maintenance mode

6. Bring up the Applications


Hot Patch

No need to bring the Applications down or enabling the Maintenace mode

adpatch options=hotpatch