Monday Aug 18, 2008

Application Management Pack for Oracle E-Business Suite 2.0.2 Now Available

Oracle E-Business Suite Application Technology Group (ATG) is pleased to announce the availability of the Application Management Pack for Oracle E-Business Suite (EBS) version 2.0.2 Rollup update. This pack is available through Oracle Metalink, as patch 6809246.[Read More]

Wednesday Jan 23, 2008

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

About

Search

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