File Versions in Oracle Apps

Version of perl
perl -v

Version of opatch
$ORACLE_HOME/OPatch/opatch version

JDK:
Open your Context File and look for variable
JDK_TOP oa_var="s_jdktop"

Java Version
============
$ORACLE_HOME/jdk/bin/java -fullversion

JRE:
====
bash-3.2$  cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
sun_plugin_version=1.7.0_13

OUI:
$ORACLE_HOME/oui/oraparam.ini
grep -i oui_version $ORACLE_HOME/oui/oraparam.ini

How to find Apps Version (11i/R12/12i).
select release_name from apps.fnd_product_groups;

Web Server/Apache or Application Server:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

Forms & Report version (aka developer 6i) in 11i:
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

bash-3.2$ $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version in R12
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)


Oracle Jinitiator in 11i/R12/12i:
grep jinit_ver_comma $CONTEXT_FILE

Discoverer:
============
Discoverer Version for 11i
$ORACLE_HOME/bin/disc4ws | grep -i Version

Discoverer Version for 12i(From ia user)
$ cd  $ORACLE_HOME/discoverer/lib
$ strings -a libdc*.so | grep "Version:"
                 
                      or

$cd $ORACLE_HOME/bin
$strings -a dis51ws | grep -i 'Discoverer version'

                      or

cd SID/disco11g/product/disco_111/bin
$strings -a dis51ws | grep -i 'Discoverer version'


Application Server:
cat $ORACLE_HOME/config/ias.properties | grep Version

Oracle Portal
SQL> select version from portal.wwc_version$;

To find database version
SQL> select * from v$version;

Servlet Or Socket
=================
grep -i forms_connect $CONTEXT_FILE

To find a particular file
=========================
find . -name orion-web.xml web.xml


echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file  zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt
###

Q How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?
Ans:execute \”file $ORACLE_HOME/bin/oracle\” ,

Techstack Versions:
====================

bash-3.2$ grep "ias_version" $CONTEXT_FILE
         <ias_version oa_var="s_ias_version">10.1.3.5.0</ias_version>

bash-3.2$ grep "forms_version" $CONTEXT_FILE
         <forms_version oa_var="s_forms_version">10.1.2.3.0</forms_version>