• 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 » R12.2 Edition determination and setup

R12.2 Edition determination and setup

August 7, 2015 by techgoeasy Leave a Comment


With 11gR2 ,Oracle has introduced Edition based redefinition to help in online modification. R12.2 Online Patching also usage the same feature  to achieve Online patching.in R12.2 Editions are sync’ed 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 no 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 your Edition:
From OS:
source /u012/oracle/ebs_122/EBSapps.env run or
source /u012/oracle/ebs_122/EBSapps.env patch
echo $RUN_BASE – the run filesystem
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 database editions and current edition.
ADZDSHOWLOG Show full diagnostic log for online patching infrastructure
ADZDSHOWLOGEVT Show only event and error messages from online patching diagnostic log (a useful summary, without the detailed statement text).
ADZDSHOWLOGERR Show only error messages from online patching diagnostic log.
ADZDCMPED Compare Patch Edition with Run Edition. Warning: this script may take a long time to run.
ADZDSHOWOBJS Show Object Summary per edition. Counts of actual and stub (inherited) editioned object per edition.
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.

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: edition in R12.2

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

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

Recent Posts

  • Multi Language Support in 11i/R12
  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1

Copyright © 2021 : TechGoEasy

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