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
    Autoconfig Basics
    Wednesday, October 04, 2006
    Register for R12 upgrade
    I am getting lots of request for Autoconfig so I thought lets start with this most powerful tool (in my views) in Oracle Apps .

    What is Autoconfig ?
    Autoconfig is tool in Apps to configure oracle Applications 11i , Application Tier as well Database Tier.

    How to run Autoconfig ?
    If you want to configure database tier then you have to execute autoconfig script adautocfg.sh on database tier else if you want to configure on application tier (Middle Tier ) then you have to execute one on middle tier .

    Here is the script location
    For Database tier its $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
    For Application Tier its $OAD_TOP/admin/scripts/$CONTEXT_NAME

    adautocfg.sh calls adconfig.sh from $AD_TOP/bin which inturn calls adconfig.pl from $AD_TOP/bin

    Don't forget to take backup before executing autoconfig.

    What source of information for Autoconfig to update configuration files ?
    If you are wondering where is configuration information stored about your apps 11i instance based on which it updates your Instance then this file is xml file also called as Context file and its in $APPL_TOP/admin for Application Tier or $ORACLE_HOME/appsutil in Database Tier

    I am going to unwrap this xml / context file which is most important file . If you get a chance open this file & go through it so wait for my next post on Context File Contents with explanation & how to put your customization so that Autoconfig can't overwrite them ..

    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 @ 4:42 PM  
    37 Comments:
    • At 6:20 PM, Anonymous Anonymous said…

      Hi
      my name is jeremiah Ochieng. am the pricipal DBA in Safaricom Kenya. my urgent concern is security for the E-biz. there is always a trade off between the security and the performance. can you highlight for us how we can do this so that we have the best security and performance as well

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

      Hi jeremiah,
      Thanks for pointing this out. Do you access applications from internet as well or its just from intranet ?

      Atul

       
    • At 9:14 PM, Anonymous Anonymous said…

      Atul,
      Nice post.
      By the way, it should be AD_TOP/bin instead of FND_TOP/bin.

      -Arunkumar

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

      Arun,
      Thanks for pointing this , corrected now .

      Atul

       
    • At 3:42 PM, Anonymous Anonymous said…

      Atul- you said, "Don't forget to take backup before executing autoconfig"

      Q is that, what us to take backup & location, can you pl help us

      Thanks
      Suresh

       
    • At 3:45 PM, Blogger Atul Kumar said…

      Suresh,
      you Just take backup of xml file . (If you are new to autoconfig & not very good in apps you might want to backup middle tier & database ) but if you know how to troubleshoot in case of any issues then no need to backup middle tier & database .

       
    • At 7:05 AM, Anonymous Anonymous said…

      Waiting for the xml file's post-mortem..........:)

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

      Sandeep,
      I am happy to hear that you would like to hear more on XML file .

      Few more things you can find here

      http://becomeappsdba.blogspot.com/2006/10/unwrapping-xml-context-file-or.html

      More I'll write in a week or two as I have few more things which are already in pipeline.

      Atul

       
    • At 6:53 PM, Anonymous Anonymous said…

      Hi,
      We are planning to change the apps password in our production. Usuallly i use to change the apps password using FNDCPASS and run autoconfig to probagate the password change. But now my client dont want to run the autoconfig after password change. I know we can do this by changing some config files. Can you please give info about what configuration files we should change the passwords in 11.5.10.2

      by
      lac

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

      Iac,
      You don't have to run Autoconfig after changing apps password , you just need to update wdbsvr.app ($IAS_ORACLE_HOME/Apache/modplsql/conf)

      You have to bounce CM after password change.

      If you have any custom file in which you store apps password likle startup shutdown script , change there as well.

      Atul

       
    • At 10:14 PM, Anonymous Anonymous said…

      You don't need to take the backup before running Autoconfig. Since the tool automatically creates a backup in $APPL_TOP/sid_hostname/out directory with the directory name being a time stamp. Just open that directory and run rollback.sh . This will put the system into a status prior to the current Autoconfig run.

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

      Thanks Chandramohan for sharing this information with us.

       
    • At 10:38 AM, Anonymous Anonymous said…

      Hi Atul & Chandra,

      This is my first comment in this site so I am a new kid for all, but not so new for oracle apps DBA world.

      Just seeing the content for apps DBA and would like to add my comments whenever I have time..

      The location and name of the file stated here for rollback of autoconfig should be:

      $APPL_TOP/admin/sid_hostname/out
      /date_time_etc/restore.sh

      Please correct me if I am not looking at the right file/directory.

      Thanks,

      KK

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

      KK & Chandra ,
      Thanks for your feedback & suggestions .

      Here is the actual location

      Application
      --------------
      $INST_TOP/admin/out/[MMDDhhmm]

      Database
      -----------
      $RDBMS ORACLE_HOME
      /appsutil/out/$CONTEXT_NAME/[MMDDhhmm]

      Regerences : Point 5 Rolling back an AutoConfig session

      Metalink Note # 387859.1 Using AutoConfig to Manage System Configurations in Oracle Applications Release 12

       
    • At 6:22 PM, Blogger kiran kumar said…

      Hi atul...
      This is kiran from Hyderabad. Actually i'm a senior lecturer in Physics. As i got bored off in teaching for 8 years, i have chosen Apps DBA to learn. Before that i have learnt Core DBA, but not upto the mark in the subject. Now i'm learning Apps DBA and can i get job being a novice to this field? Pl suggest me in what way i have to read? I'm unable to remember the file locations in different Tiers. Could you pl help me out? Thankyou...

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

      Hi Kiran,
      You focus on basics and architecture. Don't worry about files initially as long as you knoiw where to find in documentation. You will remeber these file names & location once you start actually working on issues & supporting apps

       
    • At 12:17 AM, Anonymous Anonymous said…

      Hi, Atul:
      I am faily new to the apps DBA world, when do we usually run autoconfig?

      casey

       
    • At 5:44 AM, Blogger Atul Kumar said…

      Hi,
      Whenever you wish to change configuration of apps or when instucted by patch read me or by oracle support.

       
    • At 6:48 AM, Anonymous Anonymous said…

      Hi Atul,

      Iam Kumar from hyd.Iam working on production instance,so how can i autoconfig run without stop the applications services.

       
    • At 6:50 AM, Anonymous Anonymous said…

      Hi Atul,
      We can edit the .xml file? when run the autoconfig,what is the back end processes.how .xml file update and read that time.

       
    • At 9:20 AM, Blogger Oracle DBA/GoldenGate Consultant said…

      hi

      running a autoconfig is safe or it can create issues . do we need to bring down the apps tier for it . Wat really it does it just creates context files or it really updates the instance as well
      regards

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

      Autoconfig will configure your system as per entry in context file SID_hostname.xml in APPL_TOP/admin . Autoconfig will make cahnges so if you are not confortable then better take backup before running it. There is option to run autoconfig in precheck mode to see what all files and configurations its going to change. For this option check Autoconfig FAQ in metalink

       
    • At 5:21 PM, Anonymous Anonymous said…

      Atul, I need to change the topic a bit and this is a major task. I am a newbee to Oracle Application. We have upgraded our Appliction from 11.5.4 to 11.5.10 as well as the platform from Sun Solaris to Dell Serveers running Linux ES4. Now we are running a number of tests at the moment and I was wondering if you could help with just simple cold backup scripts backing everything to tape. What I am asking is not the Linux commands in backing up but just what your simple approach will be in taking a cold backup to tape.

      These are my mount points.......
      /
      /boot
      /dev/shm
      /home
      /tmp
      /usr
      /var
      /u01
      /u02
      /u03

      Thanks.

       
    • At 8:56 PM, Blogger Atul Kumar said…

      Shutdown application tier and database.

      Identity mount point where your application tier and database tier files including data files exists and copy them to tape using tape libbary commands.

       
    • At 2:29 PM, Anonymous Anonymous said…

      Thanks for the expertise

       
    • At 7:00 AM, Anonymous Anonymous said…

      going into single user mode also helps... AD

       
    • At 6:03 AM, Blogger Ram Murale said…

      Hi
      My name is Ram. Am the AppsDba. My concern is one of my instance home page is not opening. All the services are runinng fine. DB and listner also running.Is there any reason why the home page is not opening.
      Thanks,
      Ram.

       
    • At 6:05 AM, Blogger Ram Murale said…

      Hi,
      can help in the home page is not opening while all the services are running in both the appsTier and dbTier

       
    • At 5:20 PM, Blogger Unknown said…

      Hi Atul,

      Can u pls tell me why Autoconfig is required before running adpreclone, even if we know that our source system is in its updated form? Is it necessary for cloning?

       
    • At 7:12 PM, Blogger NarenderSingh said…

      Atul,

      This is the first time I am responding to your blog. Just wanted to add on a cooment of changing APPS password without running autoconfig.

      New APPS password must be updated in two files
      $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app on mid tier
      and
      $ORACLE_HOME/reports60/server/CGIcmd.dat on admin tier

      Also we need to bounce CM and Mid Tier services (Apache/forms) to avoid any issues during runtime.

      Thanks
      Narender Singh

       
    • At 10:36 AM, Blogger Unknown said…

      Hi,

      Iam new to apps. I have 11.5.9 running on RHEL4.0. Unfortunately i have lost scripts on database tier in messing up with preclone and autocfg. Is there any way to retrieve scripts for database tier.

       
    • At 3:36 AM, Anonymous Anonymous said…

      hi i am jaya
      how can i find apps services are running or no

       
    • At 2:27 PM, Anonymous Anonymous said…

      Hi Jaya ,

      Just go to the $COMMON_TOP/admin/scrtips/

      and check the status using

      adapcctl.sh apps/ status

       
    • At 7:40 AM, Anonymous Jayakumar said…

      Hi,
      I am new to OracleEBS.I have installed OracleEBS11i at Machine1(Hp-ux 64 bit).Then i have migrated the 9i database to Oracle 10g,which is at Machine2(hp-ux 64bit).Nw i need to reconfigure my database tire with 10g database instead of 9i(default).How can i do this..?

       
    • At 7:42 AM, Anonymous Jayakumar said…

      Hi,
      I am new to OracleEBS.I have installed OracleEBS11i at Machine1(Hp-ux 64 bit).Then i have migrated the 9i database to Oracle 10g,which is at Machine2(hp-ux 64bit).Nw i need to reconfigure my database tire with 10g database instead of 9i(default).
      How can i do this..?

       
    • At 8:49 AM, Blogger Sriram Subbarayalu said…

      Hi,
      Whether we required autoconfig after changing apps password using FNDCPASS?

       
    • At 8:49 AM, Blogger Sriram Subbarayalu said…

      Hi,
      Whether we required autoconfig after changing apps password using FNDCPASS?

       
    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