Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Sunday, December 21, 2014

Kickstart Your Oracle Apps R12.2 Upgrade Project With Upgrade Readiness Report Analysis

Hi All,

If you are planning for a R12.2 upgrade, To get initial idea on how much of work is required for standard & custom remediation and making it online patching compliant, we can start with upgrade readiness patch and API's

Readiness Assessment from Oracle (Patch 14125620)

Download and apply the patch 14125620. It bears few SQL scripts which scans the dictionary for the system compliance with the Online Patching feature.

unzip p14125620_R12_GENERIC.zip
cd 14125620
adpatch patchtop=`pwd` logfile=adpatch.u14125620.log driver=u14125620.drv options=hotpatch

Sequentially run scripts delivered by the patch

sqlplus system @$AD_TOP/sql/ADZDPSUM.sql APPS

sqlplus system @$AD_TOP/sql/ADZDPAUT.sql APPS

sqlplus system @$AD_TOP/sql/ADZDPMAN.sql APPS

Review generated report

adzdpsum.txt - each section of this report should be reviewed carefully and take appropriate actions.

adzdpman.txt - for detail and follow given instructions

adzdpaut.txt – optional foe review as these violations would be fixed automatically when your instance is enabled for Online Patching.

Let me know, If you like to see a sample upgrade readiness report. Leave me a mail @ ajithpathiyil@gmail.com


 HAPPY LEARNING!

1 comment:

  1. If you are planning for a R12.2 upgrade, To get initial idea on how much of work is required for standard & custom remediation and making it online patching compliant, we can start with upgrade readiness patch and API's Hack Yahoo Account

    ReplyDelete

Thanks for you valuable comments !