• 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 » ADODFCMP Utility

ADODFCMP Utility

March 23, 2012 by techgoeasy Leave a Comment


The ODF Comparison utility(ADODFCMP) is used to compare the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model.

Each application consists of certain building blocks. There is an object descriptor file (ODF) describing the oracle tables, oracle view, oracle indexes, sequences and privilege sets for the particular building block. ODF Comparison compares the building block to the object descriptor file (ODF). A log file is created showing any missing, extra, or incorrectly defined objects

Whenever we apply the oracle application patches,patches supply odf’s file and oracle adpatch run odf comparison utility to make the changes in the database.

Sometime we need to run odf comparison manually to check for missing objects .

How to run ODF comparison utility(ADODFCMP)


cd $PROD_TOP/admin/odf
Parameters can be specified in any order on the command line. The following
parameters are required: mode, touser, priv_schema, odffile, userid

mode (required) :Determines the type of objects to compare against the ODF.Example tables,indexes
touser (required) : Specifies the Oracle username/password of the Oracle Applications product to grant to. In Release 11i/R12 this is usually APPS schema.
priv_schema (required) :Specify a schema having DBA privileges, along with its password. You may specify the SYSTEM schema
odffile (required) : The name of the object descriptor file (file extension .odf) to compare.
userid (required) :The Oracle username/password for the product’s base schema. This is the schema where the product tables, indexes and sequences are located for example inv/inv
changedb (opt) No :Set to yes to change the database objects to match the definitions in the object descriptor files. Customizations are not affected because the utility does not delete objects not found in the ODF. Using the default, No, will not make anychanges only produce a log file indicating what changes need to be made.

Example

Make a comparison of the indexes in onttab.odf. Make changes to the database.
Create a log file called onttab.log in the current directory.


adodfcmp odffile=onttab.odf userid=ont/ont changedb=yes priv_schema=system/manager mode=indexes touser=apps/apps logfile=onttab.log

Also Reads
FNDLOAD command
FNDCPASS
oracle apps dba interview questions


Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: ADODFCMP, ADODFCMP Utility

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

  • 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
  • Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack)

Copyright © 2021 : TechGoEasy

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