Articles on Emerging Technologies, Cloud Computing and Cyber Security

Monday, July 9, 2018

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?


Applies to:
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] on any platform.

On Application Tier
  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 :
Operation System
 
Command Line
Unix or Linux
$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 while you run this command in a single line
- Supply the apps user password as is applicable for parameter "-appspass"
Windows
%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 while you  run this command in 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.html -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. In case you have more than one application tier's (multi-node architecture), follow the steps 1-4 on each of the Application tiers
  3. Upload the report output file (default: $APPLTMP/Report_App_Inventory.html )to Oracle Support for review

On Database Tier
  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): 
Operation System
                                          
Command Line
Unix or Linux
$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"
Windows
%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.html -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
     Specific Component

    E-Business Suite Version.
    Connect to the database as user apps and run the following sql.
    SQL> select release_name from apps.fnd_product_groups;

    Workflow Version.
    Connect to the database as user apps and run the following sql.
    SQL> select distinct TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;

    Database version. 
    Connect to the database with sqlplus as sysdba and run next query:
    SQL> select * from v$version;

    Web Server or Application Server version.
    Oracle EBS 11i 
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    $IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

    Forms version.
    Logon the Applications Middle-tier as the Application owner, using ssh terminal..
    Set the correct environment variables and run next command:
    Oracle EBS 11i 
    $ORACLE_HOME/bin/f60run | grep Version | grep Forms

    Oracle EBS 12.2
    $ORACLE_HOME/bin/frmcmp_batch | grep Version | grep Forms

    Reports version.
    Oracle EBS 12.2
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    $ORACLE_HOME/bin/rwrun | grep Release
      
    Oracle Java Plug-in version. 
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    grep plugin $CONTEXT_FILE

    OA Framework Version.
    Oracle EBS 11i 
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    adident Header $FND_TOP/html/OA.jsp
    adident Header $OA_HTML/OA.jsp

    Weblogic server version.
    Oracle EBS 12.2
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

    Fusion Middle Ware (FMW) version.
    Oracle EBS 12.2
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables.
    Set the correct ORACLE_HOME variable:
    E.g. export ORACLE_HOME=/u001/oracle/R122/FMW_Home/Oracle_EBS-app1
    Run next command:
    $ORACLE_HOME/OPatch/opatch lsinventory







    Jinitiator version.
    Logon the Applications Middle-tier as the Application owner, using ssh terminal.
    Set the correct environment variables and run next command:
    grep jinit_ver_comma $CONTEXT_FILE
      




    0 Comments: