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
    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:
    • At 2:30 AM, Anonymous Anonymous said…

      Good resource....helping me in slowly getting the feel of Apps.

      --Rachna

       
    • At 7:21 AM, Anonymous Anonymous said…

      Thanks Rachna,
      If you are like it keep checking what our sponsors have to say on right side or top of this page in pinnk . You might find jobs as well in our sponsors site .

      Check similar at Advanced Apps DBA

       
    • At 10:37 PM, Anonymous Anonymous said…

      Hey Atul,

      Good material and thanks for providing the information

      Regards,
      Raghav

       
    • At 10:42 PM, Blogger Atul Kumar said…

      Thanks , cheers

      Atul

       
    • At 2:18 PM, Anonymous Anonymous said…

      Hai Atul,
      Thanks a lot for providing such beautiful information about Apps dba.
      Troubleshooting about concurrent managers,jserv,Apache is really helpful for us for attending interviews.
      I also requst you to share some of the problems you had faced while patching,cloning or any other such situations and also how u solved it.It also helps us a lot.
      Thank you once again
      kiran

       
    • At 2:48 PM, Blogger Atul Kumar said…

      Kiran,
      I can do that but I suppose lot of guys will use this information during interview & interviewer can easily undersatnd if you really faced issue or you have read it on some site so I prefer you or any other person not to mug up such issues.

      I am planning to update on How to troubleshoot apache & other components soon.

      Atul

       
    • At 9:52 AM, Anonymous Anonymous said…

      Atul,

      Awesome work Atul..Im finding Apps very intersesting and simple to learn now.
      Thanks!

      -Sandeep

       
    • At 10:02 AM, Blogger Atul Kumar said…

      Sandeep,
      Thanks a lot for our feedback. This was my motto when I first thought of writing on How to become Apps DBA. Discovering Oracle Apps DBA in simple words.

      Atul

       
    • At 4:25 PM, Blogger subba reddy said…

      hi atul,

      That was enough information u posted & Iam working as sys admin & I know basic programming & Oracle with D2K. I want to be a DBA, kindly mail me some good material on DBA to subbareddyvs@gmail.com

       
    • At 4:17 AM, Anonymous Anonymous said…

      hi atul,

      this is Kenny again. I had been
      reading a bit on how to write
      startup/shutdown script for the
      middle-tier.

      In most of the scripts, the apps
      userid/password is supplied in the
      scripts. Is this a standard practise?

      Is there anyway to secure it? If a
      person knows the apps userid/password,
      how does it affect the security of
      the system?

      Hope to hear from you soon.

      thanks
      Kenny

       
    • At 6:23 AM, Blogger Atul Kumar said…

      Kenny,
      Apps username password is required only to start concurrent manager i.e. adcmctl.sh
      If you are using adstrtal.sh to start all services which in turn calls CM so you need apps password here as well.

      Apps password is quite important & end user should not have access to unix/windows middle tier as that has apps password stored in file system. Only authorized user should have access.

      There is dedicated forum for Apps DBA's at http://teachmeoracle.com/forum

       
    • At 2:26 AM, Anonymous Upender said…

      hi atul
      this is upender, i notices a minute mistake in this post... cm is called concurrent manager in adcmctl.sh, where as u mentioned it as cmc... plz check it out

      and ur efforts are good.... keep going

       
    • At 7:49 AM, Blogger Atul Kumar said…

      Hi Upendra,
      Thanks for pointing out , changed :)

      Atul

       
    • At 8:16 AM, Blogger Anand said…

      Hi Atul,

      Anand here, There is a small mistake in the post as upendra said.. aln is for Application listener (adalnctl.sh) not adl.:)

       
    • At 12:34 PM, Blogger Atul Kumar said…

      Thanks Anand for correcting it


      Atul

       
    • At 8:22 PM, Anonymous Anonymous said…

      Thanks for refreshing my memory from Oracle Apps 10.7 days

       
    • At 9:57 AM, Blogger sandeep said…

      hello atul
      thanks for providing good material.iam just learning from ur site.can u please help me.
      sandeep

       
    • At 10:03 AM, Blogger Atul Kumar said…

      Sandeep,
      Feel free to raise any questions/doubts at forum dedicated to apps dba's http://teachMeOracle.com/forum and Guys there will be able to help you

       
    • At 11:15 AM, Blogger Vignesh said…

      Hi Atul,

      Thanks a lot for you. These guidlines and stream of my self study make me an APPS DBA.

      Regards
      Vignesh

       
    • At 11:21 AM, Blogger Atul Kumar said…

      Thanks Vignesh, A lot depends on your self study & hands on ..

       
    • At 3:05 AM, Blogger Fendy said…

      Hi Atul,

      Thanks for the valuable resource...
      I've face the problem when uploading file from attachment window from Apps. I've also stop and start the apache server and retest the uploading process.But, the error.log produce the error like this :
      File does not exist: /u0/oracle/prod1ora/iAS/Apache/Apache/htdocs/discwb4/applet/dummyToClearIE404Error
      [Mon Mar 12 09:39:09 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/java/awt/KeyboardFocusManager.class
      [Mon Mar 12 09:39:10 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/oracle/apps/fnd/formsClient/FormsLauncherBeanInfo.class
      How do I troubleshoot this problem ?

       
    • At 3:05 AM, Blogger Fendy said…

      Hi Atul,

      Thanks for the valuable resource...
      I've face the problem when uploading file from attachment window from Apps. I've also stop and start the apache server and retest the uploading process.But, the error.log produce the error like this :
      File does not exist: /u0/oracle/prod1ora/iAS/Apache/Apache/htdocs/discwb4/applet/dummyToClearIE404Error
      [Mon Mar 12 09:39:09 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/java/awt/KeyboardFocusManager.class
      [Mon Mar 12 09:39:10 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/oracle/apps/fnd/formsClient/FormsLauncherBeanInfo.class
      How do I troubleshoot this problem ?

      TIA,
      Fendy

       
    • At 6:59 AM, Blogger Atul Kumar said…

      Fendy,
      Can you please put navigation path and which version of apps you are on...

      Atul

       
    • At 11:33 PM, Blogger irfan said…

      Hi Atul


      Inforamtion u provided is very useful for a beginner like me ... we installed Oracle Apps .... how can we change the passwd for super user or any other user . for shutting down or bringing up we have to login as super user ,, and it prompts for password , how can we change the paswd ... if so we have forgot the password

      Thanks
      Ian

       
    • At 12:07 AM, Blogger irfan said…

      Hi Atul


      Inforamtion u provided is very useful for a beginner like me ... we installed Oracle Apps .... how can we change the passwd for super user or any other user . for shutting down or bringing up we have to login as super user ,, and it prompts for password , how can we change the paswd ... if so we have forgot the password

      Thanks
      Ian

       
    • At 11:20 PM, Blogger Atul Kumar said…

      Ian ,
      If this is application user password check

      http://becomeappsdba.blogspot.com/2007/01/change-oracle-apps-password-fndcpass.html

       
    • At 9:57 PM, Anonymous Anonymous said…

      Does anyone here know how to change the OID password? We don't have the current OID Password, to reset it to a new password. any help is appreciated.

      Thanks
      Sunitha

       
    • At 10:01 PM, Blogger Atul Kumar said…

      Sunitha,
      You want to change user password stored in oid then you oiddas screen

      http://infra_host:http_port/oiddas

      You can also use GUI oidadmin from oid server to change user passwords stored in OID but make sure these passwords are synched with application (if any) associated with that OID

       
    • At 10:29 PM, Anonymous Anonymous said…

      I am trying to logon to Oracle Internet directory but i don't have a userid or password. How to i find out what the userid or password is as a super user.

       
    • At 10:34 PM, Anonymous Anonymous said…

      Atul,

      I am trying to find out the suer user userid and password for Oracle internet Directory. We currently do not know what it is. is there a way to reset the super user password and find out what user name was used.

      Thanks
      Sunitha

       
    • At 7:40 PM, Blogger Atul Kumar said…

      Super user is orcladmin , password is same as ias_admin or ods .

      There is ods password stored in oidstats.sh file check if that works.

       
    • At 1:50 PM, Blogger ankush said…

      hi
      if in any case we lose the startup script of any services eg adapcctl.sh is there any way to create it. u can also reply me at
      ankushchawla03@gmail.com

       
    • At 1:52 PM, Blogger ankush said…

      hi
      if in any case we lose the script to start the services eg.adapcctl.sh then how we can create it.please help urgent

      regards
      Ankush

       
    • At 7:26 PM, Blogger Atul Kumar said…

      Run Autoconfig, This will create new startup/shutdown script

       
    • At 2:51 PM, Blogger ankush said…

      hi atul ,

      do we need to bring down the apps Tier before running autoconfig

      regards
      Ankush

       
    • At 2:53 PM, Blogger ankush said…

      what all checks a APPS DBA need to perform to check that everything is working fine.

      regards
      Ankush

       
    • At 6:33 PM, Blogger Atul Kumar said…

      Ankush,
      Check health check list which one should check to confirm everything is working fine

      http://www.teachmeoracle.com/healthcheck.html

       
    • At 4:44 AM, Anonymous Paven said…

      Hi Atul,

      Your blog is really useful for newbie AppsDBA as me. I want to write some scripts for auto shutdown EBS 11i(apps + db) at night for backup as:

      adstpall.sh apps/xxx
      sleep time
      addbctl.sh stop immediate

      Please help me set time for ensuring all services shutdowned? And how to check log or send mail when they have errors?

      Thks,
      Paven

       
    • At 4:46 AM, Anonymous Paven said…

      Hi Atul,

      Your blog is really useful for newbie AppsDBA as me. I want to write some scripts for auto shutdown EBS 11i(apps + db) at night for backup as:

      adstpall.sh apps/xxx
      sleep time
      addbctl.sh stop immediate

      Please help me set sleep time for ensuring all services shutdowned? And how to check log or send mail when they have errors?

      Thks,
      Paven

       
    • At 7:37 AM, Blogger sheetal said…

      Hi atul...
      u haven't mentioned about the script that is used for apache in restricted mode??
      it was asked in one of my intervew..
      waiting to hear from u....


      ..sheetal

       
    • At 8:42 AM, Blogger Atul Kumar said…

      Thanks sheetal for reminding that..Yes I missed it from my list

       
    • At 11:26 PM, Anonymous Anonymous said…

      as far as i know it's not adstrtall.sh but adstrtal.sh ...;)

       
    • At 9:27 AM, Blogger Atul Kumar said…

      Thanks for correcting typo

       
    • At 12:27 PM, Anonymous Anonymous said…

      Hai,
      How to start Adminserver..?
      Regards
      Jagadeesh

       
    • At 11:25 AM, Blogger history's said…

      Hi Atul,

      I'm really happy to see such a good web site for learning Oracle-Apps Database Admin.It becomes very easy for readers like us to clarfiy their doubts via this.

      Thanks a lot for developing this.

      Keep it up Atul.

      Yo,
      Sundar

       
    • At 1:51 PM, Blogger brij said…

      hi,
      it really a good site for new oracle apps dba, it helps a lot

      Regards,
      Brij

       
    • At 10:12 AM, Anonymous Anonymous said…

      Hi atul,

      I am apps techno func consultant have good exposure to appsdba on windows platform i can start services n stop all services as and when need on window. i would like to know how to start the servies at linux i know the command from your blog example
      adapcctl.sh
      adcmctl.sh
      it will be great help if you let us know how to run from linux. like log into linux and go..like that..

      Thanks
      SA

       
    • At 12:23 PM, Blogger Surendra said…

      Hi attul,

      Thankyou, soon apps no more alien to me.

       
    Post a Comment
    << Home
     
    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