Thursday, April 22, 2021

EBS Upgrade Analyzer and ICM ADOP Analyzer

During the EBS Upgrade to 12.2 version or while you are running into issues with ADOP cycle in EBS 12.2 version and you had to raise an SR with Oracle Support then always oracle will ask you to upload the subject Analyzer reports output to the SR for analysis. 

Here I have mentioned the ways you can generate this Analyzer reports from both Application and Database tiers. 

 It requires Java 1.7 and above to run ADOP Analyzer or EBS Upgrade Analyzer.

Always download the latest analyzer scripts from support.oracle.com from below notes,

E-Business Suite Upgrade Analyzer - 12.X to 12.2.X (Doc ID 2634237.1)

EBS Installation Configuration Management (ICM) Application DBA Online Patching (ADOP) Analyzer (Doc ID 2379656.1)

These are non-invasive script - the Analyzer does not perform any INSERTs, UPDATEs or DELETEs to your data; it just reports on it.

Generate Upgrade Analyzer Report:

on Application Node:

1. Source the APPS run filesystem environment

2. Run the E-Business Suite Applications Tier Upgrade Analyzer using this java command :

$ java -Danalyzer="atg_upgrade_analyzer.xml" -jar HA-UPG.jar

on Database Node:

1) Source the Database Tier environment

2) Run the E-Business Suite Database Tier Upgrade Analyzer using this java command :

$ java -Danalyzer="atg_upgrade_database_analyzer.xml" -jar HA-UPG.jar

Generate ICM ADOP Analyzer Report:

on Application Node:

1. Source the APPS run filesystem environment

2.  Unzip icm_adop_analyzer_200_x.zip in a directory with proper permissions.

3. Navigate to the directory from step 2 and change directory to HAF and run the ICM ADOP Analyzer using this command

$ cd HAF

$ sh run_analyzer.sh -Danalyzer="icm_adop_analyzer.xml"

on Database Node:

1. Source the Database Tier environment

2. Unzip icm_adop_analyzer_200_x.zip in a directory with proper permissions.

3. Navigate to the directory from step 2 and change directory to HAF and run the ADOP Database Analyzer using this command :

$ cd HAF

$ sh run_analyzer.sh -Danalyzer="adop_database_analyzer.xml"