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.