Saturday, December 18, 2010

How to Find Out Versions - I

Finding Versions - I
============

OS VERSION
----------
$ uname -a
Linux auohszcoi01 2.4.9-e.35enterprise #1 SMP Tue Dec 23 00:06:16 EST 2003 i686

file /sbin/init
/sbin/init: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), stripped

JAVA VERSION
-----------

$ grep JSERVJAVA $APACHE_TOP/Apache/bin/java.sh
$ /usr/java/jdk1.3.1_02/jre/bin/java version
$ ls -l /usr/java/jdk1.3.1_02/jre/bin/java

FINDING JAVA FILE VERSION
-------------------------
Once you are in the correct directory (which should be the $JAVA_TOP), you
can perform the following to get the file version to get the version of

ItemEOImpl.class, for example:
---------------------------------------------------------------------------
ident apps.zip | grep -i 'ItemEOImpl'
---------------------------------------------------------------------------

If the above doesn't work, please try the following:
---------------------------------------------------------------------------
strings -a apps.zip|grep -i header|grep ItemEOImpl.java

strings -a ./apps/inv/transaction/server/BaseTransaction.class | grep Header

IF apps.zip is not available under JAVA_TOP, then,

1- Go to $JAVA_TOP
2- give a find Command with file name..
eg:
find . -print | grep BaseTransaction
find . -print | grep telnetdemo

out put could be like this...

/oracle/apps/inv/transaction/server/BaseTransaction.class
then cd to the /oracle/apps/inv/transaction/server/

strings -a BaseTransaction.class|grep Header

Or from SQLPLUS

sql> set serveroutput on
sql> exec
fnd_aolj_util.getclassversionfromdb('oracle.apps.inv.transaction.server.TrxP
rocessor');

DISCOVERER
----------

cd $ORACLE_HOME/discwb4/bin

strings -a dis4ws | grep -i 'Discoverer version'

In both cases make sure you have read / write priviledges on the files dis51ws and dis4ws

$ strings -a dis4ws | grep -i 'Discoverer version'
Discoverer Version:Session 4.1.48.08.00

PORTAL verions
--------------

select version from wwc_version$;
or
select i.instance_name INSTANCE, i.host_name HOST , f.release_name release, i.version from v$instance i, fnd_product_groups f where upper(substr(i.instance_name,1,4)) = upper(substr(f.applications_system_name,1,4));

DB version
----------

col instance_name format a13
col host_name format a15
col version format a9
col release format a7
select i.instance_name, i.host_name, f.release_name release, i.version
from v$instance i, fnd_product_groups f
where i.instance_name = f.applications_system_name;
or
select * from v$version;
or
select BANNER from V$VERSION where BANNER like 'Oracle%';

Apps Version
-------------
SELECT 'VERSION = ', release_name FROM fnd_product_groups;
Or
SELECT substr(a.application_short_name, 1, 5) code,
substr(t.application_name, 1, 50) application_name,
p.product_version version
FROM fnd_application a,
fnd_application_tl t,
fnd_product_installations p
WHERE a.application_id = p.application_id
AND a.application_id = t.application_id
AND t.language = USERENV('LANG');
Or
select product_group_id, product_group_name, release_name, product_group_type, argument1 from fnd_product_groups;


PRODUCT versions
----------------
cd $AD_TOP/sql/adutconf.sql
SQL> @adutconf.sql
This creates a text file adutconf.lst in the current working directory
Or
a) Find all products and statuses:
select application_id, status
from fnd_product_installations;
or
b) Find the status of a particular product:

E.g. Application_id:
PER (Human Resources) = 800
PAY (Payroll) = 801

select application_id, status
from fnd_product_installations;
where application_id = '%80%';
Status:
I = Installed
S = Shared
N = Not Installed

WEBCACHE version
----------------

$ORACLE_HOME/webcache/bin/webcached –version
output :
Oracle Web Cache, Version 2.0.0.4.0
Copyright: Oracle Corporation, 1999-2002
Build CALYPSO_2.0.0_SOLARIS_020405

.pld version
-----------
strings –a $AU_TOP/resource/.plx | grep ‘$Header:’

.pls version
-------------

strings –a $/patch/115/sql/.pls | grep ‘$Header:’

.pll version
-------------

strings –a $/plsql/.pll | grep ‘$Header:’

.plx version
-------------
strings –a $/resource/US/.plx | grep ‘$Header:’

.rdf version
-------------
strings –a $JE_TOP/reports/US/.rdf | grep ‘$Header:’

OA Framework Version
-----------------------
http://:/OA_HTML/OAInfo.jsp

Jinitiator version
-------------
select text from wf_resources where name like 'WF_PLUGIN_VERSION%';

Forms Version
-------------

cd 806_ORACLE_HOME/bin
type “ f60run ” and hit enter
This will give you the forms version.
Other option, open any form from front-end applications and click on About Oracle Applications.

3 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in TECHNOLOGY , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor-led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ pieces of training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Pratik Shekhar
    MaxMunus
    E-mail: pratik@maxmunus.co
    Ph:(0) +91 9066268701
    http://www.maxmunus.com/

    ReplyDelete
  3. Thanks a lot for sharing a valuable blog on OA Framework. I was browsing through the internet looking for OAF and Oracle ADF and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information about OAF by attending OA Framework Online Training. You can learn about interview questions by visiting OAF Interview Questions

    ReplyDelete