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.

2 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