Oracle Release/Version Number for Apps/ Forms/ Jinitiator/ OID/ SSO/ Portal/ iAS/ OC4J/ Unix/ xxxx ….

Find component Version in Apps 11i/R12/12i

Q. How to find Apps Version (11i/R12/12i).
A.  Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output like 12.0.4 or 11.5.10.2

Q. Web Server/Apache or Application Server in Apps 11i/R12
A. Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built:   Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)

Output for R12 should be like
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built:   Dec  4 2006 14:44:38

Q. Forms & Report version (aka developer 6i) in 11i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

output like
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)

.
Q. Forms & Report version in R12/12i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release

Output should be like
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings

Q. Database Version in 11i/R12/12i
A. Go to database section below.

Q. Oracle Jinitiator in 11i/R12/12i
A.
Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

(
Default is Java Plug-In for R12/12i )

Q. Oracle Java Plug-in in 11i/R12/12i
A.
Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
Q. File Version on file system
adident Header <filename>
or
strings <file_name> | grep Header

Here adident is AD Utility (Oracle Apps) and strings is Unix utility

Q. Version of pld file
*.pld are source code of *.pll which are inturn source of *.plx.  *.pll is in $AU_TOP/resource and to find its version check

adident Header $AU_TOP/resource/<filename>.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $

or
strings $AU_TOP/resource/<filename>.pll | grep -i header

FDRCSID(‘$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);

Q. OA Framework Version
A.http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)

A.  Log in as Application user, set environment variable and run below query

adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

output for both should look like
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $

120.21 means OA Framework Version (coming soon..)
115.60 means OA Framework Version (coming soon..)
115.56 means OA Framework Version (coming soon..)
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E

Q. Discoverer Version for 11i (3i or 4i)
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version

Q. Discoverer Version for 11i or R12 (10g AS)
Check under Application Server Section as 10g AS Discoverer is on standalone

Q. Workflow Version with Apps
A.
Connect to Database as apps user
SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;
Output like 2.6.0 means workflow version 2.6.0

.

Version for Fusion Middleware Component

Identity Management component Version/Release Number

A. Oracle Single Sign On
Connect to database which holds SSO repository
SQL>select version from orasso.wwc_version$;

B. Oracle Internet Directory

There are two component in OID (Software/binaries & Schema/database)

>>> To find software/binary version

$ORACLE_HOME/bin/oidldapd -version
output should look like

oidldapd: Release 10.1.4.0.1 – Production on mon jul 14 14:14:21 2008
Copyright (c) 1982, 2006 Oracle.  All rights reserved.

>>> To find Schema Version/ database use

ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \
-s base “objectclass=*” orcldirectoryversion

and output should be like

version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1

or run following query in database
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

Output should be like OID 10.1.4.0.1

C. Application Server

1. Oracle Application Server 10g Rel 3 (10.1.3.X)
cat $ORACLE_HOME/config/ias.properties | grep Version

Version=10.1.3.0.0

2. For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
SQL> select * from ias_versions;
or
SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;

.

D. AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

.

E. Oracle Portal
SQL> select version from portal.wwc_version$;

.

Database Component

I) Oracle Database

To find database version
SQL> select * from v$version;
or
All component version in database

$ORACLE_HOME/OPatch/opatch lsinventory -detail

.

Oracle Enterprise Manager
Metalink Note 605398.1 
How to to find the version of the main EM components

.

Unix Operating System

Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release

 .

Related

http://teachmeoracle.com/version03.html

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

17 comments
nitmal_gm says August 18, 2008

Atul,

Very helpful information.

Thanks.
Nirmal.

Reply
Naji Ghanim says October 13, 2008

Hi ,

Thank you very much for your blog
it is very useful.

If you add steps for how to change a file version. (ex: wipclutb.pls)

Regards,
Naji

Reply
lala_bcs says January 28, 2009

i ever think how to find the version of the apps server
so through blog it is possible for me thanks
very useful blog …………………

regards
sohail

Reply
AJS says June 4, 2009

very helpful–THANKS!

Reply
chandra.matta says June 9, 2009

What an article.!! It has got complete information to find out versions.

Reply
karan says July 29, 2009

hii friends,i want some information about Oracle 11i like actually what is oracle 11i,which kinds of features its have and which kind of Data access tools,backup,recovery,transaction processing,Audit and Distributed Data Management provided by this Data base.Please post ur blog..itz really very urgent i”ll be very thankful to you for this.

Reply
Abhijeet says December 17, 2009

Hi,
rwrun gives only report builder version in 12i . how to find the form server version in 12i?

rwrun |grep Release
REP-0503: You did not specify the name of a report.
Report Builder: Release 10.1.2.3.0 – Production on Thu Dec 17 01:07:36 2009
[applmgr cidcscoretst1 HUP12] $

Thanks,

Reply
saq.arf says January 4, 2010

Hi Atul,

I have got this question commonly from many interviewers.
Can you please answer this
Q. why do we not get any output when we run “opmnctl status” from $INST_TOP/ora/10.1.3/opmn/bin although we get output on running $ADMIN_SCRIPTS_HOME/adopmnctl.sh?

Thanks
Saquib

Reply
kiran says April 11, 2010

Could you please tell some notes about Flexcube software for beginner?

Thank you.

Good day.

Reply
daniel says September 15, 2010

atul

you are the best..
thank you for the notes 😉

Reply
» How to find Webgate 10g/11g Version and Patches Applied Online Apps DBA: One Stop Shop for Apps DBA’s says March 13, 2012

[…] To find out how to find version of WebLogic click here , and for EBS version click here […]

Reply
madhudbaMadhu says May 28, 2012

Hi Atul,

1.How to find the Package version in apps
2.how to find the object status in apps
3.how to find the custom_top appiled or not?

Thanks

Madhu

Reply
savo says June 21, 2012

Hi,

thanks for the valuable tips!

Regards,
Savo

Reply
pamsy78 says July 27, 2012

Hi Atul,

I need to know a script or command to find the versions of

1. BI Publisher (server and/or client side)
2. Jdeveloper (server and/or client side)
3. ADI – Web ADI

All this infor is ONLY needed for a EBSO instance?

Need this urgently

Reply
Mashood says September 25, 2014

Nice and Helpfull information.

Reply
Add Your Reply

Not found