Component Versions

Component Versions in Apps 11i/R12 ->

-> Apps Version (11i/R12/12i).

SQL> select release_name from apps.fnd_product_groups;

-> Web Server/Apache or Application Server in Apps 11i/R12

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

-> Forms & Report version (aka developer 6i) in 11i

$ORACLE_HOME/bin/f60run | grep Version | grep Forms

-> Forms & Report version in R12/12i

$ORACLE_HOME/bin/rwrun | grep Release

-> Oracle Jinitiator in 11i/R12/12i

grep jinit_ver_comma $CONTEXT_FILE

-> Oracle Java Plug-in in 11i/R12/12i

grep plugin $CONTEXT_FILE

-> File Version on file system

adident Header
strings | grep Header

-> Version of pld file

adident Header $AU_TOP/resource/.pll
strings $AU_TOP/resource/.pll | grep -i header

-> OA Framework Version

11i - http:// hostname.domainName:port/OA_HTML/OAInfo.jsp

adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

-> Discoverer Version for 11i (3i or 4i)

$ORACLE_HOME/bin/disc4ws | grep -i Version

-> Workflow Version with Apps

SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;

-> Identity Management component Version/Release Number

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

- To find Schema Version/ database use

ldapsearch -h -p -D “cn=orcladmin” -w “” -b “” \
-s base “objectclass=*” orcldirectoryversion

SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

-> Application Server
a. Oracle Application Server 10g Rel 3 (10.1.3.X)

cat $ORACLE_HOME/config/ias.properties | grep Version

b. For Oracle Application Server 10.1.2 (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;

c. AOC4J (Oracle Container for J2EE)

cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

d. Oracle Portal

SQL> select version from portal.wwc_version$;

-> Database Component
a. Oracle Database

SQL> select * from v$version;

b. All component version in database

$ORACLE_HOME/OPatch/opatch lsinventory -detail

-> Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release

-> Forms Version in 11i from front end?
Login to forms from frontend , -> Help -> ”About Oracle Applications -> Forms Server

-> How to find if your database is 32 bit or 64 bit

file $ORACLE_HOME/bin/oracle

-> How to find OUI version ?

./runInstaller -help ( From OUI location)

-> How to find Oracle Workflow Cartridge Release Version ?

owf_mgr> select wf_core.translate(\’WF_VERSION\’) from dual;

-> opatch version ?

$ORACLE_HOME/OPatch/opatch version

-> How to Discoverer Version installed with Apps ?

cd $ORACLE_HOME/discwb4/bin
strings dis4ws | grep -i 'discoverer version\'

-> How to find version of JDK Installed on Apps ?

cat $APPL_TOP/admin/$SID_$HOSTNAME.xml  | grep s_jdktop