1.How to find E-Business Suite Version:
Connect to the database with sqlplus as user apps and run query:
SQL> select release_name from apps.fnd_product_groups;
2.How to find the Workflow Version:
Connect to the database with sqlplus as user apps and run query:
SQL> select distinct TEXT Version from WF_RESOURCES where NAME = 'WF_VERSION';
3.How to find the Web Server or Application Server version:
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
4.How to find the Forms & Reports version in EBS 11i
Logon the Applications Middle-tier as the Application owner(ex:applmgr), using a putty terminal.
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
5.How to find the Forms & Reports version in EBS R12
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/rwrun | grep Release
6.How to find the Jinitiator version:
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep jinit_ver_comma $CONTEXT_FILE
7.How to find the Oracle Java Plug-in version:
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep plugin $CONTEXT_FILE
8.How to find the OA Framework Version (11i only):
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp
9.How to find the Database version:
Connect to the database with sqlplus as sysdba and run query:
SQL> select * from v$version;
10.How to find the Weblogic server version in EBS R12.2:
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
11.How to find the Fusion Middleware (FMW) version in EBS R12.2
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
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
No comments:
Post a Comment