http://appsdbasworld.blogspot.com

appsdbasworld

 
APPS R12
  • R12.AD.A.DELTA.4 Patch
  • Disable concurrent manager
  • Increasing the number oacore process type(JVM) and...
  • Release12 installation
  • InitSID.ora settings for release12
  • Creating custom top in release12
  • Changing apps password
  • Apps questions
  • Workflow Notification Mailer Setup
  • Schedule downtime in R12
  • Enable/Disable restrict session of Apache
  • APPS 11i
  • Indian localization patch
  • Opening forms from linux machine
  • Replacing Jinitiator with JRE for Oracle Apps 11i
  • Enabling SSL for E-Business suite 11i
  • Executing gather schema statistics at backend
  • Cleaning temporary tablespace
  • How to check versions
  • How to find patchset level
  • Cleaning concurrent manager tables
  • Database General
  • Create A Production (Full or Partial) Duplicate On...
  • Creating a Duplicate Database on a New Host Using ...
  • Database Cloning
  • 11g top new features
  • New background processes in 10g
  • 10g Data Pump
  • Installing Oracle Database 9i (9.2.0.8) on RHEL 4
  • Query to kill inactive sessions
  • Installing 11g(11.1.0) database on Redhat Linux 4
  • Check Deprecated Initialization Parameters in 11g
  • Online backup 9i & 10g
  • Enable/Disable archivelog in 9i
  • Creating recovery catalog in remote database
  • Creating database with create database command
  • Application Server
  • web cache cloning
  • 10g AS installation with linux
  • Operating System
  • Script to start/stop R12 services
  • Basic commands to check system statistics
  • Statspack analyzer
  • Analyze your statspack report
  • Search
    Only search this Blog
    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Others Coming Soon!
    Your Ad Here
    How to check versions
    Tuesday, June 17, 2008
    How to find Version of Apps 11i

    Run following SQL from apps user ;
    SQL> select RELEASE_NAME from fnd_product_groups;

    Discoverer Version installed with Apps ?
    Go to $ORACLE_HOME/discwb4/bin and execute
    strings dis4ws | grep -i 'discoverer version'
    You should see output like
    Discoverer Version:Session 4.1.47.09.00
    Which means you are on discoverer 4i version 4.1.47.09

    How to find if your database is 32 bit or 64 bit(Useful in
    applying Patches) ?

    execute "file $ORACLE_HOME/bin/oracle"


    How to find Workflow Version embedded in Apps 11i ?
    Run following SQL from apps user ;
    SQL>select TEXT from WF_RESOURCES where NAME='WF_VERSION';

    You can also use script wfver.sql in FND_TOP/sql to find version
    of workflow in Apps.


    How to find java version
    cd /usr/jdk/bin
    Then,
    ./java -version


    How to find OUI version ?
    ./runInstaller -help
    OUI location is $ORACLE_HOME/oui/bin


    How to find Opatch version?
    "$ORACLE_HOME/OPatch/opatch version"


    How to find Database version ?
    SQL> select * from v$version;


    How to find Version of any file in Oracle Apps 11i ?
    adident Header

    How to find Oracle Applications Web Server Version ?
    Go to below directory,
    cd $IAS_ORACLE_HOME/Apache/Apache/bin
    and execute
    ./httpd -version


    How to find Jinitiator Version ?
    Check file like appsweb_SID_HOSTNAME.cfg under $OA_HTML/bin
    defined by environment variable FORMS60_WEB_CONFIG_FILE & search
    for try like jinit_ver_name , you can see the version like below

    jinit_ver_name=Version=1,3,1,23
    posted by Senthil Kumaran @ 3:58 AM  
    0 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Senthil Kumaran
    Home: Oslo, Oslo, Norway
    About Me: I'm working as a oracle applications dba(Apps DBA OCP) and fusion middleware.This views are my own only and not neccessary to match with others
    See my complete profile Add to Technorati Favorites
    Previous Post
    Archives
    Links
    Powered by

    BLOGGER

    Add On

    Add to Google

    Add to My AOL

    Subscribe in Bloglines

    Subscribe in NewsGator Online

    © Oracle AppsDBAs World Blogspot Template by SENTHIL KUMARAN SL