Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: Maintenance Mode is a new mode of operation introduced with Release 11.5.10!!!!!!!!

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • Maintenance Mode is a new mode of operation introduced with Release 11.5.10!!!!!!!!
    Wednesday, December 12, 2007
    Maintenance Mode is a new mode of operation introduced with Release 11.5.10, in which the Oracle Applications system is made accessible only for patching activities not allowing the users to login to any responsibility. This provides optimal performance for auto patch sessions, and minimizes downtime needed.

    We can make the maintenance mode enable or disable either by using Ad utility (adadmin) or OAM(oracle applications Manager)

    steps for enabling and disabling maintenance mode (adadmin)

    1)Run the consolidated contextname.env file which is available in $APPL_TOP/ usually
    file name is like APPS.env
    Context name= SID_

    2)start adadmin answer the subsequent prompts you can get the main menu of the adadmin utility select 5) change maintenance mode afterthat you will get another menu select 1)enable maintenance mode
    3)When you Enable or Disable 'Maintenance Mode', adadmin will execute the script:
    $AD_TOP/patch/115/sql/adsetmmd.sql sending the parameter 'ENABLE' or 'DISABLE' :

    4)Even you can enable the maintenance mode by calling the scripts in sql prompt
    sqlplus /@adsetmmd.sql ENABLE | DISABLE

    5)When adsetmmd.sql runs, it sets the Profile Option 'Applications Maintenance Mode' (APPS_MAINTENANCE_MODE) to 'MAINT' to Enable 'Maintenance Mode' and to 'NORMAL' to Disable it.


    After the auto patch process we have to disable the maintenance mode by using adadmin

    How we know that maintenance mode is enabled ?

    We can find out whether maintenance mode is enabled or not by executing the simple query

    sqlplus apps/apps
    SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

    If the query returns MAINT then maintenance mode is enabled .
    If the query returns NORMAL then maintenance mode is disabled

    Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require Mainten
    posted by Jaswinder Singh @ 8:02 PM  
    4 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .