About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.

Saturday, July 20, 2013

To find file versions in EBSO

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 Version for 11i
$ORACLE_HOME/bin/disc4ws | grep -i 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>

No comments:

Post a Comment