–What version of EBS and components am I running?
–From the Application: Help > About Oracle Applications
–From the Database: Query APPS.FND_PRODUCT_GROUPS.RELEASE_NAME
select release_name from apps.fnd_product_groups;
SELECT codelevel FROM apps.AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');
SELECT app_short_name, MAX(patch_level)
FROM apps.ad_patch_driver_minipks
GROUP BY app_short_name ;
–Log in as Application user, set / source the applmgr environment variables and run the command below
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built: Dec 24 2010 18:22:43
Forms & Report version (Developer 6i) in 11i >> Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
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
Report Builder: Release 10.1.2.2.0
–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
strings $AU_TOP/resource/<filename>.pll | grep -i header
Workflow Version with Apps >> Connect to Database as apps user
SQL> select TEXT Version from WF_RESOURCES where NAME = ‘WF_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
oidldapd: Release 10.1.4.0.1 – Production on th..
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
version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1
or run the following query
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;
OID 10.1.4.0.1
–Application Server >> Oracle Application 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
–find Weblogic version
. /d01/oracle/VIS/EBSapps.env run
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
WLS_PRODUCT_VERSION=10.3.6.0
To find the FMW version Oracle E-Business Suite Component Version on R12.2
export ORACLE_HOME=/d01/oracle/VIS/fs1/FMW_Home/Oracle_EBS-app1
./opatch lsinventory
Oracle E-Business Suite Component 11.1.1.6.0
EBS Component Levels
select patch_level from fnd_product_installations where patch_level like ‘%AD%’;
select patch_level from fnd_product_installations where patch_level like ‘%FND%’;
Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release
or
Oracle Linux -> cat /etc/oracle-release
What Linux kernel?
uname -a
References:
http://onlineappsdba.blogspot.com/2008/04/how-to-find-out-if-product-is-installed.html