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 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • 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 11.5.10.2
  • 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
    IdM
  • 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 http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Upgrade Oracle Apps 11i with Database to 10g R2
    Thursday, August 31, 2006
    Register for R12 upgrade
    This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you have not seen previous update on overview of DB upgrade for Apps 11i you can Click Here

    Upgrading a Oracle Apps 11i Database is Upgrading Usual 10g Database + some additional steps which are specific to Oracle Applications 11i. So if you have already done a database Upgrade you simply need to follow metalink note # 362203.1


    Database upgrade is Two Step process: First Upgrade your software i.e. your files under Database $ORACLE_HOME to provide new executables .
    How to upgrade software from 8i, 9i or 10.1 to 10.2 just go to directory where you have downloaded 10.1.2.0.2 database & go to Disk1 & execute ./runInstaller . This will start Universal Installer & then you have to choose different Oracle_Home to install 10.2 software . (Check oracle database upgrade guide at http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007718 ) After software Installation you have to install software for companion CD in above ORACLE_HOME i.e. one for 10.2 only.
    Why I need to Install companion CD separately, I never did it earlier ? Oracle recently started shipping Ultra Search as part of companion CD which earlier used to come with database software only Apply 10.2.0.2 patch 4547817 on top of 10.1.2.0.1 base release. For instructions on How to apply patcheset 10.2.0.2 check ReadMe of patch & you again have to apply it via OUI Upgrade database Metadata Once software is upgraded you have to upgrade Metadata and option you have is via executing sql's mentioned in upgrade guide or dbua ( database upgarde assistance tool ). Oracle Universal Installer while upgrading software also prompt you to upgrade database while upgrade software. Depending on your comfort you can choose method to upgrade database. I prefer using manual method i.e. via upgrade sql files. Now apart from upgrading database there are some pre upgrade & post upgrade steps specific to oracle applications 11i & follow them as mentioned in metalink note # 362203.1 some are option & some are compulsory . I want to discuss Native Compilation in Oracle 10 g database but because of time constraints I will discuss it some other time.


    From now onwards slowly I will move on Advanced Apps DBA tasks like


    Adding extra Node in Applications 11i
    Implementing SSL with Apps 11i webserver
    Disaster Recovery Implementation
    Configuring 10g Application Server with E-Business Suite 11i
    Don't forget to leave comments and if you have any doubts in Apps 11i mail me at atul_iiit@yahoo.com or post here as comment.


    Atul Kumar
    Oracle Apps DBA


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:39 PM   27 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps DBA 11i Interview Questions
    Wednesday, August 30, 2006
    Register for R12 upgrade
    Lot of you have requested for Oracle Applications 11i questions frequently asked during Apps DBA Interview.

    I have listed apps technical questions on my site under http://teachmeoracle.com/interview.html

    There are around 13 pages currently with more than 50+ questions. You can view questions by clicking on Next Page and Previous Page at bottom of page.
    There you might find some good appsdba interview questions with answers and few are without answers which I am going to update soon . These questions are usually asked in apps dba certification as well.

    So for good apps 11i interview questions for apps dba's click http://www.teachmeoracle.com/interview12.html

    Based on feedback from one on you I have listed what pages have been changed on my site at
    http://teachmeoracle.com on right bar under small table with heading
    "Recently Updated" so you can check what's new posting with date .

    If you are not happy with answer or want to submit any question for other apps dba's mail me at atul_iiit@yahoo.com

    Happy Learning
    Atul Kumar
    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:16 PM   1 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    10g Application Server Basics
    Tuesday, August 29, 2006
    Register for R12 upgrade
    Currently with 11.5.8-9-10 or may be previous versions you might be using 9i Application Server Version 1.0.2.2.2 . As you are aware 10g Application Server 10.1.x.x as well is now certified with Oracle Applications 11i , I think its quite important for you to learn 10g Application Server basics as well.

    P.S. For Oracle Applications 11i newbie or new Oracle users 10g Application Server is different from 10g Database.

    10g Application Server is also important because with next Oracle Applications E-Business Suite Release (Which I assume is going to be named as R12 ) is coming with 10g Application Server replacing current 9iAS . (This is for information purpose only)
    10 g Application Server is also important because of Oracle Internet Directory & Oracle Single Sign-On ( OID & SSO ) features. As I have been working on 10g Application Server with its first release as version 9.0.4 I thought of sharing this knowledge with you in my second blog (I'll update it once a week most probably on weekends ) with basics & where to find study material & what you should read w.r.t. 11i & 10g Integration .

    Here is the link http://oracleapplicationserver.blogspot.com/ you can check it from first link under "blogroll" on your left hand side i.e. 10g Application Server

    Happy Learning
    Atul Kumar
    http://oracleapplicationserver.blogspot.com/

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:20 PM   1 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps 11i with Database 10g R2 10.2.0.2
    Monday, August 28, 2006
    Register for R12 upgrade
    Database 10G Release 2 is now certified with Oracle Apps 11i , so today I am writing on overview of Upgrading your 8i, 9i database to 10.2.0.2 . For exact steps follow Metalink Note ID mentioned at bottom of this page.

    Few Things you should note before starting database Upgrade with Apps 11i
    1. Database 10.2.0.2 is currently certified only with 11.5.9 and 11.5.10 ; If you want to know which Apps version you are currently on ; check question "how to determine apps version"
    http://www.teachmeoracle.com/interview10.html
    2. As of date 27Aug2006 only 10.2.0.2 is certified in Database 10g R2 family .
    3. If you are using Portal 3.0.9 with Apps 11i , portal 3.0.9 is not certified with 10gR2 so you have to upgrade Portal to 10g Application Server. (First configure 10G Application Server for Portal)
    4. Base release of 10gR2 is 10.2.0.1 so first you have to Install 10.2.0.1 & then apply patchset 10.2.0.2 which is certified with Apps 11i (11.5.9 & 11.5.10)
    5. Use natively compile PL/SQL code , Though metalink note mention its optional but 11i Initialization parameter says its mandatory parameter (I'll confirm it once I go to init paramateres with 10.2.0.2) and for better performance use Native Compilation.

    Why should I upgrade 11i database to 10.2.0.2 ?
    -New features in 10.2.0.2
    -Bug fixes from 9.2.0.6 or 10.1.x database

    From which database versions direct 10.2.0.x supported ?
    You can upgrade directly to 10.2.0.1 from following database version
    8.1.7.4 , 9.2.0.4 or higher, 10.1.0.2 or higher

    Where can I get 10.2.0.1 software & 10.2.0.2 patchset ?
    --You can download 10.2.0.1 software from http://www.oracle.com/technology/software/products/database/oracle10g/index.html
    You need companion CD as well so download companion CD as well from above location.
    --10.2.0.2 is available as patch 4547817 which you can download from http://metalink.oracle.com or updates.oracle.com


    Related Metalink Notes
    These notes will be helpful during your 10.2.0.2 database Upgrade for Oracle Applications 11i.
    --362203.1 Oracle Applications Release 11i with Oracle 10g Release 2
    --216205.1 Database Initialization Parameters for Oracle Applications 11i

    About tips to reduce downtime & other critical things during 10g R2 database upgrade with 11i, I'll update tomorrow.

    Leave your comments about this or any other post as well about look and feel of site as compared to previous look and feel.

    Atul Kumar
    Oracle Apps 11i DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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 AM   39 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Difference between Rapid clone & Autoconfig
    Friday, August 25, 2006
    Register for R12 upgrade
    There is lot of difference between Autoconfig & Rapid Clone. Earlier dba's used to use Autoconfig to clone Oracle Apps 11i Instance and still in background Rapid Clone executes Autoconfig .

    In order to understand what is rapid clone in oracle apps 11i check my previous post just below this one.

    what's is Autoconfig ?
    Autoconfig is utility to configure Oracle Applications 11i using a file based configuration repository also called as context file or XML file.

    What is this repository / xml file or context file ?
    well there are two context file or repository file one for database & one for applications (Middle Tier, If you are not clear about what is middle tier or database tier visit my Architecture of oracle apps 11i at http://becomeappsdba.blogspot.com/2006/08/apps-architecture.html )
    These two files of format $SID_HOSTNAME.xml ( $APPL_TOP/admin in Application Tier & ORACLE_HOME/appsutil in Database tier) which store configuration Information about entire application.

    To know more about Autoconfig in apps 11i visit http://teachmeoracle.com/autoconfig.html

    So basic difference between Autoconfig & Rapid clone is these are two utilities one for configuring Oracle Applications 11i & second one to clone Apps 11i Instance using first Utility .

    This week its bank holiday so I am busy building my site http://teachmeoracle.com and preparing some material on Autoconfig so If you are interested in Autoconfig do visit http://teachmeoracle.com/autoconfig.html

    Since 10G Application Server is certified & lot of enterprise started using 10g Application Server with Oracle E-Business Suite 11i to use features like Portal, Single Sign-On, Oracle Internet Directory so I am planning to start sharing my knowledge with you all on 10G Application Server & configuration with Apps 11i . I want your feedback to start posting on same blog i.e. http://becomeappsdba.blogspot.com or should I post it under separate URL like http://orclportal.blogspot.com/

    Please leave your comments on this post & based on feedback I'll decide. (You can leave feedback without blogspot ID as well, just select anonymous)

    Atul Kumar
    Oracle Apps DBA

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:49 PM   4 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps 11i Cloning part II
    Thursday, August 24, 2006
    Register for R12 upgrade
    By reading my previous post about cloning you might have understood by now that Cloning Oracle Applications 11i E-Business Suite is method of creating replica of your source Instance.

    Why I need a Clone ?
    Your development team want to develop some custom functionality to Testing team want to test (load test/functional test) before taking some code to live system but they want exact replica of production apps 11i system including data. Answer to them is clone, Wish Oracle could release cloning of 10G Application Server Infrastructure Tier (Those who are supporting 10AS Portal/Discoverer can understand my pain )

    Now lets explore what options/ methods are available for cloning
    Till now (Aug 2006) there are two ways of cloning
    Cloning 11i
    Cloning 11i with Rapid Clone

    Some DBA's asked me about cloning using Autoconfig (Yes earlier we used to do that but that is now automated & called as Cloning using rapid clone so rapid clone internally uses Autoconfig) Hope this answer their query.

    so now question is why two ways of cloning
    Well those who are not lucky enough to upgrade their system and are still on apps version 11.5.5 or lower & not autoconfig enabled have to use , Cloning rest other enjoy luxury of Rapid Clone.

    Those who tried both cloning & rapid clone can explain how easy rapid clone is :-) (I am Lucky that all my Apps Instances are now on 11.5.8 and higher )

    If you want to see how people used to clone earlier or if your system is 11.5.5 or lower & not yet Autoconfig enabled then you need this link
    https://metalink.oracle.com/metalink/plsql/docs/CLONING.PDF

    If your system is 11.5.6 or higher you need Metalink Note # 230672.1 , Cloning Oracle Applications Release 11i with Rapid Clone

    Now you enjoy reading above cloning document & tomorrow I'll discuss difference between Autoconfig & Rapid Clone & other Rapid clone feature .

    Those who have requested for Backup, Workflow in 11i & other topics I am going to post after cloning & patching. If you need information on any other post , leave comment on any blog (I read all comments & definitely reply , so do leave comments )

    Those of you who want to read more on JVM ( Java Virtual Machine ) part of Oracle Applications Web Server 11i check it on my site http://teachmeoracle.com/jvm.html

    Atul Kumar
    Oracle Apps DBA

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:15 PM   54 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps DBA Preparation Cloning 11i
    Wednesday, August 23, 2006
    Register for R12 upgrade
    Now I assume that you are familiar with

    Overview & Architecture of Oracle apps 11i
    Installation procedure of oracle apps 11i
    File System & Various TOPs in Apps 11i
    How to Start Stop various Services in Oracle Apps 11i ( like Apache, CM, Report, Apps Listener, Database, DB listener )

    If not first please go through following topics to familiarize yourself with Oracle Applications 11i

    http://becomeappsdba.blogspot.com/2006/08/apps-11i-dba-preparation.html
    http://becomeappsdba.blogspot.com/2006/08/oracle-apps-dba-preparation-ii.html

    from Today I will take tasks / roles which Apps 11i DBA perform like cloning patching , configuring using Autoconfig. So today lets start with basics of cloning .

    In order to fully Understand cloning basics , I suggest you go through Chapter 6 , Cloning
    at http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf

    Go through page (75 - 78) just four page to understand basics of cloning in Applications 11i . Various topics in that are Cloning Tools, Cloning Options , Rapid Clone Operations. This will give you overview of cloning oracle apps 11i steps . If you have any doubts in over view of cloning apps 11i instance , leave your comments .

    In next post We'll take closer look at Cloning , rapid clone , difference between rapid clone & Autoconfig.

    For those who want to know about JVM in apps 11i , you can check at my site at http://teachmeoracle.com/jvm.html (If you ever encounter JavaLangOutOfMemory error or want to know where are JVM logs or how to increase number of JVM's or JVM related configurations in Oracle Apps 11i then visit http://teachmeoracle.com/jvm.html

    Atul Kumar
    Oracle Apps DBA

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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 @ 1:57 PM   9 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps DBA preparation II
    Tuesday, August 22, 2006
    Register for R12 upgrade
    I hope you have gone through Oracle apps 11i Architecture , installation & File system. If you are reading this post without reading Part I which is at http://becomeappsdba.blogspot.com/2006/08/apps-11i-dba-preparation.html then please first go through it first then only you can appreciate this post.

    By Now You know Apps Architecture , Installation 11i Apps & you had a glance Filesystem of Oracle Apps Vision Instance (If you don't understand all directories in file system don't worry, It took 2 years for me to understand various directories in Apps 11i)

    Next you should try is Start Stop Oracle application 11i Services .
    Order of Startup is
    First Database Services & then Application Tier Services (Middle Tier)
    Order of Shutdown is
    First Application Tier Services & then Database.

    In order to check How to Start Stop Oracle apps 11i Middle Tier services & where are shutdown / startup script exist check http://becomeappsdba.blogspot.com/2006/08/startup-shutdown-apps-services.html

    Database & DB Listener startup / shutdown scripts are under $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME or $ORACLE_HOME/appsutil/scripts/$SID ( depending on your Apps 11i & AD version )

    addbctl.sh is used to control database . Start/Stop database
    addlnctl.sh is used to control database listener ( Note that database listener is different from Apps listener)

    Try starting stopping services or better open startup / shutdown scripts to check what all they are doing (These are shell files & you can open them by any editor like vi in Unix & notepad on windows)

    If you are looking for any formal training , you can check for training from Oracle by visiting site http://education.oracle.com or I have listed some Oracle Apps 11i Training Institute in Bangalore, Chennai (Madras), Hyderabad & Pune at http://teachmeoracle.com/training02.html . If you know any other apps 11i training institute in India or any other country mail me at atul_iiit@yahoo.com

    Atul Kumar
    Oracle Apps 11i DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:49 PM   1 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Apps 11i DBA preparation
    Saturday, August 19, 2006
    Register for R12 upgrade
    As I am getting lots of request for how one should prepare for Oracle Apps 11i DBA in
    Technical domain including Sysadmin, I am summing up things you should learn / study in
    order to understand E-Business Suite 11i . The topics mentioned below, which you should
    read in order to become apps DBA or as part of your Oracle Apps DBA training will include
    roles & responsibilities of oracle Apps DBA.

    1. Apps Architecture
    This is key topic & you should be very clear about Oracle Applications/E-Business Suite
    11i components & Architecture. This is base of your knowledge & if you are not clear about
    various components & uses it will be quite difficult in learning Apps.
    Where to find Oracle Applications 11i architecture in Ocean of oracle Application
    technical documentation. Well I agree with you go straight to http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf and go through chapter 1 (Page 13 to Page 32 Just 20 Pages)

    2. Installing Apps 11i
    Next point in apps dba training is Oracle Apps 11i Install using Rapid Install preferably on Linux/Unix
    Where to find Rapid Install 11i Oracle Apps Guide This is guide by Oracle http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf for a start Chapter 1 & 2 are enough page 13 to p 63 is enough to understand Installation)
    Where to find Discs / software for Oracle Apps 11i E-Business Suite : You can download it via http://edelivery.oracle.com or order it via your Metalink account . Once you got CD , please do install Apps atleast once in order to understand & to familiarize your self with Oracle Applications

    3. Apps 11i File System/Software
    Once you installed applications 11i using above guide on Unix/Windows/Linux software then login as Operating System User & check directories while going through document
    http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf Chapter 2 Applications File System (P39- 48) very important in understanding Database Server & Application Server Tier & various tops like DATA_TOP, ORA_TOP, APPL_TOP, COMN_TOP, AD_TOP....
    If you know your applications 11i File system you know where to find particular component files & logs .

    I think this is enough for keep you going for 10-15 days , pay as much attention you can on these basics as these are building blocks of your careers as Apps DBA. For remaining tips on how & from what to prepare next like AD Utility(patching, adsplice,..), Cloning ... I'll update you tomorrow .

    Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA's)


    Atul Kumar
    http://teachmeoracle.com/interview.html

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:28 PM   40 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Apps technical 11i DBA Interview questions
    Friday, August 18, 2006
    Register for R12 upgrade
    First of all thanks a lot for your feedback & response, If you are facing any problem in Apps 11i , Oracle 10G Application Server ( SSO, OID, Portal) or 10G Collaboration Suite 11i (RTC, Workspace, Content) drop a mail to me at atul_iiit@yahoo.com

    Lot of guys asked me about apps 11i Interview questions for DBA or Sysadmin or technical questions so I am going to discuss on this today & in my coming posts in future . First of all Interview questions depends on your work experience , what you have mentioned in your CV or what is client's requirements (His/Her expertise in role) . Critical is what you have written in your CV & questions automatically comes out of depending on your answers. AS there is no short cuts for success same applies to oracle Apps 11i Interview questions. If you know basics & have good hands on you can easily crack 11i interviewed as apps dab or sysadmin .

    As I always say most important focus goes on basics & things do in your day today life as apps dba or apps 11i ssyadmin. These questions vary from simple to advanced for dba's from 6 months to 5 years of experience . Each day I will discuss one advanced question or 3-4 basic questions . Soon I am going to put all apps 11i Interview questions for dba with answers in my site at http://teachmeoracle.com/interview.html (Please note don't mug up any question answer but Understand logic & concept behind that else Interviewer can easily catch that you have read questions in some site .

    So here is very basic question which most of senior apps dba ask or used to ask from budding oracle apps 11i dba's . I want you to think on this question before trying to find answer about it on my site at http://teachmeoracle.com/interview.html

    Q1. What is wdbsvr.app file ? Where to find it in file system ? Why or what oracle apps component use this file & what's content of this file ? (Usually asked from apps dba with 6 months to 3 years exp.)

    Think for it & wait for my answer in next post or if you can't wait hit my site http://teachmeoracle.com/interview.html

    Please leave your comments about this question .

    Atul Kumar
    atul_iiit@yahoo.com
    Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:33 PM   1 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Clone Apps 11i Instance
    Thursday, August 17, 2006
    Register for R12 upgrade
    Another important & useful utility under AD_TOP which you and me as apps dba perform quite often i.e. Cloning Oracle Application 11i Instance.

    Cloning is process of creating replica of your source apps 11i Instance ( lets say you have one apps Instance with name VISIONTST and you want to create similar instance ( including same patches & user data) like VISIONPRD then you will use adclone utility (Also called as Rapid Clone these days). In this case source Instance will be VISIONTST and target Instance will be VISIONPRD. There are lot for scenario in which you wish to clone your E-Business Suite 11i Instance , like you want to Test if everything is OK in Test & then after testing want to create Production instance or you want to move your Instance from one machine to other machine or if you are highly experienced Apps DAB you can use clone as staged environment during Upgrade to reduce downtime ( this concept is called as staged appl_top or staged patching/upgrade , p.s. this is different from shared APPL_TOP)

    So here I am putting broad level steps you will use to clone apps instance .

    Step1 . Prerequisites Steps you do before start cloning using rapid clone
    1.1 Verify source and target nodes software versions
    1.2 Apply the latest AutoConfig Template patch
    1.3 Apply the latest Rapid Clone patches

    Step2 . Clone Source to Target
    2.1 Run preclone on DB tier
    2.2 Run preclone on Apps or middle tier
    2.3 Copy source file system to target file system
    2.4 Configure db tier
    2.5 Configure apps/middle tier

    Step 3 Finishing Task
    3.1 Update profile options
    3.2 Update printer settings (If printers are not configured or you don't want to use printer you can skip this step)
    3.3 Update workflow configuration settings (Important)

    If you need to know about cloning steps in detail , please leave a comment on this post or drop a mail to me at atul_iiit@yahoo.com . For detailed steps check Metalink Note # 230672.1
    In next post I will talk about Frequently Asked Questions in Apps 11i Interviews about cloning .

    Don't forget to leave comment about what you want to hear & any confusion if you have in apps 11i.

    Happy Learning
    Atul Kumar
    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:45 PM   55 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Applications 11i Health Checks
    Wednesday, August 16, 2006
    Register for R12 upgrade
    Quite often you as apps dba startup and shutdown Apps 11i Services. Sometime you apply patches as well & after patching once you start services & handover apps instance to users . Its quite annoying when users complain that this services is not running or a particular component is down. Sometime reports are not displaying properly or discoverer services are down.

    I have groups together all checks & named it as health check at
    So from now onwards before releasing your test or production Instance you know what all component you have to check & how . Like how to check if observed, Report Server, Concurrent Manager , workflow, discoverer is Up & working fine . This also explain how to check if discoverer viewer or discoverer plus ( what is URl to access same ) .

    Checks which are included in this health check are
    - How to check if apps Web Server is Up
    - How to check if mod_jserv & self service applications are working fine .
    - How & where to check concurrent manager is Up & requests are displayed properly
    - Check form server is Up by logging into core application
    Lot more about Reports, Discoverer, workflow so check all this
    http://www.teachmeoracle.com/healthcheck.html

    If you think I have missed something drop me a mail at atul_iiit@yahoo.com

    Please do leave your comments here about your views on topics here , how relevant are these to you & what you want to hear from me. You comments & feedback are very important to improve this page .

    Happy Learning - Oracle Applications 11i dba.

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:54 PM   0 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Patching Commonly asked questions
    Tuesday, August 15, 2006
    Register for R12 upgrade
    Where can I find patch log files ? ( Check http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics-ii.html)

    What are different type of patches ?
    http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics.html

    How to check if a patch is applied ?
    Check table ad_bugs (bug_number ) or ad_applied_patches table .

    What two tables adpatch creates when you apply or run adpatch session ?
    FND_INSTALL_PROCESSES , AD_DEFERRED_JOBS

    Is uninstalling apps patch applied using adpatch supported ?
    No (Supported version is to restore from backup )

    How to apply a patch when adpatch is running & you come to know that a patch needs to be applied before that patch ?
    Broad level steps are Shutdown workers using adctrl, backup above two tables, backup .rf9 files, Drop these two table mentioned above, apply patch which you were suppose to apply , restore .rf9 files , restore two tables which you backed up earlier & restart patch again .

    Whats defaults file ?
    This is to apply patch non interactively more Coming soon ( i 'll post on this soon )

    Few methods to reduce patch timing ?
    Use defaults file, merge patches & apply as single patch, use high batch size depneding on your system resource, select carefully number of workers while running patching, if upgrade use staged appl_top ( more coming on this in future, please note staged appl_top is different from shared appl_top )

    How to control workers ?
    using adctrl .

    If you encounter any questions related to adpatch and not clear about it, please mail it to me & I will get back to you with in 48 hours . Mail me at atul_iiit@yahoo.com

    To know more about Oracle apps 11i Webserver visit my site http://teachmeoracle.com/apc.html


    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:51 PM   11 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Troubleshooting Apps Patch
    Register for R12 upgrade
    Now as Apps DBA or Sysadmin you know how to apply apps patch in oracle E-Business Suite 11i (If not read my notes below )

    What if you encounter any problem while applying patches ?
    Where to look for any error messages ?
    How to control patch workers and how to restart a failed patch ?

    First place to look for failed patch is log file for patch . Log file for adpatch or apps patch will exist in location which you mentioned by running adpatch . If you have not mentioned any log file location then it will be default go to APPL_TOP/admin/TWO_TASK or SID /log with name adpatch.log ( If you don't know what is APPL_TOP follow link at
    http://becomeappsdba.blogspot.com/2006/08/whats-different-tops-in-application.html

    Once you find out where is error & if you see error message then try to fix problem ( Look for specific message in metalink ) you will get 90% hits for problem .

    While applying d or g driver ( to know what are drivers or driver follow my previous link at
    http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics-ii.html ) adpatch apply these patches via workers and these workers are controlled by utility called as adctrl ( ad control ) . open another session & login as application O.S. user (like applmgr ) and run adctrl , you will see option 1 to see status of worker . Check which worker is showing as failed state and then go to that worker log file in same location i.e. APPL_TOP/admin/TWO_TASK or SID /log you will see log file like a dwork001.log adwork002.log ....adwork021.log so if your worker 12 failed open log file adwork012.log & fix the problem then again in adctrl select option restart failed worked & then give worker number you want to restart .

    If you want to skip a worker , this option is not visible & do it at your own risk there is option 8 ( depending on your AD version , it might vary so if adctrl is displaying 7 options skip worker will be option 8 & if adctrl is showing 6 options skip worker will be option 7)
    You can select individual worker or a group of worker separated by - like 2-5 will select worker from 2 to 5.

    If still you can't fix or you don't find any related error message in metalink raise a Service Request with Oracle .

    From tomorrow I will pick topic on cloning , if you want to know more about patching put your comments or mail me at atul_iiit@yahoo.com.

    If you wish to know about Oracle Apps Web Server , applications 11i Apache also called as OHS then visit my site http://www.teachmeoracle.com/apc.html

    Happy Learning .
    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:32 AM   0 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    How to apply apps patch using adpatch
    Monday, August 14, 2006
    Register for R12 upgrade
    Now you know basics of apps patch like type of patches & options available with patching, lets see how to apply patches in oracle applications 11i .

    Two broad ways to apply patch interactive & noninteractive(You will supply required parameters on commnad line & patch will apply without asking you any questions as you have already provided answers)

    You being new to apps patching will prefer to interactive way f patching , let adpatch throw series of questions & you answer each of these .
    If you want to use any option with adpatch enter adpatch with options= seprated by comma (If you don't supply any options it will take defaukt value set for that particular option like compiledb & compilejsp)
    You have to issue adpatch from application user (User you entered as applications/middle tier user usually applmgr if you insatlled using oracle standard documentation like )

    adpatch options=nocompiledb,nocompilejsp
    Based on you AD verison it will ask you questions like with some suggested value

    '/u01/applmgr/VIS11I/appl'
    Is this the correct APPL_TOP [Yes]
    Log file name & location
    ....

    Once patch is applied you might be interested in checking log files

    If patch fails then you have to use utility adctrl to check for which worker it failed & check corresponding worker log file to see error message.

    For more information on patches & patch basics follow metalink note # 181665.1
    I'll cover adctrl to see error message & how to reduce patch timing using defaults file day after tomorrow.

    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:18 PM   34 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    ADPATH Options
    Saturday, August 12, 2006
    Register for R12 upgrade
    Now since you know basics of patch (If not read my previous posts, its quite important to know patch basics before starting to apply patch )

    By now you might know that you use utility adpatch to apply oracle apps patch and adadmin, admrgpch, adctrl to manage/control your patch . Depending on you AD version (i.e. AD.H or AD.I.1 .. AD.I.4) you will have different options available with adpatch . Otherwise you can use interactive option to apply/see basic options (Interactive means adpatch will ask you required field values by displaying some suggestions to you)

    First lets discover some major options available with adpatch.

    adpatch option=[option1,option2, ....optionN]

    Below is option value with explanation
    options=noautoconfig If you are applying number of patches out of which 4-5 patches run autoconfig then use this option & run autoconfig in last patch or manually (This will save your patching timing , first patch performance tip )
    compiledb(def) or nocompiledb Use no compiledb if you have multiple patch then compile database objects in last patch
    compilejsp(def) or nocompilejsp Use no compilejsp if you have multiple patch then compile jsp in last patch
    copyportion Tells adpatch whether to run commands normally found in a copy driver.
    databaseporion Tells adpatch whether to run commands normally found in a database driver.
    generateportion Tells adpatch whether to run commands normally found in a generate driver
    hotpatch Tells AutoPatch to apply a patch regardless of whether the Oracle Applications system is in maintenance mode.
    integrity Tells adpatch whether to perform patch integrity checking, which verifies that the version of each file referenced in a copy action matches the version present in the patch (There are overheads with this)
    maintainmrc Tells adpatch whether to automatically maintain the MRC schema after running actions normally found in the database driver. The MRC schema is only maintained if the MRC feature is enabled
    prereq Tells adpatch whether to perform prerequisite patch checking prior to running patch driver files that contain actions normally found in the copy driver. (With lateset AD patch , default behaviour is changed from prereq to noprereq)
    forcecopy The forcecopy command copies the files in a patch to the Applications file system without comparing the version number of the patch files with existing files

    Since you know basics of apps patch & options available Next I will tell how to apply patch & fix errors if any .

    If you want to read about Concurrent Managers in Oracle Applications visit my Site at
    http://teachemeoracle.com/cm.html

    Oracle Apps DBA
    Happy Learning
    Happy Apps Learning

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:57 PM   1 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps PATCH Basics II
    Friday, August 11, 2006
    Register for R12 upgrade
    As Oracle Apps DBA patching is quite basic thing you do regularly so lets continue with basics . If you have not gone through my previous posts please do so now as its quite important to through basics .

    Apps patches are buldled somthing like p123456_11i_Unix.zip where p menas patch next few digit are patch number Unix is platform or OS on which this patch can be applied.

    When you unzip a patch you will see some files types which I am explaining here
    readme.txt - This file contain steps to spply patches, List of Prerequisite patch should be there on apps Instance (If not apply that patch )
    cXXXXXXX.drv c stand for copy driver file , this copies patch content to respective patch location , driver is like bus driver which provides instruction on work adpatch need to perform.
    dXXXXXXX.drv d stand for Database driver & contain content related to database like creating packages, tables, adding column....
    gXXXXXXX.drv This contain files related to forms , reports, graphis or messages
    uXXXXXXX.drv Sometime these three types of files are bundled together into single driver file called Unified driver file

    So now you know which type of driver file to apply where ? its common sense if this is d driver you just need to apply once on concurrent manager tier and c & g on all tiers as database is single & if you run it once its enough . If you applied it again by mistake its no harm & will not cause any issues . Similary c & g you need to apply from all tiers , because c will copy your content & g will generate message files.
    If you are not sure where to apply what just apply it on all tiers & depending on your context file in APPL_TOP/admin/SID_hostname.xml it will apply where to install what by checking xml tag TIER_ADFORMS , TIER_ADWEB , TIER_ADADMIN open your xml file & see these parameters are there or not ( For xml file your system should be Autoconfig enabled ) all system after 11.5.8 by default are autoconfig enabled . For more info on Autoconfig check
    http://atul-oracle.blogspot.com/2006/07/autoconfig-in-nutshellwhich-is-most.html

    Happy Learning
    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:27 PM   23 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps Patch Basics
    Thursday, August 10, 2006
    Register for R12 upgrade
    Lot of you asked me about patch basics & even I myself was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & all these buzz words oracle uses to impress people like you & me.

    But before that if you have reached to this post first time & haven't read all my previous post I'll recommend you to go through them as they are basics & very important to understand what I am putting here & in future.

    So now lets start with patch basics / terminology
    Standalone/Oneoff patches : This is used to define patch created to fix single/particular problem.
    Mini Pack : This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ....11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.
    Family Pack : Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack
    Maintenance Pack : Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack ) so

    To wind up things you can say

    few one off patch make mini pack , few mini pack related to same family bundeled together as family pack & all family pack fixed till that time are bundeled in Maintenance pack .

    Oh wait I forgot to tell about NLS Patch ( When you have more than one language , like english & arabic or french .. ) then apart from normal patch you have to apply patch for specific language Installed in your system called as NLS patch ( What is NLS or MLS coming soon ..)


    Next I am going to cover patch basics part II

    Don't forget to leave your comment about what else you want to hear about .
    Apps Learning



    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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 AM   54 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    AD Utilities for Apps DBA
    Wednesday, August 09, 2006
    Register for R12 upgrade
    From now to next few sessions I will be discussuing very important product from DBA's prespective i.e. AD also called as Application DBA ( ;-) I think its named AD after Application DBA )

    AD_TOP is product in Aplication which is under directory APPL_TOP/ad/11.5.0 ( If you are not familiar with TOP please read my previous post about TOP's )

    This top containin Utilities & program code which is very frequently used by DBA's . So where are these utilities or program in file system ? (I think you all know but for begineers its in AD_TOP/bin )

    Lets see one line definition of each

    AD Utility ?
    AD Utilities are a group of tools designed to install, upgrade, maintain, and patch applications.

    ADPATCH ?
    is a utility that is used to apply individual patches, mini-packs, or maintenance packs to an Oracle Applications instance.

    ADADMIN ?
    AD Administration (adadmin) is used performs maintenance/administration tasks on an Oracle Appls Instance. Task associated with adadmin are divided into two broad categories database and file system task.

    ADCTRL ?
    Utility to determine status of worker (started by adpatch , adadmin or other ad utility) and to control ( restart/drop/skip) workers.

    ADRELINK ?
    Used to relink apps executables with product libraries , if some library defination is changed or executable is corrupted.

    ADMRGPCH ?
    To merge different patches & create single patch . This is helpful when you have too many patches , you can merge them & apply in one shot.

    ADCLONE ?
    Utility to clone Insatnce from Test to Prod , Vice Versa

    ADCONFIG ?
    To configure different components in Aplications like changing port number or domainname or incresing number of JVM's

    ADIDENT ?
    utility to find version of a file in oracle applications (Identification )

    ADLICMGR ?
    To license a product in applications , you might have license to use only 10 products initially then later decided to use 5 more so license them first by this utility

    ADSPLICE ?
    You add a product in application, by default you might have 90-105 ( may be more ) products like AP, GL, AR and now oracle released one more product so add this product using this utility .

    This is overview & usages of each application DBA Utility , now in next topic I will start with patching & how these utilities are used & options available with them . If you are amazed/confused whats this patching donot worry I will explain in deatil but if you are a DBA you might already be knowing patching & might have applied coupel of database patches using opatch now lets use ADPATCH to apply application or apps patches.

    Donot forget to leave your comment & feedback .

    Oracle Apps DBA / Apps training

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:36 PM   31 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Apps Architecture
    Tuesday, August 08, 2006
    Register for R12 upgrade
    This Topic is quite important and I recommend you to go through this thoroughly.
    First I want to discuss terminology which you will encounter here & in most of Oracle Documentation.

    Server - is a process or group of processes and provides a particular functionality/service For example, Database Server listen and process database requests, similarly Web Server listens for and processes HTTP requests.

    Tier - is a logical grouping of services, may be on single machine or spread across more than one physical machine. For Example, Middle Tier in Oracle apps consist Form,Web,Report...Services. Forms & Report can be one machine 1 & Web Server can be on machine 2, still they will be part of same tier called as Application Tier or Middle Tier.

    Node - is referred as Machine, Each tier may consist of one or more node and each node can potentially have more than one tier.

    Desktop Tier - Oracle Applications/E-Business Suite is built on three tier Architecture with first Desktop Tier ic client machines accessing applications via browser(HTML based Self service applications) or Java Applet(Jinitiator) for Form based interface.

    Application/Middle Tier - Second is Application Tier also called as middle tier consists of WebServer Forms, Reports, Concurrent processing, Discoverer and Admin Server. I suppose its known as Middle tier because it lies between our desktop & third tier called database tier.

    Database Tier - Third is Database Tier contain Orale database server which store all your application data. I am sure if you are DBA you know it :)

    About Architecture of Individual Component like , Web Server, Form Server .... I will cover in my future posts.

    Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA's)

    Happy Apps Learning .
    Oracle Apps DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:29 PM   42 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Install Oracle Apps
    Monday, August 07, 2006
    Register for R12 upgrade
    This Post will Contain broad level steps of Oarcle apps Installation , this is just for Overview or High level step for Installing Apps. For details & exact commands refer to Oracle Installation Guide mentioned at bottom of this post .

    Pre Instalaltion Steps

    Check System requirement:
    Software Requirenet : like ar, ld, make, gcc, make, Xdisplay - (Unix), MS C++, MKS
    Toolkit (Windows)
    CPU : It depends on Size, no. of Users ... ( For Test Installation don't worry)
    Memory : SGA, Concurrent Users ( Usually 2GB should be enough for testing)
    Disk Space : 26 GB Application Tier and for database Tier (35GB Production DB,
    65 GB for Vision DB )
    Once prechecks are done create User ( Single User or Two user ), with Single user will install both application tier and database tier and for Two user user1(oramgr) will install & own Database tier & user2(appmgr) will install & own Application Tier. (If you don't knwo what is application or database tier please go through my previous post).
    Install MS XML Parser 3.0 Service pack 4 (Only if you are installing Apps in Windows)

    Start Apps Installation
    go to nstallation software ( either mounted on filessystem or Via CD ) & run rapidwiz ( For windows its rapidwiz.cmd)
    Use rapidwiz -restart (If your Installation fails anytime in between , Good feature which Oracle incorporated quite late ;-) lucky you are that this option is there )

    Installer will ask you some questions regarding system answer them
    For Installation Step by Step screens refer Guide mentioned at bottom of this post , chapter 2 page 30 to 57 ( Just 27 pages , Hope its not too much :) )

    Post Installation ( Though these are not required for Testing How apps Installation work)
    few things which you might want to do after Installation
    Update PL/SQL Log and Out directory
    Configure DB Init parameter
    Login to Apps
    Download jinitiator on client PC ( It will automatically prompt to install on client machine when accessing forms)

    For full Installation steps please refer guide at http://download-east.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf

    So this sums up your Apps Installation , If you have any queries / doubts please leave comments or drop a mail at teachmeoracle@yahoo.com

    Apps Installation Training



    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:32 PM   20 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Free Apps DBA Training
    Saturday, August 05, 2006
    Register for R12 upgrade
    Training is quite important in all walks of life and same applies to Oracle Apps DBA life, There is no alternative to Formal Oracle Apps training but looking at price of each training it becomes nightmare for individuals to go through them. (Ofcourese if this training is sponsored by your company than you are really lucky ) How about if you get free Oracle Apps DBA training ;-) now you might be thinking what I am getting in return or why I am writing this believe me it gives such a satisfaction to share knowledge & more you share & more you learn. So I will stop talking here & there and come straight to the point.
    If you are not happy with Self Study (Which I think is best learning ) and if you enough money to pay from your pocket money or If you are going to your manager with links given here for training Good Luck to you all.
    Oracle University provide Oracle Applications 11i training and here are few

    11i System Administrator Fundamentals
    11i Install, Patch, and Maintain Oracle Applications (E-Business Suite)
    11i/2.6 Implement Oracle Workflow (E-Business Suite)
    11i Upgrade Oracle Applications (E-Business Suite)
    11i System Administrator Fundamentals Self-Study CD (E-Business Suite)

    Check more at http://education.oracle.com ( You can check few of our sponsors displayed on Top & Right of this page. )

    Now this was for formal apps training but this is not for which I started this blog, I will start a Unformal Apps Training ( Believe me its free ;-) ) and in your terminology so its easy to understand and you can contact me in case you have any doubts .

    So what are you thinking about Gear Up & Get ready for Oracle Apps 11i Training that too completely free .
    Hold on before that have you done your homework ?
    Are you aware of Apps Architecture ?
    Do you know how request flow in Apps ?
    What are different component in Oracle Apps 11i ?

    If not please go through my previous post starting 29 July 2006

    Training oracle application 11i dba
    http://teachmeoracle.com ( Coming Soon )

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:00 PM   0 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    What's Different TOP's in Application 11i
    Friday, August 04, 2006
    Register for R12 upgrade

    If you want to learn apps dba or want training in apps dba and going through this documentation you might be confused to see again & again that everybody is talking about & its quite difficult to unserstand any topic without knowing what the hell is different tops like APPL_TOP , COMMON_TOP or what eaxctly is TOP ?
    For me TOP is nothing but top level directory & preceded by related software . So TOP is top level directory in file system or oracle 11i software .
    If you have done 11i or oracle application Installation by now ( if not please go though my training for apps dba in my previous posts) Oracle Installer Installs Apps 11i in DB Tier & Application Tier : so lets take Application Tier you will see three directories under your base Installation directory, these diretories are APPL, ORA & COMN (Check pic. at left top of this page) so directory APPL is called as APPL_TOP i.e. top appl directory where files & directories related to different Application ( like GL General Ledger, PO Purchase Order..) exists. If You are DBA you can correlate it with your Oracle database software installation (I know after reading this example you will say its weird but believe me thats how understood it initially , ORACLE_HOME can be called as ORA_TOP , network directory you can say TNS_TOP )
    Under ( ORA_TOP ) you will see diretcory related to oracle home , there are two oracle HOME's in Application Tier 8.0.6 for Forms & Reports , iAS for 9iAS acting as web server)
    COMN_TOP will contain files & directories which will be used commonly by all components ( Isn't this simple to understand )
    similarly
    IAS_TOP is top files/directory under ORA_TOP/iAS I hope it might be clear to you now if not donot worry it will be more clear once you start working as Apps DBA.
    I am attaching few screenshot of other mount points ( Courtsey oracle 11i concepts guide , below is location if you want to read .
    http://download-uk.oracle.com/
    docs/cd/B25516_08/current/
    acrobat/11iconcepts.pdf ( Add these three lines before putting in to browser , I have not put it in single line as it breaks my page layout )
    So In this guide you will find few more screenshot of different TOP's , Go through Chapter 2 , Just 13 Pages ( 13 unlucky number for someone but if understand this chapter , it can be very lucky for you in your Apps DBA Career.

    So here I conclude my TOP's Section , Please don't forget to leave feedback & what you want hear next.

    You can find some comanies on right side or top of this page who might be looking for Apps DBA , visit them by clicking & go to Career section to look for Apps DBA opportunity.

    Happy Learning
    Learn Oracle Apps DBA
    Free Apps DBA Training

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:05 PM   26 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Startup Shutdown Apps Services
    Wednesday, August 02, 2006
    Register for R12 upgrade
    Startup / Shutdown Apps

    In our next topic in learning Oracle Apps DBA , this post covers startup & shutdown of Oracle Application DBA

    As you are aware by now there is Database Tier ( Database & DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server )

    Order of StartUp of Services Should be
    First DB Listener, Database & then Application Tier Services

    Order of ShutDown of Services Should be
    First Application Tier Services then Database & DB Listener

    Database Startup/Shutdown Scripts
    Depending on your AD Version these will be in ORACLE_HOME / appsutil/scripts /SID_hostname
    addbctl.sh database startup shutdown script
    addlnctl.sh database listener Script

    Where

    AD is for Application DBA
    DB is for database
    DLN is database listener
    CTL is control

    Isn't this easy to remeber ( Thanks to Oracle for naming convention)

    -----
    Application Tier Startup/Shutdown Scripts
    Depending on your AD Version these will be in

    OAD_TOP/admin/scripts/ SID_hostname

    adalnctl.sh Apps Listener Control Script
    adapcctl.sh Apache/Web Server Control Script
    adcmctl.sh Concurrent Manager Control Script
    addisctl.sh Discoverer Control Script
    adfrmctl.sh Forms server Control Script
    adrepctl.sh Report Server Control Script
    adstpall.sh Stop All Middle/Application Tier
    adstrtall.sh Start All Middle/Application Tier

    Where AD & CTL you already know now :) isn't it

    adl stand for Apps Listener
    apc stand for Apache
    cm Concurrent Manager
    dis Discoverer
    frm forms
    rep report

    Do you know whats Use of Apps Listener ? Check else I will post it in future post .
    Check what Advertisers has to say on your right side of page .


    Learn Oracle Apps DBA
    Free Apps DBA Training

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:59 PM   48 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Applications Request Flow
    Tuesday, August 01, 2006
    Register for R12 upgrade
    Now since you know Basic Overview of Oracle Applications / apps 11i and Installation (If not read my previous posts) . When user makes a request how request flow across different component in E-Business Suite or Oracle applications .
    By now you might be aware of different Services/Component in Oracle apps I repeat them here these are ,
    1. Oracle Web Server ( Apache, Jserv, plssql ) IAS_ORACLE_HOME 9iAS, Ver. 10222
    2. Forms Server ( 8.0.6 ) ORACLE_HOME
    3. Report Server ( in side 8.0.6 ORACLE_HOME)
    4. Concurrent Manager for Batch or Individual Job Processing
    5. Admin Server ( These are used for application dba job like patching , cloning & lot more )
    6. Database Server

    A) So when User makes a request from browser by typing URL like http:// hostname : port so port number they mention is WebServer Port, request hit to Oracle WebServer ( these requests are recorded in logs where wait for next post )
    B) Webserver checks that with http request there is no cookie attached (Cookie is message given by WebServer to Web Browser to identify client) so user is new & it passes login page to User .
    C) User types his Username Password in login window & clicks submit button
    D) Webserver checks that username and passwords need to authenticate against database FND_USER table , so it needs first some user to check client's username password in database . Guess which username password it uses ?? ( GUEST/ORACLE have you ever noticed why this user is there , Hope you know it now it Uses Guest User to autenticate your user in database )
    E) Once user is authenticated its check against FND_RESPONSBILITY..(Confirm again , not sure table name) for Authorization about users responsibilities & assigned responsibilities are presented back to user.
    F) Now these responsibilities are of two type Self Services(served by Jserv/Servlets) or Core Applications Server by Forms Server .
    G) If this is Core responsibility , Apache transfers request to Forms Listener (Listening on Forms port, I will cover how to check Forms Port in my coming posts ), From here request is on Sockets (May be on forms servelets depending on forms config. ) which is persistense connection. From here onwards Client talks directly with Forms Server in forms session and if Client requested some data, forms server makes database connection ( How ?? using tnsnames.ora in 806 HOME or using dbc Database Connector file in FND_SECURE_TOP or wdbsvr.apps in Apache/modplsql/cfg ?) Post your answer in comment section, you can do it as anonymous user without login as well
    H) If User selected Self Service Responsibility like iProcurement, iRecruitement.., Apache forwards request to mod_jserv and request is fullfilled by jserv_component.
    Have you ever noticed why webserver donot ask client to login again until session timeout ??( I know you know answer now its because of cookies as User have valid cookies , try deleting cookies from browser & see Oracle Apache asks you to relogin .
    I) When your webserver tries to connect to database for plsql or any other type of connection it asks mod_pls to fulfill request but where is this connection information stored ? ( dbc file or wdbsvr.app file or somthing else ? )
    J) Users submits his requests for batch processing or somthing else ( Gather Stats done by Sysadmins or Apps DBA's) these kind of requests are fullfilled by Concurrent Manager ( More about CM, including CM tuning still to come in future )
    G) When user want to see reports of all these things request is being forwarded to Reports Server .

    You as Sysadmin or Oracle Apps DBA need not to worry how this request transmission happens from one service to another , this is transparent to you me or User . ( Let Oracle do this behind the scene ) You should know request flow as this is most crucial during Troubleshooting (I'll cover in future posts ) to pinpoint in which compnent issue is & where to look for .

    If you like this post please tell it to your other Apps DBA friends & Other budding Oracle Apps DBA's . Please don't forget to leave comment & for Advanced Apps DBA , WebServer configuration file system & configuration files look my post at http://atul-oracle.blogspot.com


    Learn Oracle Apps DBA
    Free Apps DBA Training

    Labels:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:32 PM   45 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 @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • 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
    Archives
    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
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar