Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Auditing in Oracle Applications
    Tuesday, February 27, 2007
    Register for R12 upgrade
    Most of data in oracle Applications is quite important but some tables are very critical & sensitive . From security reason or Audit compliances you as an Apps DBA should know

    - Who changed sensitive tables ?
    - At what time data was changed ?
    - What was value before & after change ?

    If you wish to track this information in Oracle Applications, I am sure most of you will say this can achieved by enabling Audit Trail in Oracle Applications but you need to take care of following things w.r.t. Audit Trail in Apps

    - Make sure you plan purging policy for Audit/Shadow tables which will be created during Audit trail
    - Consider for performance overheads if Audit Trails is enabled on too many applications tables
    - Better to disable Audit Trails during major Upgrades (Shadow tables may change during version upgrade so its better to archive before upgrade )

    Steps to enable Auditing
    Define Audit Installation (Security -> AuditTrail -> Install)
    Define Audit Group (Security -> AuditTrail -> Groups)
    Run Audit Trail Update Tables Report to Enable Auditing (Submit Concurrent Screen)

    Few key points for Auditing
    --Auditing in Apps can be done on Row by Row basis or Individual Column of a table
    --If you change any of your definitions for auditing, you must rerun Audit Trail Update Tables
    --"AuditTrail Update Tables" report creates shadow table with first 26 characters of table & appended by _A

    Metalink Notes related to Auditing

    105630.1 Setup & Usage
    60828.1 Overview of Oracle Applications AuditTrails
    69660.1 Understanding Data Auditing in Oracle Application Tables
    105624.1 Troubleshooting

    Related blog
    If you wish to know about users accessing Apps, you can refer nicely written post by Fadi on his Post About "Connected users in Apps" .


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 9:44 PM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Collboration Suite
    Monday, February 26, 2007
    Register for R12 upgrade
    With today's post I'll cover another Fusion Middleware product which I am using for quite some time now i.e. Oracle Collaboration Suite .

    Major components in Oracle Collaboration Suite are
    -Real Time Collaboration
    -Content Server
    -Mail Server
    -Threaded discussion

    Few reason why an Enterprise should prefer Oracle Collaboration Suite against other Collaboration Tool in market:

    1. Easy to Use Content Management tool with Version Control & fine grained access policy at various levels for regulatory Compliance
    2. Secure way of communicating instantly with individuals or groups in and across enterprise using text, voice or conferencing features of OCS for problem solving, mitigate risk and deliver crisp and instantaneous communication to users across globe
    3. Single Integrated view of oracle mail, meeting invitation, voicemail, fax and threaded discussion from single integrated box
    4. OCS establishes process controls across all content with a centralized repository to cost-effectively audit, retain, archive, and manage content for compliance—and to react with agility when new regulatory pressures appear.
    5. Adaptability of business processes with Service Oriented Architecture
    6. Highly secure Oracle Messenger solution built on XMPP standard & archived interactions (chat / web conference) into database

    Questions you should ask before Implementation:
    - How many user are going to access OCS ( Smaller, Medium, Large , Very large )
    - What all component of OCS customer is planning to use from following (Mail, Mobile, RTC, Content, Calendar, Search, Discussion)
    - Customer want to access internally (Intranet) or externally as well (Internet) over SSL or Non SSL
    - Availability / Failover Strategy (What is acceptable downtime during planned & unplanned outages) , Does customer want to implement Failover site & any backup strategy they are already following
    - Scalability - Plan for growth - How much growth customer is expecting in Usages in future
    - Any specific Security requirement at Enterprise level
    - How many Instances (Development / Test / UAT/ Production) customer is interested

    Installation/Upgrade/disaster recovery/High Availability/Troubleshooting/SSL implementation for Oracle Collaboration Suite coming soon ..


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 11:12 PM   2 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Independent Oracle Applications DBA Consultant
    Sunday, February 25, 2007
    Register for R12 upgrade
    I was thinking of this for quite some time & I have finally decided to work as an Independent Oracle consultant. I am Oracle Applications DBA (E-Business Suite/ Financials/ HRMS, Fusion Middleware /Application Server /Collaboration Suite /Application Express) certified on Oracle Applications and have been awarded with prestigious Oracle ACE designation. A former Oracle Employee, I have proven track record in big implementations with Advanced configuration including HA Clusters & DR, Installation, Upgrades, Migration & Support.

    I accept work related to Oracle Applications varying from 1 day to few months (daily/hourly rate) or entire project (Mail/Phone Me for Quotations) . For more information contact me via Mail or Phone at +44 (0) 7701 030035

    Broad Category of Work related to Oracle Apps DBA
    -- New Implementations / Installations
    -- Migrations & Upgrades
    -- Onsite / Remote Applications Support
    including patching, cloning, maintenance
    -- Heath Checks/Performance Tuning
    -- Oracle Trainings
    on Database, E-Business Suite, Fusion Middleware, Application Server, Collaboration Suite

    This is an overview of some of my skills & work which I have done recently.

    Oracle Applications/E-Business Suite (Financials / HRMS - AP, AR, GL, FA, INV, Grants, CRM, Web ADI, iProcurement, iRecruitment, Workflow, XML, Student System )

    - Upgrade Oracle Apps 11.5.9 to and database upgrade to 10g R2
    - Implementing & configuring self service middle tier with SSL in DMZ setup , Multiple domain URL's for Internal & External Apps Users
    - Installing Oracle Applications Instance 11.5.7-10 & R12 version
    - Installing & configuring Discoverer 10g with Apps 11i
    - Configuring middle tier cluster with shared APPL_TOP for High Availability
    - Configuring RAC database with Apps with Parallel Concurrent Processing
    - Implementing Disaster Recovery solution for apps using Data-Guard & Maximum Availability Architecture
    - Patching , Cloning, Performance Tuning various Apps components including database
    - Backup & Recovery using RMAN
    - Monitoring Oracle Applications database including Forms, Web, Reports, CM, Jserv via OEM-OAM plug-in with email & mobile alerts
    - Configuring 10g Application Server with Apps 11i
    - Configuring & Supporting Apps with two Node RAC and multiple middle tier for High Availability

    Oracle Application Server 9i/10g or Fusion Middleware (HTTP Server, OC4J, Portal, Webcache, OID, SSO, AS Guard)

    - Install Fusion Middleware products (AS, BPA, BI, SOA, IM) with Single Node / Multi Node
    - Seamless Disaster Recovery solution for 10g Application Server including Middle Tier using AS Guard (Application Server Guard) & Data Guard
    - Upgrading Portal for 9.0.4 to 10.1.4 on multi-node installation
    - Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory
    - Configuring Virtual Host & SSL implementation on Single Sign-On Server including Server Hardening for Security
    - Configuring Multiple Node Middle Tier cluster for High Availability with Virtual Host Implementation
    - Configuring Webcache clusters & tuning webcache for better response
    - Implementing Fusion Middleware in High Availability Model with two Node RAC database, two Node OID cluster & multiple middle tier cluster
    - Migrating OID users & groups across various OID Instances
    - Monitoring & system usages of Portal web site using freeware web access monitoring tool like AWSTAT
    - Patching & cloning of Fusion Middleware products

    Oracle Collaboration Suite (Real Time Collaboration, Content, Workspace)

    - Installation of Oracle Collaboration Suite 10g with Multi Node architecture
    - Upgrading OCS to & databases to 10g R2
    - Implementing SSL for Single Sign-On Server for secure authentication
    - Oracle Drive & MS Web folder configuration
    - Integrating collaboration Suite OID for automatic user & group synchronization with Portal OID
    - Backup & Recovery implementation using RMAN tools
    - Disaster Recovery implementation with Failover & Switchover configuration during planned & un-planned outages

    Applications Express / HTMLDB

    Contact me via Mail or call me at +44 (0) 7701 030035

    For any Issues/Doubts in Apps use Forum at


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 6:32 PM   19 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Prepare for Oracle Apps R12 Installation
    Tuesday, February 20, 2007
    Register for R12 upgrade
    In today's post I will discuss on steps you should do/need for Oracle Apps R12 installation. Most of these steps are written w.r.t. to Installation on Linux but I'll try to mention any additional software required for Windows or any other platform.

    Where to download Apps R12 Software ?
    First thing you need is Oracle Apps R12 which is available at eDelivery (Click here to go to eDelivery) or you can order software DVD's via Metalink. You don't need to download all CD's .

    You might have to register initially with Name, Company & email address & try again after 1-2 days (You might not get confirmation, just try after a day)
    Select product as E-Business Suite & your platform , For Linux you have to select Part Number B35903-01 (There are total 72 CD's {you don't need all 72 CD's} with total size as 35GB {this is just software size & not actual installation})

    In actual you have to download following 64 CD's rest others are for NLS, 10g AS & BI CD's

    Oracle Applications Release 12.0 Rapid Install Start Here - Disk 1 (5 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install RDBMS - Disk 1 (3 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 1 (6 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 2 (7 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 3 (7 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 4 (8 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 5 (7 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 6 (2 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 7 (7 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 8 (2 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install Tools - Disk 1 (3 CD's)
    Oracle Applications Release 12.0 for Linux x86 Rapid Install APPL_TOP - Disk 1 (6 CD's) Oracle Applications Release 12.0 for Linux x86 Rapid Install APPL_TOP - Disk 2 (1 CD)

    Oracle Apps R12 Installation Document
    Next thing you need is Oracle Apps R12 Installation Guide which is available at

    What should I do if I don't have Linux Operating system as well ?
    If you don't have Linux O.S. you can install it on any other operating system (CD's mentioned above are for linux download according to your O.S. ). If you are curious to install it on Linux you can download linux from

    Do I need to Install any other software before Oracle Apps R12 Installation ?
    On Unix/Linux you don't need to install any other software (You should have all required o.s. packages as mentioned in above installation guide) but as you don't need to install JDK prior to Apps R12 install (with 11i you have to install JDK prior to installing Apps)
    For windows you still need other software like mks toolkit (cygwin my recommendation for test server), VC++

    User & Mount point/File system
    I will recommend two user install (one for database tier & another for middle tier also called as application tier) Though you can install both database tier & application tier under same operating system user. For Vision Instance you need around 161 GB (133GB for database & 28 GB for application tier) space . For instance without dummy data you need 73 GB space (45GB DB & 28GB application tier)

    CPU & RAM
    For testing Installation you can try as low as single CPU (1.6 GHz) and 1GB RAM (This was spec of my laptop where I installed for testing purpose, You can try with low configuration as well)

    Staging Area

    Its good idea to create staging area using script available in Start Here CD. Refer to Page 30 of above Installation Guide. Advantage with staging area is that after start CD you don't have to manually insert CD's and Installer will automatically pick next CD from staging Area. You can pass on configuration setting on first 3-4 screens & once installer starts you can sleep & next day morning you can see complete installation. In case of any failure or subsequent installations (If you have to install more than one Instance its always better to install using Staging Area)

    For new Installation features and Step by Step Oracle Apps R12 Installation on Linux VMware on your laptop stay tuned with this blog .

    You can now register for subscription to this blog via eMail using right menu bar under E-Mail Subscription.


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 11:44 PM   45 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Fusion Middleware Part II
    Sunday, February 18, 2007
    Register for R12 upgrade
    Lets continue from last post "Overview of Fusion Middleware"

    Business Intelligence
    This product covers most of business Intelligence needs in today's world like ad hoc query analysis, reporting & publishing, dashboards and real time analysis.

    Collaboration Suite
    This product provides tools to collaborate seamlessly from any application or device in an enterprise. Key component of Collaboration Suite are Real Time Collaboration, Content Services (iFS in past), Workspaces, eMails, Discussions, Calendar . More on this coming soon...

    Data Hub
    It is central location for your entire enterprise data from all sources to get 360 degree view of enterprise data. You can update & clean you data in data hub and then use application to view this data.

    Data Integrator
    As name suggest this product integrate vast amount of data across heterogeneous systems. This is based on ELT (Extract Load & Transform) architecture and provide Hot-Pluggable (Drop & Deploy) knowledge modules.

    EDA Suite (Event Driven Architecture)
    Product to create, process, analyze and manage with as less possible custom coding . component of EDA suite are BAM (Business Activity Monitoring), Business Rules, Enterprise messaging, ESB (Enterprise Service Bus), Sensor Edge Server. You will know more about these components in comping topics on Service Oriented Architecture (SOA) Suite.

    Identity Management
    OID and Oracle SSO integrated with various other Identity management components like Web Access Control, Federated Identity & user provisioning.

    SOA Suite
    Product for building , managing & developing SOA's . Various components of SOA suite are BPEL, Web Service Manager, BAM (Business Activity Manager)

    If this post is quite heavy for you , I am going to cover "preparing Oracle Apps R12 Installation on Linux" . I'll cover on location to download software with Disk labels & staging Oracle Apps R12 software and new features available with Oracle Apps R12 installation.


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 12:27 PM   9 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Fusion Middleware Overview
    Friday, February 16, 2007
    Register for R12 upgrade
    Lets briefly discuss about Oracle Fusion Middleware and one liner on its various components to give you a feel of Oracle Fusion Middleware.

    What is Fusion Middleware ?
    Oracle Fusion Middleware is a family of oracle product's which will help in application development and integration solution to Identity Management, Collaboration Suite & Business Intelligence reports.
    Various products of Fusion Middleware Family are

    Application Server
    BPA Suite (Business Process Analysis)
    Business Integration
    Business Intelligence
    Collaboration Suite (Content, RTC, Mail Server, Discussion, Calendar)
    Data Hub
    Data Integrator Developer Tools
    EDA Suite (Event Driven Architecture Suite)
    Identity Management
    SDP Suite (Service Delivery Platform)
    SOA Suite (Service Oriented Architecture)
    Web center Suite

    For most of us grasping/understanding all of them at once is difficult so I 'll be discussing one liner about all these components and later I'll cover them in detail based on each components importance & use in real world.

    Application Server
    This is core component in Oracle Fusion Middleware. Various component of Application Server are Webcache, j2ee, wireless & portal and uses Infrastructure Services like Single Sign-On and Oracle Internet Directory.

    Business Process Analysis (BPA)
    This helps in modelling business process and converting them to IT executable. Various components of BPA suite helps business user to design, model, simulate and optimize business process. This helps in reducing gap between strategy and actual execution of that strategy. Various components of BPA are Architect, Repository, Simulator & Publisher.

    Business Integration
    Connecting or Integrating processes, Applications or information with business partners using hot pluggable products which are based on Services Oriented Architecture.

    For Next Part Click Here


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 11:34 PM   1 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Is Oracle Fusion really ConFUSION ?
    Wednesday, February 14, 2007
    Register for R12 upgrade
    If you ask question "What is Oracle Fusion ?" to yourself I suppose every one will have different opinion. I would like to hear from you all in your words ( via comments on this post ) about what you think is Oracle Fusion .

    Common confusion over Oracle Fusion
    Most Common confusion over Fusion among most of guys I discuss/meet & also mentioned by Steven Chan in his post is thinking Oracle Fusion Middleware & Oracle Fusion Applications are same. In actual Oracle Fusion Middleware will be used in providing/building Oracle Fusion Applications using Existing Oracle Applications (Oracle E-Business Suite, Siebel, Peoplesoft, JD Eward).

    Oracle Fusion Middleware is collection of Oracle Middleware products i.e.
    --Oracle Application Server (Portal, Wireless, Forms, Reports, discoverer, Webcache, OC4J)
    -- Oracle Identity management (OID, SSO, Web Access Manager, CA, Identity Federation)
    --Oracle SOA Suite (Service Oriented Suite)
    --Oracle Collaboration Suite (RTC, Mail Server, Discussion, Content, Calendar)
    --Oracle DW & BI (BI Beans, OWB, OLAP, Express Server, OSA, OFA, Datamart )
    --Oracle development Tools (Designer, developer, SCM, forms, reports)
    -- Oracle Data hubs

    Oracle Fusion Applications will be collection of Oracle Applications i.e.
    --Oracle E-Business Suite / CRM
    --Oracle Peoplesoft enterprise
    --Oracle Siebel CRM
    --Oracle JD Edward Enterprise

    These fusion applications will use Fusion Middleware mentioned above

    Few links which talk about Oracle Fusion Middleware & Fusion Applications are (Good one for developers & techno functional) (Good one for Oracle Fusion Applications Road Map)

    More on Service Oriented Architecture (SOA Suite) and Oracle Fusion coming soon...

    Leave your comments on what you think is Oracle Fusion ? Is this just another Jargon ?


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 12:45 PM   6 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Upgrade Oracle Applications to 11.5.10 CU 2
    Saturday, February 10, 2007
    Register for R12 upgrade
    This post is coming bit late & I know lot of you might be wondering when Oracle Apps R12 is in market why I am still writing on 11.5.10 Upgrade . Looking at quesries/doubts/document request by many of my readers in mail and in forum at I thought of covering entire 11.5.10 upgrade and its related docs in this post.
    This post will focus on which is oracle apps version 11.5.10 with CU 2 and patch number is 3480000 and related metalink note is 316365.1 . Minimum prereq AD patch for is AD.I.2 (4337683)

    Please Note:
    1. Patch 348000 ( is for 11.5.9 or lower version , If you are already on 11.5.10 and which to apply CU2 then this is not right patch for you.

    2. Steps mentioned here are for upgarding your apps version 11.5.X , This post doesn't cover upgrade procedure from 10.7 or 11.0.3

    3. If you have language other than US then you have to apply translated version of patch as well
    4. To reduce Upgrade downtime you can use staged APPL_TOP methodology mentioned in metalink note # 242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
    5. MRC schema is no more used from 11.5.10 onwards so you can drop MRC schema after upgrade so there is no need to maintain/synchronize MRC before or after 11.5.10 (CU2) upgrade

    6. requires database version 9.2.X and higher so you can upgarde to 9.2.X or 10.1.X before Upgarde . If you wish to upgrade to database 10.2.X then its better you do it after Update.

    7. Since I upgraded Financial & HRMS system so I will focus on steps related to these module but check optional steps mentioned in metalink note # 316365.1 , There are some additional steps for Windows which are not covered in this post

    8. To reduce patch downtime online help patches can be applied at later stage

    A) Pre Update task
    Compulsory Steps
    A.1 As mentioned above apply AD.I.2

    A.2 Update Autoconfig Tech Stack template files - Autoconfig uses Template files to build files specific to your applications

    A.3 Run Technology Validation Utility - This will test minimum tech stack components required to run (Tech Stack components are database, forms & reports, discoverer, Jinitiator, JDK, OJSP, JDBC, libraries for web & form server )

    A.4 Check OATM step mentioned in optional steps below. If you are not migrating to OATM mentioned above then prepare your table space to include new space requirement and new products . Read me of patch 3180164 will help you in creating additional tablespaces.

    Optional Steps
    A.5 Manual Update script - Run this script to find optional & compulsory manual steps you should do before upgarding (This script is specific to an Instance and vary instance to instance)

    A.6 Convert database to OATM (Earlier tablespace were based on OFA/Optimal Flexible Architecture where each product used to have one data & one index tablespaces so there were around 200+ tablespace which was difficult to manage which is now moved to ATM/Application Tablespace Model which is simple to manage & there are around 15 table spaces)

    A.7 This steps is only required if you are using audit trails & shadow tables name > 26 characters. For auditing purpose you may have auiting enabled for Instance which you want to upgrade then you must change shadow table names (I will cover more on auditing in oracle applications in coming post) before any new columns can be added . HRMS & Payroll customers with Auditing enabled focus on this. If you are not sure if any of your shadow table name is > 26 then use script FNDATCTBL.sql provided with patch 3872242

    A.8 If you are using any of product which require ilog planner libraries then apply related patches

    A.9 Unmerge of Contacts from TCA Process is long running process during upgrade process so if you wish to reduce downtime during upgrade
    then run this program before upgrade else it will be executed during upgrade

    Apply Maintenance Pack
    1. Shutdown application tier services

    2. If your database is not 9i upgrade it now

    3. Apply maintenance patch . This is unified driver

    4. Apply any additional languages patches (If your installation is multi language)

    Post Update task
    1. Apply Interoperability patch (If you upgraded database to 10g)

    2. Register new product , If you want to use any product installed as part of you have to manually license it via OAM

    3. Drop MRC schema (As mentioned above MRC schema is no longer required from

    4. If you are not using HRMS Pack I before upgrading to then you have to apply HR legislative updates

    5. There are product specific updates which you should carry out with your
    functional consultant.

    For complete list and extensive steps to upgrade follow metalink note # 316365.1


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:23 PM   20 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    OID to OID/Active Directory/iPlanet other LDAP Server Integration
    Tuesday, February 06, 2007
    Register for R12 upgrade
    In Today's Post I am going to cover overview OID to other LDAP Server Integration. Other LDAP Server can be Oracle's Internet Directory or Sun's iPlanet or Microsoft Active Directory (These are standard directory Servers but you can integrate OID with other third party LDAP servers as well)

    Two way / One way Integration
    You can integrate to synch changes one way only i..e. from Other ldap server OID or both way i.e. OID to other ldap server & vice-versa. (For Two way Integration you should have access to Update other LDAP Server)

    Various OID Server Instances
    Under OID there three services
    - OIDLDAPD Server which is used for normal directory processing
    - OIDREPLD Replication Server (To replicate entire OID to other OID server)
    - ODISRV Directory Integration & Provision Server (This is the server/services used to integrate OID Users/Groups/objects with third party LDAP Servers)

    By default OIDLDAPD & ODISRV Instances are started as you start OID using OPMN but you still need to start one more Instance of ODISRV for Integrating OID with other LDAP Servers

    ODISRV is by default Up why I need additional ODISRV Server ?
    Default ODISRV is used by Provisioning Services i.e. to povision users & groups from OID to Oracle Applications i.e. Portal/Workflow/Discoverer... So for Integrating OID with third party ldap server including OID we need another Instance of ODISRV.

    How to start ODISRV & check related logs ?
    You can start additional ODISRV instance using OIDCTL command

    oidctl connect=[tns_alias] host=[oid_hostname] server=odisrv instance=2 configset=0 start

    to stop it use

    oidctl connect=[tns_alias] host=[oid_hostname] server=odisrv instance=2 stop

    Logs related to above odisrv process will be in $ORACLE_HOME/ldap/log/odisrv0X.log where X is instance name.
    Other log files will be at $ORACLE_HOME/ldap/odi/log/[profile_name].aud & [profile_name].trc

    For Other things on OID to OID or other LDAP server Integration (iPlanet/AD) and significance of audit & trace log files mentioned above including Synchronization Profiles in OID..

    Coming Soon ......


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:25 PM   7 Comments
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar