Script to collect diagnostic information required to analyze AD and TXK issues in EBS Release 12.2.x

Patch 19045166: SCRIPT TO COLLECT DIAGNOSTIC INFORMATION FOR 12.2 AD/TXK BUGS

This script has to be run in all the middletier nodes of the instance.

To use the script:

1. Unzip the patch to a new folder

2. Confirm the following files are present after unzipping.

        adzddbdetails.sql

        adzddiagnostic.pl

        adzdedndetails.sql

        README.txt

3. Source the Apps Tier run environment file

4. Run the master perl script adzddiagnostic.pl with the command "perl adzddiagnostic.pl"

5. Supply the apps database user password the script prompts for.

6. The script creates a file "diagnostic_info_.*" in the working directory.

7. Attach the file to the SR for analysis.

[dba1mgr@xxxx /apps/dba1mgr/UpgradePatches/12.2.4Upgradepatches]$ perl adzddiagnostic.pl

Enter the APPS password:

Please wait. Validating credentials...
Removing information collected from previous runs, if any...

$Header: /source/addev/ad/12.0/diag/bin/RCS/adzddiagnostic.pl,v 120.0.12020000.4 2015/03/27 11:48:02 rraam noship

Step  1 of 22 : Creating directories required to copy the diagnostic information....Done
Step  2 of 22 : Getting adop -status information....Done
Step  3 of 22 : Copying the ADOP logs folder....Done
Step  4 of 22 : Spooling contents of AD_ZD_LOGS table....Done
Step  5 of 22 : Spooling contents of AD_ZD_DDL_HANDLER table....Done
Step  6 of 22 : Getting the required information from Database....Done
Step  7 of 22 : Getting edition specific information from run edition....Done
Step  8 of 22 : Copying run and patch context files....Done
Step  9 of 22 : Getting adutconf report....Done
Step 10 of 22 : Getting perl code level in the instance....Done
Step 11 of 22 : Getting C code level in the instance....Done
Step 12 of 22 : Getting listener.ora and tnsnames.ora....Done
Step 13 of 22 : Checking if adop process is active....Done
Step 14 of 22 : Copying Instance Logs from run file system....Done
Step 15 of 22 : Copying Instance Logs from patch file system....Done
Step 16 of 22 : Copying Domain configuration file....Done
Step 17 of 22 : Downloading context file from database....Done
Step 18 of 22 : Copying inventory.xml....Done
Step 19 of 22 : Executing txkInventory.pl....Done
Step 20 of 22 : Copying /etc/hosts....Done
Step 21 of 22 : Trying to connect to patch edition....Done

Completed collecting all the diagnostic information.

Step 22 of 22 : Archiving the diagnostic_info folder....Done

Please provide the file diagnostic_info_tblnxdbtst.tar.bz2 for further analysis.