Sunday, January 12, 2014

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

The adbldxml Utility in R12 supports only on the Database Tier, if you try with application tier will get "Incorrect environment file sourced. Unset apps environment and source RDBMS oracle home environment file". Because adbldxml utility, can be used to create a new context file on the database tier alone.

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.

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 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).

In Release 11i, there was an Option called 'Tier'. This Option has now been removed -- tier= < tiertype> ( { apps(default) | db } )

In case if the utility is invoked from Applications Tier , The below error is encountered.

ERROR (when invoked from Apps-Tier) :

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

Generate a new Context file on the Applications Tier

In order to generate the Applications context file on Applications tier, run the adclonectx.pl script.

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

No comments:

Post a Comment