With 11gR2, Oracle has introduced Edition-based redefinition to help in online modification. R12.2 Online Patching also uses the same feature to achieve Online patching.in R12.2 Editions are synced between the OS filesystem and database
Two Edition Definitions
Runtime: Used by Online Users, Never changed by a Patch
Patch: Used by the Patching Tools, Changes do not affect the running Application
Edition Determination in EBS
How to tell your Edition
From OS: echo $FILE_EDITION From DB: select ad_zd.GET_EDITION_TYPE, ad_zd.GET_EDITION from dual;
Set Up the edition in EBS
how to set the edition in EBS
From OS: source /u012/oracle/ebs_122/EBSapps.env run or source /u012/oracle/ebs_122/EBSapps.env patch echo $RUN_BASE - the run filesyste echo $PATCH_BASE - the patch filesystem From DB: ad_zd.SET_EDITION(‘RUN’) or ad_zd.SET_EDITION(‘PATCH’)
Helpful sql scripts related to Edition in R12.2
| Sql scripts | Description
|
| ADZDSHOWED | Show only event and error messages from the online patching diagnostic log (a useful summary, without the detailed statement text). |
| ADZDSHOWLOG | Show full diagnostic log for online patching infrastructure |
| ADZDSHOWLOGEVT | Show only error messages from the online patching diagnostic log. |
| ADZDSHOWLOGERR | Show Object Summary per edition. Counts of actual and stub (inherited) editioned objects per edition. |
| ADZDCMPED | Compare Patch Edition with Run Edition. Warning: this script may take a long time to run. |
| ADZDSHOWOBJS | Show editioning view column mapping for the table. |
| ADZDSHOWAOBJS | Show Actual Objects in the current edition. These are the editioned objects that have been changed by the patch |
| ADZDSHOWIOBJS | Show Inherited Objects in the current edition. These are the editioned objects that remain untouched in the Patch Edition. |
| ADZDSHOWSM | Show Seed Manager status. |
| ADZDSHOWTAB TABLE_SYNONYM_NAME | Show table information and related objects. |
| ADZDSHOWEV TABLE_SYNONYM_NAME | Show editioning view column mapping for table. |
| ADZDSHOWCOBJS | Show Covered Object Summary per edition. Count of objects in old editions that have a replacement in the run edition |
| ADZDSHOWCOBJX | Show Covered Object List. List of objects in old editions that have a replacement in the run edition. |