Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Saturday, April 4, 2009
    Find Apps Version (11i/R12/12i)
    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
    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

    Labels:

    posted by Srinivasan .R @ 1:38 PM  
    1 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Oracle10g:Grid Control Installing
  • Oracle10g Data Guard
  • Oracle Application Installation Guide10g Release3
  • Enable HTTP/OC4J/OPMN debug logging
  • Oracle10g: Data Pump
  • Oracle10g RAC Installation
  • Identifying High Active Sessions
  • FNDCPASS utility
  • Identifying Long Idle Sessions
  • Apps Components and Architecture
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal