1) Database Version
SQL> desc v$version
Name Null? Type
—————————————– ——– —————————-
BANNER VARCHAR2(80)
SQL> select banner from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production
2) Application Release.
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.1
3) Web Server/Apache or Application Server in Apps 11i/R12
A. Log in as Application user, set environment variable and run below query$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version
[appl201@prdcl201 bin]$ httpd -version
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built: Jul 7 2008 14:58:00
[appl201@prdcl201 bin]$ pwd
/patches/applprod/apps/tech_st/10.1.3/Apache/Apache/bin
4A) Forms & Report version (aka developer 6i) in 11i
A. 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)
.
4B) Forms & Report version in R12
A. 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)
.
4B) Forms & Report version in R12
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like
[appl201@prdcl201 bin]$ rwrun | grep Release
REP-0503: You did not specify the name of a report.
Report Builder: Release 10.1.2.3.0 – Production on Tue Jul 19 10:36:21 2011
[appl201@prdcl201 bin]$ pwd
/patches/applprod/apps/tech_st/10.1.2/bin
5) OracleJinitiator in11i/R12/12i
A. Log in as Application user, set environment variable and run below query
[appl201@prdcl201 bin]$ grep jinit_ver_comma $CONTEXT_FILE
A. Log in as Application user, set environment variable and run below query
[appl201@prdcl201 bin]$ grep jinit_ver_comma $CONTEXT_FILE
<jinit_ver_comma oa_var=”s_jinit_ver_comma”>1.6.0_07</jinit_ver_comma>
6) RED HAT RELEASE
[appl201@prdcl201 bin]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
7) JAVA PLUGIN
[appl201@prdcl201 bin]$ grep plugin $CONTEXT_FILE
<!– JDK plugins –>
<sun_plugin_ver oa_var=”s_sun_plugin_ver”>1.6.0_07</sun_plugin_ver>
<sun_plugin_type oa_var=”s_sun_plugin_type”>jdk</sun_plugin_type>
8) APPLICATION SERVER VERSION
[appl201@prdcl201 12.0.0]$ cat $ORACLE_HOME/config/ias.properties | grep Version
Version=10.1.2.3.0
9) OC4J(Oracle Container for J2EE)
[appl201@prdcl201 home]$ java -jar oc4j.jar -version
Oracle Application Server Containers for J2EE 10g (10.1.2.3.0) (build 080228.2305.2133)
[appl201@prdcl201 home]$ pwd
/patches/applprod/apps/tech_st/10.1.2/j2ee/home
oraclemakeeasy 