How to Find component Version in Oracle Apps 11i/R12:

Find component Version in Apps 11i/R12:

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 <filename>
or
strings <file_name> | 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/<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 $’);

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

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

.

DATABASE ARCHITECTURE

DATABASE ARCHITECTURE :
===============================================

Differnces between 9i,10g,11g databases

Differnces between 9i,10g,11g:

===================

        9i: The improvement in Oracle 9i aims at improved optimization of     conventional business applications:

        1: System fault recovery

          2: Disaster recovery

          3: online changes in schema

          4: Flashback Query

          10g: There are several hundred feature differences between the 9i     and 10g versions:

   1: Oracle Enterprise Manager (OEM) in 10g completely redesigned

    2: The imp utility on the Data Pump has been replaced with impdp

    3: Automatic Database Diagnostic Monitor (ADDM)

    4: introduced Automatic Storage Management (ASM)

    5: Scheduling package dbms_job is replaced by    the dbms_scheduler package

    6: Introduction of backup compression by RMAN

     11g: The design of  11g implemented this through creation of automated storage, automated memory management and creation of intelligent         tuning advisors.

    1: Automatic memory tuning

    2: Automated load balancing in storage

    3: Automated Diagnostic Repository

    4: Load balancing utilities

    5: File group repository

R12.2.2 Patching Steps

R12.2.2 Patching Steps:
==================

In Oracle Apps R12.2 what will happen when we run adop phase=prepare ??

1. Checks that the environment is set to the run APPL_TOP.

2. Checks whether to perform a cleanup, which will be needed if the user failed to invoke cleanup after the cutover phase of a previous online patching cycle.

3. Checks to see if the database is prepared for online patching:

Checks that the FILE_EDITION environment variable value is set to ‘run
Checks to see if enough space is available in the database (SYSTEM tablespace should have minimum of 25 GB of
free space and APPS_TS_SEED tablespace should have minimum of 5 GB of free space)
4. Checks the file system, using the TXK script $AD_TOP/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl.
This script checks for the file system space, database connections, Apps/System/Weblogic Passwords,
Contextfile Validation and so on

5. Produces a report showing information about the most important tablespaces is generated.
This report is created in $APPL_TOP/admin/$TWO_TASK/out.

6. Checks for the existence of the “Online Patching In Progress” (ADZDPATCH) concurrent program.
This program prevents certain predefined concurrent programs from being started, and as such needs to be active
 while a patching cycle is in progress.

7. Invokes the TXK script $AD_TOP/patch/115/bin/txkADOPPreparePhaseSynchronize.pl to synchronize the patches which have been applied to the run appltop.

8. Checks the database for the existence of a patch edition, and creates one if it does not find one

A patch edition is created in the database.
All code objects in the patch edition begin as pointers to code objects in the run edition.
Code objects in the patch edition begin as lightweight “stub objects” that point to the actual object definitions,
which are inherited from earlier editions. Stub objects consume minimal space, so the database
patch edition is initially very small in size.
As patches are applied to the patch edition, code objects are actualized (have a new definition created) in that edition.
9. Calls the $AD_TOP/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl script again to confirm that the
database connection to the patch edition is working.

 R12.2 Cloning for E-Business Suite :

==============================================

R12.2 follows new process of Cloning on Application Tier, it requires selective Components’ backup and Clone from Source FS1 to Target FS1, Target FS1 (RUN fs) to Target FS2 (PATCH fs)
We will cover Single node Apps Tier Cloning in this thread, DB Tier cloning is same as 11i/R12.1

Gather before starting R12.2 Full Cloning process
• Make sure you have enough space available at Source for Backup and Restore/recovery/cloning at Target
• Decide on naming convention like ORACLE_SID, Target System Base directory , Target System Instance Home Directory, Display Value, Port pools, UTL_FILE_DIR
• We will require Apps User password and Weblogic AdminServer password while running adcfgclone.plappsTier
• Maintain snapshot information
Log in to each Application Tier node as the APPLMGR user, and
run "Update current view snapshot" in AD Administration.
• OS Version and requirement should match between Source and Target
• Apply latest AD, Autoconfig and latest Rapid clone patches

High level Steps to perform R12.2 Full cloning

• Run adpreclone.pl on db tier
• Take backup of Database Tier using RMAN or conventional  process including RDBMS_TOP
• Restore/recover DB Tier using adcfgclone.pl dbTier
• Run adpreclone.pl on db tier and apps tier (RUN_BASE) using respective users
echo $FILE_EDITION  This should have output  “run”
As of Release 12.2, the adpreclone.pl process on the Application Tier creates a complete compressed archive of the Oracle Fusion Middleware and its components as follows:
o A compressed archive of the Oracle WebLogic Server home, Oracle Web Tier Utilities home, Oracle Common Utilities home and the Oracle E-Business Suite home:
<COMMON_TOP>/clone/FMW/FMW_Home.jar
o A compressed archive of the Oracle E-Business Suite Weblogic domain:
<COMMON_TOP>/clone/FMW/WLS/EBSdomain.jar
o The Oracle E-Business Suite Weblogic domain's configuration template:
<COMMON_TOP>/clone/FMW/WLS/plan/moveplan.xml
o A compressed archive of the Oracle Web Tier/Oracle HTTP Server configuration instance:
<COMMON_TOP>/clone/FMW/OHS/ohsarchive.jar
o The Oracle HTTP Server configuration instance's configuration template:
<COMMON_TOP>/clone/FMW/OHS/moveplan.xml
• For FULL Cloning we require backup of
o <APPL_TOP>
o <COMMON_TOP>
o <OracleAS Tools 10.1.2 ORACLE_HOME>

• Restore backup taken above at target

• Run adcfgclone.pl on apps Tier as show below
cd /u01/app/appdi/DR122I/fs1/EBSapps/comn/clone/bin
./adcfgclone.pl appsTier
Do you want to add a node (yes/no) [no] :
Target System File Edition type [run] :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [<ServerName>] :
Target System Database SID : DR122I
Target System Database Server Node [<ServerName>] :
Target System Database Domain Name [<DomainName>] :
Target System Base Directory : /u01/app/appdi/DR122I
Target System Instance Home Directory [/u01/app/appdi/DR122I] : /u01/app/appdi/DR122I
Target System Instance Top set to /u01/app/appdi/DR122I/fs1/inst/apps/DR122I_<ServerName>
Do you want to preserve the Display [<ServerName>:0.0] (y/n)  : n
Target System Display [nsmltcstrg02:0.0] : nsmltcstrg02:2.0
Target System Root Service [enabled] :
Target System Web Administration [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [enabled] :
Target System Port Pool [0-99] : 12
Choose a value which will be set as APPLPTMP value on the target node [1] :
….
…
..
  -    100% completed      

Completed Apply...
….
…
..
Do you want to startup the Application Services for DR122I? (y/n) [n] : y
….
…
..
All enabled services for this node are started.

adstrtal.sh: Exiting with status 0
• Now we need to Clone RUN FS to PATCH FS
• Source Environment variable file at newly cloned RUN File System
• Run adpreclone.pl on RUN File system
• Copy Run File system to patch file system under FS2 (Assuming FS2 as Patch file system)
• Run adcfgclone.pl appsTier on Patch File System
cd <COMMON_TOP>/clone/bin

adcfgclone.pl appsTier
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Target System File Edition type [run] : patch
Target System Port Pool [0-99] : 13
Choose a value which will be set as APPLPTMP value on the target node [1] :
….
…
..
   |    100% completed      

Completed Apply...
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is BACKUP-FMW-HOME

Updating incomplete CLONE record to COMPLETED
• Create soft link at $HOME for users to source FS1 or FS2 Environment
• This concludes Full Standard Cloning process for E-Business Suite Release 12.2

NOTE:
If you are trying to reclone or ORACLE_HOME already registered in Inventory - you may need ot unregister ORACLE HOMEs before Cloning  you can execute the following command to unregister or detach that Oracle Home:
$ ./runInstaller -detachhome
ORACLE_HOME=<Oracle Home Location>
For Example:
$ cd $FMW_HOME/oracle_common/oui/bin
$ ./runInstaller –detachhome
ORACLE_HOME=<Oracle Home Location>
In addition to the un registration process, ensure to delete the FMW_HOME directory structure.

OR

For de-registering <FMW_HOME>/Oracle_EBS-app1:
<FMW_HOME>/Oracle_EBS-app1/oui/bin/detachHome.sh -jreLoc
<FMW_HOME>/Oracle_EBS-app1/jdk
For re-registering <FMW_HOME>/Oracle_EBS-app1:
<FMW_HOME>/Oracle_EBS-app1/oui/bin/attachHome.sh -jreLoc
<FMW_HOME>/Oracle_EBS-app1/jdk