Short Dress For Which Lag Shape

Learn tips Versions of Software you use


Of Versions and Figuring Them Out


One of the things that you come across quite frequently when you work with oracle support is to need to tell them the product versions or the platform versions which run your oracle applications.
since it is possible for Oracle to simulate your environment completely or not aat all in most cases its vital that you feed them with as accurate information about your environment as possible.

The current post focuses on getting the version information which are commonly asked by during a service request.

I am categorizing this post into three sections


Oracle Applications Components
Oracle Database Components
Operating System and Utilities


Oracle Applications Components


Oracle Applications version.

You may never need this but in case you are looking at a new environment then the 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 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: WorkFlow Version You can find out the version of your workflow using the following query SQL> select TEXT Version from WF_RESOURCES 2 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; BANNER ----------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

PL/SQL Release 9.2.0.6.0 - Production CORE 9.2.0.6.0 Production TNS for Solaris: Version 9.2.0.6.0 - Production

NLSRTL Version 9.2.0.6.0 - Production

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 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