Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Review and Resolve Manual Configuration Changes in Oracle EBS 12R 12.1.1 on Oracle RDBMS 11g

Review and Resolve Manual Configuration Changes in Oracle EBS 12R 12.1.1 on Oracle RDBMS 11g

The adchkcfg utility verifies the context file. Below follows detail explanation of the functionality of the adchkcfg utility.

  • The Check Config utility (adchkcfg) is located in locations as specified in the table below.
Tier Location
Application <AD_TOP>/bin
Database <RDBMS ORACLE_HOME>/appsutil/bin
  • Check the AutoConfig configuration files by executing the following command:
  • On UNIX
    adchkcfg.sh contextfile=<CONTEXT>
  • This script will generate both html and text reports that provide information about all file changes, profile option changes and other important database updates that will be done during the next normal execution of AutoConfig. The report consists of two tabs:
  • File System Changes
    This report provides information about all the files that will be changed during the next normal execution of AutoConfig. The report is divided into the following sections:
  • AutoConfig Context File Changes
    Displays information about the location of the context file, the content of the currently active context file, the content of the context file that will be generated in the next AutoConfig run. In addition it also displays an html report highlighting the differences between the current and the new context file.
  • Changed Configuration Files
    Displays a list of all the files that will be changed during an AutoConfig execution. For each file, information is displayed about the location of the runtime file, the content of the currently active file, the content of the file that will be generated in the next AutoConfig run, an html report highlighting the differences between the current and the new configuration file and the location of the AutoConfig template file.
  • New Configuration Files
    Displays a list of all the new files that will be created during an AutoConfig execution. For each file, information is displayed about the location of the runtime file, the content of the new file and the location of the AutoConfig template file.
  • Database Changes
    This report provides information about all the profile options that get changed during the next normal execution of AutoConfig. This report is divided into three sections.
  • Profile Value Changes
    Displays the details only for profiles whose value would be changed in the next AutoConfig run. For each such profile, the current value in the Database, the new AutoConfig value that would be set for it, the Profile Level and the name of the AutoConfig script that changes the profile value is displayed.
  • Profile Values
    Displays the details as in previous section for all Apps Database profiles managed by AutoConfig.
  • Other Database updates
    Displays the details for important database updates that will be done in the next run of AutoConfig. The table name, column name, the current column value in the Database and the new AutoConfig value is displayed along with the name of the updating AutoConfig script and a brief description.

Resolve any reported differences between your existing files and the files AutoConfig will create.

The script will also create a zip file report “ADXcfgcheck.zip” that contains all the files and reports mentioned above, so that the ADXcfgcheck.zip can be copied to a local desktop PC and the html report can be viewed there without breaking the hyper-links in the report.

December 13, 2009 - Posted by | oracle

2 Comments »

  1. Hi,

    Do you know the Quest Shareplex could be implement on Oracle EBS ?

    I just survey the solution to sync the ebs db at different site and this could for the disaster recovery policy.

    thanks

    Comment by Charley | March 22, 2010 | Reply

    • Yes. Quest Shareplex can and has been used with EBS databases.

      Comment by gjilevski | March 22, 2010 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: