Hidden Features Revealed: Technology Inventory Utility for Apps 12

[Oct 24, 2008 Update: It turns out that this utility is documented in Chapter 5 of the "System Administrator's Guide - Maintenance." Who knew? So much documentation, so little time.]

[Editor:  One of the best-kept secrets in the Release 12 technology stack is an undocumented utility for generating reports about your servers.  This tool is a useful complement to the R12 Diagnostic Tools, and a handy way of getting a snapshot of the different ORACLE_HOMEs for a given node in your environment.  In this article, Prasad gives a quick rundown on using this hidden tool.]


The Technology Inventory Utility for Release 12 is a perl utility that uses the perl infrastructure installed with the Oracle E-Business Suite R12 technology stack. Here's a screenshot of the first few lines of the report (there's much more -- see the samples linked, below):

Technology Inventory Utility Sample Screenshot: Screenshot of sample Technology Inventory Utility report for E-Business Suite Release 12

This utility is available with the Release Update Pack 12.0.3 and higher. If you don't wish to apply that entire RUP, this utility can be applied via the latest Autoconfig patchset:

How to run the utility

On each of the Applications tier nodes:
  1. Source the env file on each of the Applications tier node
  2. Run the following command (all on a single line):

    $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl
    -txktop=$APPLTMP
    -outfile=$APPLTMP/Report_Inventory.html


  3. Enter the apps password at the prompt
  4. Check the report generated in the location specified in the outfile argument of the command above.
The report generated by this utility is HTML by default. A text report also can be generated using a command line option.

On each of the DB tier nodes:
  1. Source the env file on each of the DB tier node
  2. Run the following command (all on a single line):

    $ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl 
    -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl
    -txktop=$ORACLE_HOME/appsutil/temp
    -contextfile=$CONTEXT_FILE
    -outfile=$ORACLE_HOME/appsutil/temp/rep.html

  3. Enter the apps password at the prompt
  4. Check the report generated in the location specified in the outfile argument of the command above.
Information in the Report

This utility generates three different tables with node-specific information.

Overview of your system
  • Time stamp, Host name,Enabled services(depending on the node type, the following services will be displayed - Root Service, Web Entry Point Services, Web Application Services, Other Services)
  • Instance name, Platform, OS release,DB Host
  • Context file location,Report file location
List of Component Versions and Properties

The information listed here depends on the node type.

For a middle-tier HTTP service, versions of the following components are listed:
    • Oracle Application Server, Sun JDK, JDK on HTTP server node, AOLJ, BC4J, BI Beans, HTTP client, Java object cache, JRAD libraries, MDS, OA Framework, Oracle Help for Web, Oracle XML driver, UIX, OJSP, JDK version used by AD utilities on HTTP node, DB client(RSF) in 10.1.3 the Oracle Home, OWA packages
For a middle-tier Forms service, versions of the following components are listed:
    • 10g Developer, DB client(RSF) in the 10.1.2 Oracle Home, Forms run time configuration, JDK used by AD utilities in the Forms service node, Oracle Applciation Server patchset
For a middle-tier Concurrent Processing service, versions of the following components are listed:
    • JDK and JDK used by the AD utilities
For the DB-tier service, the following information is generated:
    • Database version, DB patchset version
    • init.ora parameters set by Autoconfig
    • If the node is RAC enabled or not
List of Applied Patches

The Code Inventory table list the one-off patches applied on each of the Oracle Home based on the node type.
    • For a middle-tier node - list of the one-off patches and the date they were applied on the C-Oracle Home ( 10.1.2), on the Java Oracle Home ( 10.1.3 OC4J)

    • For a DB tier node - list of the one-off patches and the date they were applied on the DB Oracle Home.
Sample Reports

Two samples of the database tier and application tier reports are available here:
Related Articles

Comments:

Hello Steve / Prasad,

Thanks for this article ! However, and not to discredit your efforts, I was wondering if this tool generates any information that the RDA (remote diagnostics agent) 4.10 doesn't already ?
Again, thanks for sharing this knowledge item !

regards,
Rehan Yusuf

Posted by Rehan Yusuf on January 23, 2008 at 03:30 PM PST #

Hi,

I have looked at RDA output for Release 12. It is a great tool for a bird's eye view of EBS info. But, Inventory goes into the next level of detail for the Technology Stack components. I see more value add for the information from the Applications tier from Inventory report. Also, information like if the env is RAC enabled or not. Where I can see the value add:

1. About the components that constitute the technology stack - table for service properties on the middle-tier for HTTP and Forms service has lot of rich information. This info is not in RDA.
2. Patches installed on each Oracle Home is not given by RDA. This is very crucial piece of info for patchset upgrade and CPU patch application on the three Oracle Homes in EBS Rel 12.
3. Inventory utility is tightly coupled with Autoconfig in terms of configuration management related information.

Posted by Prasad Akkiraju on February 15, 2008 at 02:05 PM PST #

Hello, Rehan,Sorry for the delay in replying -- things have been busy in Apps Development.Prasad did a functional comparison between RDA and the Technology Inventory Utility.  Here are his remarks:<snip>There are a few things that [the Technology Inventory Utility] report generates apart from what RDA has:Not all the technology component versions are available in RDA. Similarly No CPU patch information in each Oracle Home is available in RDA. </snip>Regards,Steven 

Posted by Steven Chan on February 20, 2008 at 03:33 AM PST #

Thanks for pointing this out. To my surprise, I found this works for 11.5.10 as well. See metalink note 601736.1 for details. I just wanted to point out that it wasn't brand new to release 12. The info is slightly different from 11i, but the majority of information is the same.

Thanks!
Barry

Posted by Barry Daugherty on July 15, 2009 at 05:00 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today