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.