Thursday, March 24, 2016

How To Check The Versions In Oracle Application

How To Check The Versions In Oracle Application 

The most simplest way to figure out your application version is by navigating to Help-> About Oracle Applications from any of the forms sessions.


Version of a Oracle Applications Form (fmx) or report

To find the version of any oracle applications files:

strings -a ICQTYED.fmx | grep Header

alternatively you can also use the adident command


Version of a Java class File

To find the version of a java class file:

$ strings | grep '$Header'


JDBC version

In your middle tier, edit the jserv.properties file located in the iAS_ ORACLE_HOME/Apache/Jserv/etc directory - Locate the wrapper.classpath that is pointing to the jdbc zip file /u01/applsam/samcomn/java/jdbc14.zip


How to find the Apache version?

Go to the $iAS/Apache/Apache/bin directory and enter the following command:

$ httpd -version


Version Of The OA Framework

To find out the version of your Oracle appplication Framework:

http://[host].[domain]:[portnumber]/OA_HTML/OAInfo.jsp

OA Framework Version Information

OA Framework Version 11.5.10.2CU.

MDS Version 9.0.5.4.81 (build 481)

UIX Version 2.2.18

BC4J Version 9.0.3.13.51


Oracle Application Product Version or Patch Set Level.

One of the most common things you will asked by your support engineer is the version or commonly known as the patch set level of your Oracle Applications product, while or after raising your service request. You can query this by logging on to your application database as the apss user:

select patch_level from fnd_product_installations where patch_level like '%AD%';


OJSP Version

Log in to the application server as the applmgr user

cd $OA_HTML

edit the jtflogin.jsp file to add the following line

OJSP Version: <%= application.getAttribute("oracle.jsp.versionNumber") %>

clear your cache and bounce your apache server

soruce the jtflogin.jsp from your browser

http://hcslnx03.satyam.com:8002/OA_HTML/jtflogin.jsp

OJSP Version: 1.1.3.5.2


XML Parser Version

You can find out the version of your XML Parser using the following query

SQL> select WF_EVENT_XML.XMLVersion() XML_VERSION 2 from sys.dual;

XML_VERSION
-------------
Oracle XDK Java 9.0.4.0.0 Production


XML Publisher Version

To check weather XML publisher is installed or not you can query the FND_PRODUCT_INSTALLATIONS table or you

can lookup the

reports in Oracle Applications Manager. You can find out the version for your XML publisher from the output of

your report or from MetaInfo.class file.

$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class.


WorkFlow Version

You can find out the version of your workflow using the following query:

SQL> select text version from wf_resources where type='WFTKN' and name='WF_VERSION';

VERSION
--------
2.6.0

Oracle Database Components Oracle RDBMS Version

You can query the version of your database user the dynamic view V$VERSION

SQL> SELECT * FROM V$VERSION;

Version of OPATCH

$ perl $ORACLE_HOME/OPatch/opatch.pl version

/oracle/product/v9.2.0.6_doeb10s/OPatch/opatch.pl version: 1.0.0.0.51


Listener Version

$ lsnrctl version LSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 06-JUL-2007 09:34:53

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=samsolx)(PORT=1527))

TNSLSNR for Solaris: Version 9.2.0.6.0 - Production

TNS for Solaris: Version 9.2.0.6.0 - Production

Unix Domain Socket IPC NT Protocol Adaptor for Solaris: Version 9.2.0.6.0 - Production

Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.6.0 - Production

TCP/IP NT Protocol Adapter for Solaris: Version 9.2.0.6.0 - Production

The command completed successfully


Operating Systems and Utilities

Sun Solaris Version

To check the version of you Solaris you can use the following file.

$ cat /etc/release

Solaris 8 2/02 Fujitsu_3 s28s_u7fjsv3wos_04 SPARC

Copyright 2002 Sun Microsystems, Inc. All Rights Reserved.

Assembled 08 December 2002

RedHat Linux Version

You can check the version and release of Linux from the following file

view /etc/redhat-release

Red Hat Enterprise Linux AS release 4 (Nahant Update 2)

Perl Version

You can use the perl -v or the perl - version command to find out the version of perl on your environment.

$ perl -version

This is perl, version 5.005_03 built for sun4-solaris
Copyright 1987-1999, Larry Wall

Java Version

To fine the version of Java used

$ java -version

java version "1.4.2_04"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05)

Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode)


Version of Installed packages on Solaris

To find the version of the packages on Solaris

$ pkginfo -i|grep perl

application MCperl584 PERL 5.8.4 with Modules 64bit with Threads

optional VRTSperl Perl 5.8.6 for VERITAS


Version of Installed packages on Linux

To find the version of the packages on linux

rpm -qa|grep


Kernel Version of Unix

You can find the version of your kernel on UNIX by the following command

uname -a

Bit of Operating System

You can check the bit size of your OS by using the following command

$ isainfo -b

64

Bit of your Oracle Software

To check if your Oracle Binary is 32 bit or 64 bit you can use the file command on any of the oracle

executables like

$ file $ORACLE_HOME/bin/oracle

/oracle/product/v9.2.0.6_doeb10s/bin/oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

Identity Management component Version/Release Number

Oracle Single Sign On
select version from orasso.wwc_version$;

Oracle Internet Directory
There are two component in OID (Software/binaries & Schema/database)
To find software/binary version
$ORACLE_HOME/bin/oidldapd -version

To find Schema Version/ database use
ldapsearch -h -p -D “cn=orcladmin” -w “” -b “” \ -s base “objectclass=*” orcldirectoryversion
select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

Application Server

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

For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
select * from ias_versions;
or
select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;
AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

Oracle Portal

select version from portal.wwc_version$;

Database Component

To find database version
select * from v$version;
or
All component version in database
$ORACLE_HOME/OPatch/opatch lsinventory -detail
Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release

No comments:

Post a Comment