Thursday, 26 August 2010

Oracle E-Business Suite Release 12.1.3 RUP

I have successfully done upgradation of 12.1.3 RUP on my instance without having any problems. The details of my instance details are
Instance version: 12.1.2
Database version: 11.2.0

I have followed the Note 1080973.1 for upgrading from 12.1.2 to 12.1.3 release update pack.
The steps followed to upgrade for Apply Oracle E-Business Suite Release 12.1.3 are,
First of all disabling fast validation for PL/SQL recompilations using 
_disable_fast_validate=TRUE
using init parameter of database and restarted
Enable maintenance mode
adadmin menu_option=ENABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Applying required patches from 12.1.3.RUP

Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=$PATCH_TOP/9239089 driver=u9239089.drv workers=8

Use AutoPatch to apply Oracle E-Business Suite Release 12.1.3 Patch 9239090 and follow the instructions in the patch readme file.
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=$PATCH_TOP/9239090 driver=u9239090.drv workers=8

Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=$PATCH_TOP/9239095 driver=u9239095.drv workers=8
Post-Update Steps
Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)
Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=$PATCH_TOP/9817770 driver=u9817770.drv workers=8

Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=$PATCH_TOP/9966055 driver=u9966055.drv workers=8

Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level.
After upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3:
Application tier:
As the APPLMGR user, run the environment file for the current APPL_TOP.
. .$APPL_TOP/APPS$CONTEXT_NAME.env
Run AutoConfig on the APPL_TOP.

Run the admkappsutil.pl utility to create the file appsutil.zip in the $INST_TOP/admin/out directory.
perl $AD_TOP/bin/admkappsutil.pl
Database tier:
As the ORACLE user, run the environment file for the current ORACLE_HOME.
cd [RDBMS ORACLE_HOME]
. ./[RDBMS ORACLE_HOME]/$CONTEXT_NAME.env
Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME].
Uncompress appsutil.zip under the [RDBMS ORACLE_HOME].
cd [ORACLE_HOME]
unzip -o appsutil.zip
Run AutoConfig on the [RDBMS ORACLE_HOME]
Re-run adpreclone.pl on the database tier and the application tier.
Since updates included in Oracle E-Business Suite Release 12.1.3 were applied to the system, adpreclone must be run again to apply the updates to the clone directory structures that were used during cloning.
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

Disable Maintenance mode
adadmin menu_option=DISABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Remove the fast validation for PL/SQL recompilations from init parameter and restarted the database.
Restarted the application Tiers


Cheers!!!

SocialTwist Tell-a-Friend

Related Posts by Categories



8 comments:

Anonymous said...

Hi Aji

is R12.1.2 available to download or we need to apply RUP patch on 12.1.1 to get 12.1.2?

Thanks
Ridhi Sundar

Ajikumar G said...

Below patches/steps are required to upgrade from R12.1.1 to R12.1.2
- Use AutoPatch to apply R12.AD.B.DELTA.2 Patch 8502056
- Use AutoPatch to apply Release 12.1.2 Patch 7303033 – Patch size is 3.2 GB
- Use AutoPatch to apply the latest consolidated online help Patch 7303032

Anonymous said...

Hi Ajikumar,

Well Post.

I am on R12.1.2 with 11.1.0.7.0 DB, should i follow your post? does we need on 11.2.0 DB?

Thanks

Ajikumar G said...

Not required.
Please refer Metalink note 1080973.1 and 11gR1 and 11.2.0.1 must refer to Document 761570.1 for information about making additions to their database initialization file, such as disabling fast validation for PL/SQL recompilations

jarrar said...

we are on R12.1.2 and DB on 11.2.0.1 and we want to upgrade to 12.1.3 with DB upgraded to 11.2.0.2. do we need interoperability patches for this?

Ajikumar G said...

Hi Jarrar
Please refer Note:1058763.1 Interoperability Notes EBS R12 with Database 11gR2. If not clear, please log SR with oracle.
Thanks,

Anonymous said...

Hi Ajikumar. Thanks for your expertise and sharing. Question. When upgrading from EBS12.1.2 to 12.1.3, do I use the path of Oracle E-Business Suite Release 12.1.3 RUP(9239090) OR Release 12.1.3 - R12.ATG_PF.B.delta.3(8919491)? and why?
Many thanks
-KevinC

kiran.thota said...

i want to practice R12.1.3 through online please help me