• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » Downtime Reduction during Patching in R12.0/R12.1

Downtime Reduction during Patching in R12.0/R12.1

June 19, 2012 by techgoeasy Leave a Comment

(1) Oracle now supports the Shared Application-Tier System. If you have multiple Application Servers using Load Balancing, then all the servers can share one single shared Application-Tier. Use Metalink Note: 233428.1 for 11i, and 384248.1 for Release 12. Patches  applied to shared application tiers are instantly available to all application tiers

(2) Shared application tier systems, distributed AD (Note:236469.1) can be used to run adpatch and adctrl on multiple nodes, that share the application tier file system

Distributed AD

(3)Staged Application Systems  Metalink Note: 242480.1, where patches are applied to a stage area, before the production upgrade, and then only the database portion is applied on the Production Instance thus reducing downtime

Stages APPL_TOP in R12

(4) Merge multiple patches into smaller number of patches using AD Merge

AD Utilities(adadmin, adrelink , adident, ADMRGPCH)

(5) AD Patch can be run in non-interactive mode, by creation of defaultsfile, and then creating batch programs which will runs series of patches one after the other without asking any questions.

Oracle patching: Adpatch Complete Overview

(6) Use options like “nocompiledb”, which will not compile all objects every time it applies a patch. Only the last patch can have the “compiledb” option.

Related articles

40 Adpatch question every DBA should know
oracle apps queries for DBA
oracle apps dba interview questions

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: Downtime Reduction during Patching

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle
  • How to find concurrent request id from Sid or spid
  • how to check recycle bin in oracle: Purge, enable/disable
  • how to check fra size in oracle: Location, usage, change size

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us