Script To Check The Techstack Component Versions in Unix/Linux Environment

Introduction:

In this article, we will find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc

On Application Tier in Linux:

  1. Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
  2. Ensure “APPLRGF” variable is set in environment. If not, set it to the same value as “APPLTMP” (Note: If you set the output file directory using -outfile parameter, skip this step and the file will be generated under $APPLRGF/TXK directory).
  3. Navigate to <FND_TOP>/patch/115/bin. Run the utility/command  as follows :

$ADPERLPRG $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_App_Inventory.html

Note:
– Run the above command in single line
– Remove the ‘\’ after each parameter when running the command on a single line
– Supply the apps user password as is applicable for parameter “-appspass”

Where:

   
txktop Temporary working directory use by Perl Modules. Should not be an empty string.
contextfile Location of the context file. If not passed, default is picked from the environment.
appspass APPS schema password. If not passed, default password is used.
outfile Location for the report being generated. If not passed, the default location is <APPLTMP>/TXK

To generate the report in text format, the parameter “-reporttype=text” needs to be passed to the above commands. For example:

outfile=$APPLTMP/Report_App_Inventory.txt -reporttype=text
  1. Once the command executes successfully, it should generate the report file in the location specified for “outfile” parameter in above script
  1. In case you have more than one application tier’s (multi-node architecture), follow the steps 1-4 on each of the Application tiers
  2. Upload the report output file (default: $APPLTMP/Report_App_Inventory.html )to Oracle Support for review.

On Database Tier in Linux

  1. Establish the needed environment parameters by sourcing the Database environment file as the owner of the Database tier file system. |
  2. Ensure “ORACLE_HOME” variable is set in environment and correctly pointing to your database ORACLE_HOME.
  3. Navigate to <ORACLE_HOME>/appsutil/bin. Run the utility/command as below (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
-appspass=apps
-outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html

Note:
– Run the above command in single line
– Supply the apps user password as is applicable for parameter “-appspass”

Where

   
txktop Temporary working directory use by Perl Modules. Should not be an empty string.
contextfile Location of the context file.
appspass APPS schema password.
outfile Location for the report being generated.

To generate the report in text format, the parameter “-reporttype=text” needs to be passed to the above commands. For example:

outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.txt -reporttype=text
  1. Once the command executes successfully, it should generate the report file in the location specified for “outfile” parameter in above script
  2. Upload the report output file (default: $ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html ) to Oracle Support for review.
Recent Posts