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
    Oracle Dataguard in Apps 11i E-Business Suite as Disaster Recovery
    Thursday, November 30, 2006
    Register for R12 upgrade
    Lets continue from last two post on Dataguard which are at

    Today lets conclude dataguard/standby configuration & look at Metalink note on Dataguard configuration in Apps 11i with database 9i & 10g.

    After creating standby control file and moving datafiles, redo log, control file,tnsnames.ora to standby site , start standby database as mentioned below using standby control file.

    SQL> startup mount

    In order to put standby database in managed recovery you can use


    To Cancel recovery you can use

    All these sql's are available in Standby Configuration guide so your can refer guide mentioned in my first post on standby database.

    Failover is used if you loose your primary database or wish to break relationship between primary & standby database & convert standby database in to primary database.
    Switchover is used to change role of primary to standby & vice versa.

    For configuring Dataguard as Disaster Recovery solution in Oracle Applications 11i use Metalink Note # 216212.1 Business Continuity for Oracle Applications Release 11i, Database Releases 9i and 10g

    Next level of Business Continuity is Application Server Guard (Currently for Standalone Application Server only) which includes middle tier recovery including database. AS Guard (Application Server Guard) also called as DSA is used for seamless Integration of Disaster Recovery solution for both Middle Tier & Database Tier. I am going to cover how to configure AS Guard in future.

    Stay tuned to learn how to configure Single Sign On (SSO) access to HTMLDB / Apex Applications ......

    Labels: ,

    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 @ 10:09 PM   1 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Configure Oracle Dataguard
    Tuesday, November 28, 2006
    Register for R12 upgrade
    Yesterday we looked at Data Guard overview in Oracle Database , Today I am going to cover step by step configuration for Oracle Dataguard & may be in next or future posts I will discuss on common mistakes which you can do while configure dataguard / standby database.

    Below steps are based on assumptions that Primary Database is on & Standby database is on . Database Instance Name is PROD and database listener is listening on port 1525. Mount point on primary & standby database are same (If they are not you need to set parameter db_file_convert)

    I am assuming using LGWR, ASYNC option with log shipping service which means ,
    LGWR (Log Writer process will be used to write to standby site instead of ARC archiver process)
    ASYNC (Redo logs to standby is asynchronous to primary site)

    You may have to change options with log shipping service (LOG_ARCHIVE_DEST_n) depending on data protection mode you wish to choose. (I am using Maximum Performance Mode - Default Mode)

    Enable Archive log
    For standby database configuration your primary database should be running in achieve log mode. In order to convert your primary database into archive log mode follow these steps


    SQL> alter system set LOG_ARCHIVE_DEST_1 ='LOCATION=/u01/oracle/data/arch' scope=spfile; (I am assuming that you are using spfile here , if you are using pfile skip scope=spfile)

    SQL> alter system set LOG_ARCHIVE_DEST_2 =' LGWR ASYNC REOPEN=60' scope=spfile; (We will create above TNS Alias in next step)
    SQL> alter system log_archive_dest_2='DEFER' (Defer this until you have standby system Up)

    SQL> shutdown immediate
    SQL> startup

    You should see archive logs generated after this on standby site

    Enable Force Logging
    You should enable Force logging in primary database else if some transaction which doesn't generate redo log can corrupt your standby database. (Careful in OLTP transactions or long running requests in Apps)

    Set Initialization Parameter
    SQL> alter system set fal_client = ’’ scope=both;
    SQL> alter system set fal_server = ’PROD_remote1.domainname’ scope=both;
    (Here FAL, Fetch Archive Log is used to fetch archives in case gap in archives arises because of any reason)

    SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO scope=both; (This is used to automatically generate file in standby site like if you add a datafile, this will create one in standby site as well)

    Create Standby Control file & copy datafile including oracle_home
    Create standby control file as
    SQL> alter DATABASE CREATE STANDBY CONTROLFILE AS '/u01/oracle/home/standby.ctl'

    You can installed New Database on standby site or Use ORACLE_HOME software from primary site on standby site.
    Copy datafiles, redologs, initializations file, tnsnames.ora, listener.ora & control file from primary site to standby site.

    Other steps & few important things w.r.t. dataguard coming in Next Post...

    Labels: ,

    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:18 PM   11 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Dataguard for Business Continuity
    Sunday, November 26, 2006
    Register for R12 upgrade

    Today I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware (Using AS Guard). There are two types of standby databases Physical Standby Database & Logical Standby database. Since oracle applications currently support only physical standby database , I am going to cover only physical standby databases.

    Overview of Dataguard & Dataguard Broker
    Dataguard consist of one primary database & one or more standby database where primary & standby databases are connected by sqlnet (How to configure this check in coming posts). These primary & standby database can be monitored by command line (sql) as well from GUI (Graphical User Interface) Tool called as Dataguard broker.

    Important Services in Dataguard configuration
    Two very important services in dataguard configuration are Redo Transport Service & Log Apply Services. In order to keep standby database in synch with primary database ; redo transport service transfer(Pull/Push) redo logs from primary to standby database & Log apply service applies that redo logs to standby database.

    Switchover & Failover
    These are basically two kind of roles in dataguard Failover & Switchover; In Switchover Primary database becomes standby database & one of (If there are more than one standby) standby database becomes primary database for ex. during server maintenance. Failover is used in scenarion in which your primary database is not available and you want to convert role of one of standby database to primary database for ex. during primary database failure.

    Data Protection Mode
    Standby database in dataguard configuration can be configured in any of three protection mode which can be changed later as well depending on your requirement . These protection modes are Maximum Protection Mode , Maximum Availability Mode & Maximum Performance Mode.

    Maximum Protection Mode
    In maximum protection mode as name suggest no data loss will occur if primary database fails. This is achieved by oracle by ensuring that redo data must be written to both local online redo log location & standby redo log location before transaction commits. This standby redo log will ensure full data protection. For full protection mode atleast one standby database should have standby redo log and LGWR, SYNC, and AFFIRM attribute should be used with LOG_ARCHIVE_DEST_n parameter. (I am going to discuss about these parameters in next post)
    Here your primary database will shutdown if it is unable to write redo records to atleast one standby location.

    Maximum Availability Mode
    This is similar to Maximum protection mode except that it will not shutdown primary database if primary database is not able to write standby redo logs to atleast one standby location but in that case Maximum Availability will act in Maximum Performance Mode until fault is corrected and all gaps in redo logs are resolved. Once all gaps are resolved primary database will automatically goes into Maximum Availability Mode.

    Maximum Performance Mode
    This is default mode in which redo stream is written asynchronously with respect to the commitment of the transactions that create the redo data. You can use LGWR and ASYNC attribute or ARCH attribute in LOG_ARCHIVE_DEST_n

    You can check your database mode as

    SQL> select PROTECTION_LEVEL from v$database;

    How to change protection modes..
    How many standby database Instance you can configure ...
    explanation on Log apply, log transport service , FAL Server/Client ....
    Step by step configuration of standby database using dataguard ..

    Coming soon...


    Labels: ,

    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 @ 3:35 PM   18 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Admin for Apps DBA Forum @
    Saturday, November 25, 2006
    Register for R12 upgrade
    I would like to take this opportunity to introduce Manmohan Batra (Oracle Apps DBA) as new Administrator of Apps forum at dedicated to Apps DBA's.
    He is an expert in the setup, configuration, implementation of Oracle Applications 11i with Oracle 9i/10g databases on Red Hat ES/AS Linux in multi-node environment in Non-RAC and RAC architecture using Load Balancing with Big IP Hardware Load Balancer and Parallel Concurrent Processing.
    He will share his knowledge/experience with us. You can raise your issues, doubts, questions related to Oracle Apps at forum He also implemented Oracle 10g Portal (including OID & SSO) with Oracle E-business Suite for various clients , so if you are planning to integrate 10g AS with E-Business Suite 11i, check for issues & best practice via Forum (

    He carry 10+ years of rich implementation experience on Database from 7.3.4 till 10g R2 including RMAN for backup and OEM Grid for performance tuning & monitoring.

    I would like to thank Manmohan for sharing his knowledge & spending time in answering queries.

    If you wish to help other budding/newbie apps dba's , feel free to answer others queries.

    Related -


    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:35 AM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    How to change hostname or domainname for Apps Instance Server
    Wednesday, November 22, 2006
    Register for R12 upgrade
    You sometime have to change hostname or domainname of your Apps Instance , today's post list various options & things you need to note while changing hostname on your existing Apps Instance.

    Use cloning for changing hostname or domainname
    I am sure you might be surprised to see how cloning can change hostname or domainname , yes you are right cloning will not change host or domain name but cloning can be used to change pointers to old hostname or domainname in Apps Instance after changing hostname/domainname by operating system commands. Steps you have to do is

    Run adpreclone on Instance where you want to change hostname/domainname
    Release Unix/Linux machine to sysadmin for changing hostname
    Run postclone with new hostname/domain with same SID to change new name into effect

    Above method is easy & best which I can think .

    Use Autoconfig to change hostname or domainname of machine hosting apps Instance
    If Machine on which you want to change hostname/domainname is on application tier then you just change entries in $CONTEXT_NAME.xml
    Change hostname or domainname using operating system commands
    execute autoconfig on that Instance so that application tier register new hostname/domainname

    If machine on which you want to change host/domain name also host Database Tier then you also need to Deregister database tier from Net Service Topology Model & Reregister it with new hostname settings.
    If you want to learn more about Net Service Topology Model follow Metalink Note # 218089.1 Autoconfig FAQ Under Section Net Services Question 28 to 41

    For exact steps on how to change hostname using Autoconfig follow Metalink Note # 338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig

    I recently completed OCA for Application Server Exam 1Z0-311 and will be sharing my experience with Oracle Certification for Application Server with you all. Stay tuned on Oracle Application Server Certification 1Z0-311 & lot more things.

    Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions

    Labels: ,

    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 @ 10:42 PM   10 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Startup Shutdown Application Server - Bounce Services
    Monday, November 20, 2006
    Register for R12 upgrade
    Last month I discussed about 10g Application Server which is going to replace 9i AS ( in Oracle applications Rel 12 (Next version of Oracle Apps 11i). You can check overview & Installation Document in below links

    Today I am going to continue with 10g Application Server Startup Shutdown Scripts. If you understand 10g AS architecture which consist of
    infrastructure Services (Database & Identity Management)
    Middle tier Services (Portal & Wireless or BI & Forms)
    I am focusing on these two type of Installation & not j2ee & webcache type (which is third middle tier Installation type) in this discussion.

    Startup Sequence
    As in apps you follow order (first start database & then middle tier services in 10g AS also you follow similar sequences) Order of startup Services in 10g AS should be like
    --Start Database Listener
    -- Start Database
    -- Start Infrastructure Services
    -- Start Middle Tier Services

    Shutdown Sequence
    -- Shutdown Middle Tier Services
    -- Shutdown Infrastructure Services
    -- Stop Database
    -- Stop database listener

    What utility I should use to startup / shutdown (Bouncing) for 10g AS ?
    You can use iasconsole (Browser based console listening in default port 1156) to startup shutdown services
    You can also use opmnctl ; command line tool (Oracle Process Management & Notification) control to startup shutdown services

    dcmctl utility to start/stop services is now deprecated & should not be used

    Lets look at scripts once again
    Start listener as - lsnrctl start [listener_name]
    Start Database as - sqlplus "/as sysdba"; SQL> startup
    Start Infrastructure Services as - opmnctl startall (Make sure your are in Infra Home)
    Start Middle Tier Services as - opmnctl startall (Make sure your are in Middle Tier Home)

    Stop Middle Tier Services as - opmnctl stopall (Make sure your are in Middle Tier Home)
    Stop Infrastructure Services as - opmnctl stopall (Make sure your are in Infra Home)
    Stop Database as - sqlplus "/as sysdba"; SQL> shutdown immediate
    Stop listener as - lsnrctl stop [listener_name]

    How to start/stop iasconsole ?
    As I mentioned above you can start/stop services using iasconsole but before that you have to start / stop iasconsole itself which you can do by emctl (em - enterprise manager)

    emctl start iasconsole
    emctl stop iasconsole

    You can access ias console screen from browser by url
    http://host.domain:em_port/emd (Default em port is 1156)
    http://host.domain:1156/emd (This will prompt username password , use ias_admin)

    How to start individual component ?
    Step mentioned above are to stop/start all components in Middle Tier or Infrastructure Tier , what if I want to start/stop/restart only few components of a Tier ? You will use

    opmnctl [startproc stopproc restartproc] ias-component=[component_name]
    opmnctl [startproc stopproc restartproc] process-type=[process_name]

    Where Component Name like - OC4J, OID, HTTP_Server, WebCache and
    Process Type like - WebCacheAdmin, OC4J_Portal, OC4J_Security

    How to troubleshoot SSO Server ...
    How to change hostname/domainname of Apps 11i Server ...
    ....Coming soon....

    Leave your comments for topics you want to learn/hear/discuss

    Labels: ,

    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:38 PM   15 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle AS Cluster ( Identity Management )-> Active - Active
    Saturday, November 18, 2006
    Register for R12 upgrade
    Identity Management is Infrastructure component of Application server in Fusion Middleware Family.

    Oracle's Identity Management Components include -
    SSO - Oracle Single Sign-On Server
    OID - Oracle Internet Directory
    DAS - Delegated Administrative Services
    DIP - Directory Integration & Provisioning Services
    OCA - Oracle Certifying authority (Optional)

    I am going to cover them in detail in my future posts, These Services & Component are quite important for Apps DBA as IM (Identity Management) is part of Oracle Apps Release 12.

    This post covers overview & important notes w.r.t. to Identity Management Cluster where IM component are in Active Active scenario, which means IM components (OID, SSO, DAS) are available on both nodes for High Availability .

    For IM underlying database can be single Instance database or Two or Multiple Instance RAC (Preferably atleast Two Node)

    Distributed / Non Distributed IM
    Distributed IM means IM components (SSO, DAS, OID) are distributed on more than one machine (SSO & DAS on one machine & OID on second machine).
    Non Distributed IM means all IM components are on same machine.
    You can cluster both Distributed or Non Distributed Identity Management

    Here are few Notes/Checks which I learnt from my various Implementations

    Things you should know before starting Installation
    - Check if you want Distributed or Non-distributed IM Cluster
    - Virtual Name of HTTP Server (Infra for SSO & OIDDAS) and protocol (http or https)
    - Virtual Name of OID including port (SSL & NON-SSL, you need both. Default is 389 & 636 resp)
    - Communication protocol requirement (HTTP or HTTPS) between
    CLIENT -> Load Balancer -> HTTP Server

    things you must do before Installing Oracle AS Identity Management Cluster
    - synchronize system clock on all server (which are part of cluster) with in 250 second
    - set cookie persistence at load balancer specifically for URI /oiddas/ , If your browser doesn't support persistence setting at URI level then set for all HTTP Traffic (Set cookie to expire when browser session expires)
    - Before Installing firt OID Node make sure TCP monitoring is not enabled on Load Balancer on first node
    - Configure load balancer to return immediately to calling clients

    Things/Tips which will be handy for AS Cluster (IM Type)
    - For first OID Node Installation, make sure MR is not registered with any OID else it will fail. Installer checks that & if it finds that MR is already registered it assumes first node & asks for first OID node information to make it part of OID cluster
    - Choose similar component on other node of cluster (i.e. If node first Node you have OID & DAS then on other Cluster node also Install OID & DAS)
    - To access OID on any OID node in cluster , you have to use Password for ias_admin on first installation and not ias_admin password used second , third or further installation of Instance in cluster (oiddas, orasso, oidmon)
    - For IM Cluster you always select IM and not IM+MR (This is during Installation Screen)
    - For IM content database should already be loaded with Metadata Repository using Repca or MRCA (Repository Creation Assistance or Metadata Repository Creation Assistance)
    - Installation steps for first OID Node is different than subsequent Node
    - For IM Cluster , never select IM+MR during Installation screen , always select IM only.
    - You have to select HA (High Availability) during Installation Options.

    More on Indentity Management Cluster Installation..
    Enable Apex Applications for SSO authentication ..
    Coming soon ....

    Now register for E-mail notification via "Email Subsciption" on your right Menu Bar

    Labels: , ,

    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 @ 7:30 PM   15 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Workflow Notification Mailer
    Wednesday, November 15, 2006
    Register for R12 upgrade
    On popular request from my readers, I need to take a break from Oracle Identity Management Updates and need to Update on Oracle Workflow Notification Mailer.

    Oracle Workflow in itself is a Product which is tough to cover in this blog but I am going to cover few important & frequently used components from Oracle Apps DBA point of view which is Workflow Notification Mailer .

    Currently with OWF.H (Oracle Work Flow Minipack H) or 11.5.10 Oracle Applications Uses Java Mailer & before that it used to be C Mailer. Some of you who are on 11.5.8 or lower version might still be using wfmail.cfg under FND_TOP . Configuration is quite simple via OAM (Oracle Application Manager) provided you or your unix team setup inbound & outbound mails set up correctly. Notification Mailer will inturn use Operating System command/mail for inbound(for receiving mail) & outbound(for sending mails). At end of this post you can find few metalink notes which cover all things you require to configure Workflow Notification Mailer.
    In 11.5.10 Java Notification Mailer is available out of the box , you simply need to configure via Oracle Application Manager .
    Below metalink Notes should be enough to configure Workflow Notification Mailer & troubleshooting Mailer ..

    Related Links

    Metalink Note #

    268085.1 Configuring the Oracle Workflow 2.6/11i.OWF.H Java-based Notification Mailer with Oracle Applications 11i

    164871.1 Configuring the Workflow Notification Mailer in Oracle Applications Manager 11i

    172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i

    Labels: ,

    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 @ 10:22 PM   18 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle Single Sign-On Server for Apps DBA
    Register for R12 upgrade
    Today lets discover Single Sign-On (SSO) like why its used , advantages of using it , what all different type of applications can use SSO including technical details of SSO .

    What is Single Sign-On Server (SSO) ?
    As name says Single-Sign On Server is set of services (Software) which enables login to Application once which will allow you to login to Ppartner Applications with no need to login again. Lets assume I have configured single SSO Server for Portal , E-Business Suite, Collaboration Suite plus some other other applications, Now if I login to any one of them & after that if I wish to login to other applications I should be able to login without supplying passwords again.

    How will I log off then ?
    This is called as Single Sign-Off which is part of SSO server , If you logout from any one application SSO server will log off from all applications.

    What are Technology Stack components of SSO Server ?
    SSO consist of OC4J_Security & HTTP Server which are part of Oracle Identity Management which inturn part of Oracle Infrastructure Server which in turn part of Oracle Application Server. SSO server uses Oracle Internet Directory to store User Credentials in encrypted format for Partner Applications . If some one ask you to bounce SSO server , you bounce either of them or both . Oracle components uses mod_osso which is part of Oracle HTTP Server to connect to SSO server.

    Partner Application & External Applications ?
    As mentioned above lot of time about Partner Applications ; Partner Applications are the one which delegates their authentication to SSO server (like Portal, Discoverer, E-Business Suite, Collaboration Suite) where as External Applications are applications which don't delegate their authentication to SSO Server (like yahoo, google, hotmail applications).
    What does delegating Authentication means here ? Delegating authentication means partner application will ask sso to verify if a user is authenticated properly or not where as external application will check username/password at their end sso server will simply hold username/password in OID (If users select remember external application password)

    Request Flow when SSO is used ...
    Very important to understand request flow when a application is configured with SSO & user tries to access Application .
    1) User first time tries to access application (like portal, collabsuite, apps 11i) configured with sso server
    2) Application checks that there is no login cookie set into User(Clients) browser so Application redirects it to Single Sign-On Server via mod_osso
    3) Single Sign-On Server returns login page to user & user enter his/her username/password
    4) SSO validates these password against one stored in Oracle Internet Directory
    5) If password matches then SSO return a token to client with list of all applications which user has access and return client back to original application
    6) This token is stored as part of cookie in user's/client's browser & further connections from client to applications will be allowed (as authentication token is already in cookie)

    Do you know how to access Single Sign-On server from browser or what is SSO URL ?
    Lot more on OID & Identity Management including IM Cluster coming soon ...

    Labels: , ,

    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:34 AM   45 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    IPv4 & IPv6 Oracle Application Server
    Saturday, November 11, 2006
    Register for R12 upgrade
    Today I am going to cover totally different topic which may not be related to Apps DBA's or DBA but if you are configuring Application Server (10g Rel 3 , 10g Release 2 or Oracle Applications 11i) then this post may be useful to you.
    It is quite important for Apps DBA as Installing & maintaining Web Server (Oracle Application Server) is part of Oracle Apps DBA JOb. Lets discover basics of IPv4 , IPv6 requirement of second one & how it is related to Application Server.

    What is IPv4 or IPv6 ?
    IP stands for Internet Protocol & v for Version , so they are Internet Protocol version 4 & 6 resp. As per Wikipedia IPv4 was the only major network protocol used for Internet till IPv6 came.

    Those who are from networking background can understand that out of 7 layers in OSI (I read this in my engineering course & now I understood what it means ;-) ) IP is at layer 3 i.e. Network level (You as DBA can ignore this if you don't understand)

    IPv4 addresses are 32 bit wide & since there are so many public IP's (each public site is using one or more IP address like and now its time to extend these available IP addresses which is delivered via IPv6 for which addresses are 128 bit wide .
    Moving to IPv6 means more IP addresses (More host/sites/machines or Internet) plus some additional benefits.

    Why IPv4 or 6 important to Apps DBA's ?
    This is most critical paragraph for Apps DBA that why should I (as an Apps DBA) be interested in Networking or Internet protocol version , It because IPv6 support is available in Apache Version 2 & higher & Oracle HTTP Server (Application Server 10g Rel 1, rel 2, rel 3) are on Apache 1.3.X which still doesn't support IPv6.
    If you are trying to Install 10g Appliaction Server Rel1/Rel2 or Apps 11i , check if local host is in IPv6 address list like (::1 localhost ipv6-localhost ipv6-loopback) then remove it like (::1 ipv6-localhost ipv6-loopback)

    Related Links

    Steven Chan's Post on IPv6 and the E-Business Suite

    Labels: ,

    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:41 PM   0 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Install Apex (Application Express) Formerly HTMLDB
    Friday, November 10, 2006
    Register for R12 upgrade
    Some time ago I read a post about HTMLDB at Vidya Bala's Blog She has mentioned nice description about HTMLDB & Installing HTMLDB 2.0. You can check her post at Install HTMLDB 2.0

    Now HTMLDB is called as Application Express or more commonly as Apex. Latest Apex Version is 2.2 and today I'll quickly cover Installation of Apex Version 2.2. You can find Installation Document and software at end of this post.

    In order to install Apex (Former HTMLDB) ver 2.2 you should have
    --Application Server Version or higher
    --Database should be version or higher
    --Disk Space around 500 MB on middle tier (Application Server)
    --Tablespace (in which you will install Apex ) with around 100MB free space
    --System tablespace with around 85 MB free space
    --Database shared pool size should be 100MB or more

    At time of Apex installation it asks for tablespace for user data & tablespace for Apex files. You can use existing single tablespace for both or can create these two tablespace. For better understanding I will create two tablespace one for User data & other for Apex files.

    Below Apex 2.2 Installation steps are of Database version 10.2.X and application server version (There might be minor changes on other database or application server version)

    Pre Installation Configuration
    Login to database and create two tablespace

    create tablespace tsapexf datafile '/$datafile_location/tsapexf01.dbf' size 50M autoextend on next 10M maxsize 300M;

    create tablespace tsapexu datafile '/$datafile_location/tsapexu01.dbf' size 50M autoextend on next 10M maxsize 300M;
    These tablespaces we are going to use during Apex Installation

    Loading Apex into Database

    Login to middle tier(Application Server) & download Apex 2.2 software from location mentioned at end of this post (software is with name;
    Copy it to location where you want to install Apex on Middle tier ; assume its /u01/dev
    unzip software as ; unzip
    This will craete a subdirectory with name apex ; cd apex
    sqlplus system@tns_alias as sysdba (From middle tier connect to database as sysdba)
    @apexins.sql {passwd} {ts for user} {ts for files} {ts for temp} /i/ {connect_info}

    passwd - Password for Apex Super User
    ts for user - Tablespace for User data (Created above)
    ts for files - Tablespace for Apex files (Created above)
    ts for temp - temporary tablespace (Usually Temp)
    i - is the alias for image directory configuration in Application Server (Apache httpd.conf)
    connect info - TNS Alias to connect to database from middle Tier

    @apexins.sql mypasswd tsapexu tsapexf temp /i/ tns_alias

    This step will take 1-2 hours depending on server configuration

    Configure Apex at Middle Tier
    (Application Server)
    Create a file marvel.conf in $ORACLE_HOME/Apache/modplsql/conf

    Replace ORACLE_HOME, hostname, port number, service_name, and apex_public_user_password with values appropriate for your environment.


    Alias /i/ "/u01/dev/apex/images/"

    AddType text/xml xbl
    AddType text/x-component htc

    Order deny,allow
    PlsqlDocumentPath docs
    AllowOverride None
    PlsqlDocumentProcedure wwv_flow_file_manager.process_download
    PlsqlDatabaseConnectString hostname.domainname:db_port:SID ServiceNameFormat
    PlsqlAuthenticationMode Basic
    SetHandler pls_handler
    PlsqlDocumentTablename wwv_flow_file_objects$
    PlsqlDatabaseUsername APEX_PUBLIC_USER
    PlsqlDefaultPage apex
    PlsqlDatabasePassword password
    Allow from all


    include marvel.conf in httpd.conf like below so that it can be invoked each time Apache(Web Server) Starts

    include "/replace_this_with_oracle_home/Apache/modplsql/conf/marvel.conf"

    Update this configuration change in DCM repository (This step is required only on 10g Application Server, Skip this if you are configuring it with Apps 11i or standalone HTTP Server)

    Make sure Alias /i/ "/u01/dev/apex/images/" this alias in marvel.conf is pointing to right apex images directory

    Post Installation Steps
    dcmctl updateconfig -ct ohs
    opmnctl restartproc ias-component=HTTP_Server (Restart HTTP Server to check it)

    Now try access application via URL

    Software & Related Document
    You can find Apex Software Version 2.2 at

    How to configure Apex or HTMLDB applications with SSO Server coming soon ....

    Become Apps DBA


    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 @ 5:08 PM   39 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Discoverer 10g & Oracle 11i Configuration Steps
    Wednesday, November 08, 2006
    Register for R12 upgrade
    If you are reading this post directly then visit my previous posts on discoverer basics & overview with Apps at

    Lets start today with broad level Steps to Install & configure 10g Discoverer with Apps 11i , in end you can see metalink note & other references.
    Please Note that Steps mentioned here are specifically from version

    1.Install 10g Oracle Application Server Release 2 i.e.
    2.Copy DBC file from $FND_SECURE(E-Business Suite Tier) to $ORACLE_HOME/discoverer/secure(Discoverer Home Installed in Step1)
    3. Update tnsnames.ora in DISCO ORACLE_HOME installed in Step1 to point to E-Business Suite 11i Database
    4. Migrate your EUL (End User Layer) from 4i to 10g EUL (Please Note upgrade from EUL3i to direct 10g is not supported , you have to first upgrade eul to4i & then to 10g)
    5. Select JVM for Disco Plus (you can Oracle's Jinitiator or Sun Java Plug-in)
    6. Apply Necessary Apps Patch for compatibility Issues (For list of patches check Metalink Note mentioned below)
    7. Change Profile options to point to 10g Discoverer from 4i

    All these Steps above are compulsory steps , I have not mentioned Optional Steps like Single Sign On Server configuration and generating Business Layers. Also steps mentioned here are configurations related to Apps DBA's perspective for functional steps refer to document mentioned below.

    Related Links

    Metalink Note # 313418.1 Using Discoverer 10.1.2 with Oracle E-Business Suite 11i

    1og Application Server Installation Overview

    10g Discoverer Installation Guide

    discoverer Documentation

    Stay Tuned to Understand Application Server Concepts like Oracle Internet Directory, Oracle Single Sign-On Server, OPMN & lot more . For 10g Application Server overview check in Left Menu Bar under section "10g Application Server"

    Now you can get email notification with Update on this blog , check "E-mail Subscription" on right Menu Bar.

    Labels: ,

    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:14 PM   32 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Overview on How to Configure Discoverer 10g with Oracle Apps
    Monday, November 06, 2006
    Register for R12 upgrade
    By now you might already be aware of that Discoverer 4i (which is shipped with Oracle Apps 11i) is desupported so Should we start looking for New discoverer Version and answers is YES we should.

    Today I am going to cover overview fo 10g Discoverer & few important thing you should know before configuring 10g Discoverer with Oracle Applications 11i.

    What all Discoverer Versions available with Apps ?
    You can configure Discoverer 10g Release 1 i.e. version 9.0.4 (Yes version 9.0.4 is also called as Discoverer 10g Rel 1) or latest certified is Discoverer 10g Release 2 i.e. Version 10.1.2. I suggest you go for Discoverer version 10.1.2 .

    Can I upgrade Discoverer 4i to 10g ?
    No Upgrade of 4i to 10g is not supported (Please check what I mean by not supported in next line) , only option is to install new discoverer 10g software & Upgrade 4i EUL to 10g EUL (EUL Upgrade is supported) If you want to know what is EUL or basics of Discoverer click

    Can I Install Discoverer 10g in Existing ORACLE_HOME with Oracle Apps ?
    No , Oracle Discoverer with 1og should be in its own oracle_home, It can't share home with any other oracle_home like 8.0.6 or iAS .
    Though it can be on same machine where your Apps Middle tier or Can be on separate Machine.

    Limitation for Discoverer 9.0.4 & 10.1.2
    Configuring Discoverer 9.0.4 or 10.1.2 is currently certified only with Apps 11.5.8 to 11.5.10

    More on How to configure 10g Discoverer with Apps
    Installation Document ...
    Location to download Discoverer Software ...
    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 @ 9:11 PM   5 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Discoverer in Oracle Applications
    Sunday, November 05, 2006
    Register for R12 upgrade
    One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of putting some bits and pieces for you on Discoverer and later on How to Integrate Discoverer 10g with Oracle Apps 11i. So lets start this discussion about overview & things you should know about Discoverer as Apps DBA.

    Whats is Discoverer Server ?
    Discoverer is and ad hoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)

    What should I know about Discoverer as an Apps DBA ?
    Though each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.

    What is EUL ?
    You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.

    Technical things about discoverer in Apps ..
    --In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4
    --Script to start discoverer server is under $OAD_TOP/admin/scripts/$CONTEXT_NAME
    -- This script in turn start discoverer processes which can be start by under $ORACLE_HOME/discwb4/util (This script is different from
    -- calls scripts like, ,, to start gatekeeper, locator, oad & osagent resp.
    -- In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)

    Quiz to reader :
    A. How will you find discoverer version in Apps ?
    B. What URL you use to access Disco viewer & Disco plus .

    Post your answers via comments

    Stay tuned to check
    How to install 10g Discoverer & configure with Oracle Applications 11i
    Coming Soon .....

    *************Important Note*************
    Now you can subscribe Email Notification For New Post on this Site
    --Check on right Menu Bar of Page under E-mail Subscription enter your email ID
    --click on "subscribe".
    --It will open new window to verify (If pop up blocker is enabled , allow for this session)
    --You have to type text message displayed on pop up window
    --"click on complete subscription".
    Final step is to Verify in your mail box that you only asked for Subscription.
    Go to your inbox , you should see a mail with Subject "Activate your Email Subscription to:.. "Open that mail &
    click on link in mail
    If you don't see this mail in your inbox then check your Junk eMail Folder
    Click on this link
    Relax & you will get notification in your mail box as soon I post new Topic here .

    Labels: , ,

    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 @ 2:00 AM   40 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle recruiting Apps DBA's for On Demand Team - India
    Thursday, November 02, 2006
    Register for R12 upgrade
    I noticed on Net that Oracle is recruiting Oracle Apps DBA's for On Demand Team & I updated this information in Forum Dedicated to Apps DBA's .

    You can check details of positions & contact person to submit your CV as Apps DBA

    There are four levels depending on your Expertise
    - Software Engineer
    - Senior Software Engineer
    - Principal Software Engineer
    - Manager

    You have to submit CV with subject line as ‘your current location – OA DBA Resume’ (e.g : Mumbai – OA DBA Resume)

    I was part of Oracle on Demand Team earlier so I know its great Team to work with & thats why I dedicated my one post for this Opening. To check more on Oracle on Demand click at

    So what are you waiting for ?? Shoot your CV to ID mentioned in

    If you wish to check some Interview QuestiSubmittedtted by other readers check at

    Become Apps DBA

    Labels: ,

    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 @ 3:06 PM   1 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Check Oracle Open World Presentation
    Wednesday, November 01, 2006
    Register for R12 upgrade
    I was waiting for OOW Presentations & today I read in Steven Chan's blog that they are now available to download , Check here to find link to download these presentations . Username & Password is mentioned in post.

    Few of them which I found interesting are

    --Technology Directions for Oracle Applications
    --Oracle E-Business Suite Customers: 10 Things You Can Do Now to Prepare for Oracle Fusion Applications
    --Oracle E-Business Suite Technology Updates
    --MAA Best Practices: Building an Oracle E-Business Suite Maximum Availability Architecture
    --Deep Dive: Oracle E-Business Suite Release 12 New Technology Stack
    --Tuning Oracle E-Business Suite
    --Customer Case Study (Rafael): Oracle 10g Identity Management with Oracle E-Business Suite
    --Oracle E-Business Suite System Management: Release 12 New Features
    --Oracle E-Business Suite Applications Database Optimization Panel
    --Oracle E-Business Suite Release 12: Installation and Cloning Enhancements
    --Security Administration in Oracle E-Buisness Suite: Overview of Oracle User Management
    --Oracle Workflow: Oracle E-Business Suite Release 12 Updates
    --Oracle E-Business Suite Patch Management: A Dive into OAM/AD Features
    --Partitioning and Purging Best Practices for Oracle E-Business Suite

    I'll discuss these in detail in my coming posts .

    Become Apps DBA


    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:14 PM   0 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