Sunday 27 June 2010

Generate the Context File on the R12 Database Tier - adbldxml.pl

When I have generated the appsutil.zip file using the following steps
  • Log in to the APPL_TOP environment (source the environment file)
  • Create appsutil.zip file
  • perl [AD_TOP]/bin/admkappsutil.pl
  • perl $AD_TOP/bin/admkappsutil.pl
  • This will create appsutil.zip in [INST_TOP]/admin/out
  • Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME]
  • cd [RDBMS ORACLE_HOME]
  • unzip -o appsutil.zip
There is a problem with appsutil directory under database tier, I did'nt find the scripts directory under appsutil. Due to that I can't run autoconfig in database tier. To solve this issue, need to run adbldxml utility, this will create a new context file on the database tier. The new context file acts as a central repository for database configuration information.

The AutoConfig Build Context utility has been revived and re-introduced in Oracle E-Business Suite R12 for the database tier. It is essential for enabling AutoConfig on the database tier and this utility facilitates and simplifies database upgrades and cross platform migration.

The adbldxml Utility is only supported on the Database - Tier, not on the Applications - Tier in Release12!

In case if the utility is invoked from Applications Tier, you will get error message similar to

Incorrect environment file sourced. Unset apps environment and source RDBMS oracle home environment file.

Invoke adbldxml.pl from  Database Tier only. A new context file on the database tier can be created using the following command :

perl $ORACLE_HOME/appsutil/bin/adbldxml.pl template=[contextfile_template] out=[contextfile_name]

Where [contextfile_template] is the location of the context template (default is $ORACLE_HOME/appsutil/template/adxdbctx.tmp) and [contextfile_name] is the absolute Path of the context file to be generated (the default is $ORACLE_HOME/appsutil/[context_name].xml).

Generating  a new Context file on the Applications - Tier :

run the adclonectx.pl script from.
perl [COMMON_TOP]/clone/bin/adclonectx

To retrieve the applications tier context file ( if it is lost or deleted accidentally) , execute the following command on the applications tier :

perl [COMMON_TOP]/clone/bin/adclonectx.pl retrieve

Related Posts by Categories



1 comment:

Anonymous said...

Hi,

Its not always that we need this much steps. After extracting appsutil.zip just close your current session and reconnect with fresh Oracle user. Your adbldxml.pl will create xml file without any problem. It worked with me.... :)

Regards
RanjanS