Introduction:-
Oracle E-Business Suite Release 12.2 includes new Online Patching feature that
allows for Oracle E-Business Suite patches to be applied while users are still
online and using the Oracle E-Business Suite.
The implementation of Oracle E-Business Suite
Online Patching relies on the new Edition-based Redefinition
technology from the database and the new Online Patching infrastructure, including the new file system.
Database Editions:-
Online Patching Interacts with 3
Edition Types
Run Edition :-
> The Edition Currently in use by running application
> This is always the default Database edition.
Patch Edition :-
> The edition currently in use by the the patching tools.
> The edition is only present when patching is in progress.
> Always the direct child of the run edition.
Old Edition(s) :-
> There maybe Zero or More Old editions.
> When the patch edition is promote to productions the previous run edition is now regarded as an old Edition.
> Only retained until a full cleanup operation is run in no effect in the running application.
Run Edition :-
> The Edition Currently in use by running application
> This is always the default Database edition.
Patch Edition :-
> The edition currently in use by the the patching tools.
> The edition is only present when patching is in progress.
> Always the direct child of the run edition.
Old Edition(s) :-
> There maybe Zero or More Old editions.
> When the patch edition is promote to productions the previous run edition is now regarded as an old Edition.
> Only retained until a full cleanup operation is run in no effect in the running application.
Editioned Database Objects:-
Editioned objects may have different
definitions in each database edition. This means
that such objects can be easily patched (in the patch edition)
without affecting the running application (in the run edition).
All code type objects
support editioning
The Database automatically manages multiple
copies of these objects during patching
–Package Spec
–Package Body
–Function
–Procedure
–Views
–Editioning Views
–Triggers
–Types
– Synonyms
Non-Editioned Database Objects :-
Non-editioned objects have the same
definition shared across application editions. Such objects must be patched
carefully to avoid affecting the running application
Storage
objects do not support editioning
Online
Patching uses advanced features of EBR to manage these objects during patching
– Tables
– Indexes
– Materialized Views
– Sequences
All code must access the data
model via the APPS
> synonym
> APPS synonym points to the
Editioning View (Logical Model)
> Any code accessing the
physical model risks accessing obsolete columns.
No comments:
Post a Comment