How to find component versions in 11i/R12

How to find Apps Version (11i/R12/12i) >>  Connect to database as user apps SQL> select release_name from apps.fnd_product_groups; Output like 12.0.4 or 11.5.10.2 Web Server/Apache or Application Server in Apps 11i/R12 >> Log in as Application user, set environment variable and run below query  $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version Output for 11i should be like Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix) Server built:   Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5) Output for R12 should be like Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server Server built:   Dec  4 2006 14:44:38 Forms & Report version (aka developer 6i) in 11i >> Log in as Application user, set environment variable and run below query $ORACLE_HOME/bin/f60run | grep Version | grep Forms output like Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production) Check fourth character in version 25 which means Forms 6i patchset 16 (25-9) Forms & Report version in R12/12i >> Log in as Application user, set environment variable and run below query $ORACLE_HOME/bin/rwrun | grep Release Output should be like Report Builder: Release 10.1.2.2.0 You can safely ignore warnings Oracle Jinitiator in 11i/R12/12i >> Log in as Application user, set environment variable and run below query grep jinit_ver_comma $CONTEXT_FILE (Default is Java Plug-In for R12/12i ) Oracle Java Plug-in in 11i/R12/12i >> Log in as Application user, set environment variable and run below query grep plugin $CONTEXT_FILE   File Version on file system >> adident Header <filename> or strings <file_name> | grep Header Here adident is AD Utility (Oracle Apps) and strings is Unix utility Version of pld file >> *.pld are source code of *.pll which are inturn source of *.plx.  *.pll is in $AU_TOP/resource and to find its version check adident Header $AU_TOP/resource/<filename>.pll IGSAU012.pll: $Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $ or strings $AU_TOP/resource/<filename>.pll | grep -i header FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’); OA Framework Version >> http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i);  Log in as Application user, set                                         environment variable and run below query adident Header $FND_TOP/html/OA.jsp adident Header $OA_HTML/OA.jsp output for both should look like $Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $ 120.21 means OA Framework Version (coming soon..) 115.60 means OA Framework Version (coming soon..) 115.56 means OA Framework Version (coming soon..) 115.36 means OA Framework Version 5.7 115.27 means OA Framework Version 5.6E 115.26 means OA Framework Version 5.5.2E  Discoverer Version for 11i (3i or 4i) >>  Log in as Application user, set environment variable and run below query $ORACLE_HOME/bin/disc4ws | grep -i Version Discoverer Version for 11i or R12 (10g AS) >> Check under Application Server Section as 10g AS Discoverer is on standalone Workflow Version with Apps >> Connect to Database as apps user SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’; Output like 2.6.0 means workflow version 2.6.0 Oracle Single Sign On >> Connect to database which holds SSO repository SQL>select version from orasso.wwc_version$; Oracle Internet Directory >> There are two component in OID (Software/binaries & Schema/database) >>> To find software/binary version $ORACLE_HOME/bin/oidldapd -version output should look like oidldapd: Release 10.1.4.0.1 - Production on thu sep 11 11:08:12 2008 Copyright (c) 1982, 2006 Oracle.  All rights reserved. >>> To find Schema Version/ database use ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \ -s base “objectclass=*” orcldirectoryversion and output should be like version: 1 dn: orcldirectoryversion: OID 10.1.4.0.1 or run following query in database SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’; Output should be like OID 10.1.4.0.1 Application Server >> Oracle Application Server (Prior to Oracle WebLogic Server) If application server is registered in database (Portal, Discoverer) check from database SQL> select * from ias_versions; or SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS; AOC4J (Oracle Container for J2EE) Set ORACLE_HOME cd $ORACLE_HOME/j2ee/home java -jar oc4j.jar -version Oracle Portal >> SQL> select version from portal.wwc_version$; Database Component I) Oracle Database To find database version SQL> select * from v$version; or All component version in database $ORACLE_HOME/OPatch/opatch lsinventory -detail Oracle Enterprise Manager >> Metalink Note 605398.1  How to to find the version of the main EM components Unix Operating System Solaris -> cat /etc/release Red Hat Linux -> cat /etc/redhat-release