This chapter describes the Technology Inventory Utility that was introduced in Oracle E-Business Suite Release 12. This command-line utility generates reports that list the installed technology stack components and versions on the various nodes of a Release 12 Oracle E-Business Suite system. The reports can be generated in either HTML (the default) or text format. Separate reports are generated for the database and application tiers.
Since there are major differences in technology components between Release 11i and Release 12, this utility will also be useful for those who wish to become familiar with the components and versions employed by Release 12.
The Technology Inventory Utility generates a consolidated report that summarizes the version levels of all installed technology stack components.
Set your Oracle E-Business Suite environment, then run one of the following commands:
Application tier:
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$APPLTMP/Report_Inventory.html
Database tier:
perl $ORACLE_HOME/appsutil/bin/TXKScript.pl -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html
Note: To generate the report in text format, append -reporttype=text to the relevant command, and change the outfile name to have a .txt suffix instead of a .html suffix.
Application tier:
perl %FND_TOP%\patch\115\bin\TXKScript.pl -script=%FND_TOP%\patch\115\bin\txkInventory.pl -txktop=%APPLTMP% -contextfile=%CONTEXT_FILE% -appspass=apps -outfile=%APPLTMP%\Report_Inventory.html
Database tier:
perl %ORACLE_HOME%\appsutil\bin\TXKScript.pl -script=%ORACLE_HOME%\appsutil\bin\txkInventory.pl -txktop=%ORACLE_HOME%\appsutil\temp -contextfile=%CONTEXT_FILE% -appspass=apps -outfile=%ORACLE_HOME%\appsutil\temp\Report_Inventory.html
Note: To generate the report in text format, append -reporttype=text to the relevant command, and change the outfile name to have a .txt suffix instead of a .html suffix.
The following table describes the parameters for the utility:
| Parameter | Usage |
|---|---|
| txktop | Temporary working directory used by perl modules. Required parameter. |
| contextfile | Location of the Applications context file. If not specified, default is picked from environment. |
| appspass | APPS schema password. If not specified, default password is used. |
| outputfile | Location of the report being generated. If not specified, the default location is $APPLTMP/TXK. |
The report generated on both the application and database tiers has the following common header:
| Parameter | Usage |
|---|---|
| Date | Date on which report was generated. |
| Hostname | Details of host on which report was generated. |
| Enabled Services | Services enabled on the host where report was generated (application tier only). |
| Instance | Name of the instance. |
| Platform | OS name of the host where report was generated. |
| OS | OS release version of the host where report was generated. |
| DB Host | Details of the host where database is located. |
| Context File | Location of the context file specified when the report was generated. |
| Report File | Location of the report that was generated. |
| XML Definition File | Lists actions executed to obtain the contents of the report. |
The contents of the main report reflect the role of the node on which the utility is run: Database, Web, Forms, or Concurrent Processing.
For example, the report for the database might include:
Database Service Properties (apps1.company.com):
| Technology Component/Property | Component Version/Value |
|---|---|
| Database version from dbms_utility | 10.2.0.2.0 |
| JOB_QUEUE_PROCESSES database parameter | 2 |
| UNDO_MANAGEMENT database parameter | AUTO |
| Amount of temporary tablespace in MB assigned to the APPS schema | 3724 |
| UTL_RECOMP package is found in the database. | TRUE |
| Number of CPUs | 4 |
| PARALLEL_MAX_SERVERS database parameter | 8 |
| O7_DICTIONARY_ACCESSIBILITY database parameter | FALSE |
| SYSTEM tablespace size in MB | 11668 |
| RAC-enabled | FALSE |
| Oracle Database 11g patchset version | 11.1.0.6.0 |
Examples of the sections of the Application Tier report follow.
The report for a Web services node might include:
HTTP Service Properties (apps2.company.com):
| Technology Components / Properties | Component Version/Value |
|---|---|
| Oracle Application Server version | 10.1.3.0.0 |
| Sun JDK Client version | 1.5.0_10 |
| JDK version on HTTP server node | 1.5.0_08 |
| Oracle JDBC driver version using JAVA API (oracle.jdbc.driver.OracleDriver) | 10.2.0.2.0 |
| Oracle AOL/J version | Roll Up Patch J |
| Oracle BC4J version | 10.1.3.39.81 |
| Oracle BI Beans version | 3.1.1.5 |
| Oracle HTTP Client version | 10h |
| Java Object Cache | 10.1.3 |
| Oracle JRAD libraries version | 10.1.3 |
| Oracle MDS version | 9.0.6.0.0_22 |
| OA Framework version | 12.0.0 |
| Oracle Help Web version | 2.0.8 |
| Oracle XML driver version | 10.1.3.0.0 |
| Oracle UIX version | 2_3_6 |
| OJSP version | 10.1.3.0.0 |
| JDK version used by AD utilities on HTTP server node | 1.5.0_08 |
| Number of symbolic links found under directories served by Oracle HTTP server | 0 |
| DB client (RSF) library version in OracleAS 10.1.3 Oracle Home | 10.1.0.2.0 |
| Version of OWA packages | 10.1.2.0.0 |
| Package OWA_MATCH exists in SYS schema | TRUE |
The report for a Forms services node might include:
Forms Service Properties (apps2.company.com):
| Technology Components / Properties | Component Version/Value |
|---|---|
| Developer 10g version | 10.1.2.0.2 |
| DB client (RSF) library version in OracleAS 10.1.2 Oracle Home | 10.1.0.5.0 |
| Forms runtime configuration from Applications context file | socket |
| JDK version used by AD utilities on Forms node | 1.5.0_08 |
| Oracle Application Server patchset version | 10.1.2.0.2 |
The report for a Concurrent Processing (CP) server node might include:
Concurrent Processing Service Properties (apps2.company.com):
| Technology Components / Properties | Component Version/Value |
|---|---|
| JDK version on Concurrent Processing node | 1.5.0_08 |
| JDK version used by AD Utilities on Concurrent Processing node | 1.5.0_08 |
This report also lists each one-off patch and its date and time of application to the OracleAS 10.1.2 Oracle Home or OracleAS 10.1.3 Oracle Home
A future release of Oracle E-Business Suite will build on the Inventory Utility to validate the components in use.