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
$ORACLE_HOME/bin/frmcmp_batch|grep
Forms| grep Version R12
output like
Forms 6.0 (Forms
Runtime) Version 6.0.8.25.2 (Production)
Forms 10.1 (Form
Compiler) Version 10.1.2.3.0 (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
or
strings
| 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/.pll
IGSAU012.pll:
$Header IGSAU012.pld
115.1.115100.1 2004/04/01 05:40:18 appldev ship $
or
strings
$AU_TOP/resource/.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
-p -D “cn=orcladmin” -w “” -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
No comments:
Post a Comment