Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Apps Component Version in 11i and R12

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Apps Component Version in 11i and R12

    To find database version
    SQL> 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

    How to find Apps Version (11i/R12/12i) >>
    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

    Web Server/Apache or Application Server in Apps 11i/R12 >>
    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

    Forms & Report version (aka developer 6i) in 11i >>
    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)

    Forms & Report version in R12/12i >>
    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

    Oracle Jinitiator in 11i/R12/12i >>
    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 )

    Oracle Java Plug-in in 11i/R12/12i >>

    Log in as Application user, set environment variable and run below query
    grep plugin $CONTEXT_FILE


    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

    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 $’);

    OA Framework Version >> http:// hostname.domainNameort/OA_HTML/OAInfo.jsp (Only for 11i); 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

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

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

    Workflow Version with Apps >>
    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

    Oracle Single Sign On >>
    Connect to database which holds SSO repository
    SQL>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
    output should look like

    oidldapd: Release 10.1.4.0.1 - Production on thu sep 11 11:08:12 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

    Application Server >>
    Oracle Application Server (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;

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

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

+ Reply to Thread

Similar Threads

  1. Error during installation of Oracle for release / OS Version not certified
    By sandeep.negi27 in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 5
    Last Post: 06-26-2012, 10:15 PM
  2. Applying the last version of the Oracle AD.I
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-03-2011, 04:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics