September 25, 2012

adbldxml.pl in Oracle Apps

By Nagulu Polagani

How to rebuild context file in Oracle Apps and how to create a context file in oracle apps 11i and R12

11i application Tier Context File Creation

For the appsTier Under $AD_TOP/bin

perl adbldxml.pl tier=apps appsuser=apps appspass=apps template=/u01/apps/prodappl/ad/11.5.0/admin/template/adxmlctx.tmp log=/home/applmgr/adbldxml.log out=/u01/apps/prodappl/admin/PROD_apps.xml servername=apps.oracle.com jtop=/u01/apps/prodcomn/util

R12 application Tier Context File Creation:

The adbldxml Utility is only supported on the Database – Tier, not on the Applications – Tier in R12, try below steps to create contextfile on applications:

[applmgrn@apps admin]$ pwd
/u02/apps/inst/apps/TEST_apps/appl/admin
[applmgrn@apps admin]$ rm -f TEST_apps.xml
[applmgrn@apps admin]$ ls -ltr

total 120
-rw-r–r– 1 applmgrn dban 10234 May 12 19:11 adovars_TEST_apps.env
-rw——- 1 applmgrn dban 6804 May 12 19:11 ojspCompile.properties
-rw——- 1 applmgrn dban 3284 May 12 19:11 ojspCompile.conf
-rw——- 1 applmgrn dban 1004 May 12 19:11 oamextensions.xml
-rw-r–r– 1 applmgrn dban 86762 May 12 19:16 TEST_apps.xml.bkp
[applmgrn@apps admin]$ ls
adovars_TEST_apps.env oamextensions.xml ojspCompile.conf ojspCompile.properties TEST_apps.xml.bkp
[applmgrn@apps admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:
/u02/apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /u02/apps/inst/apps/TEST_apps/appl/admin/RetrieveContext_05130809.log

Database Host [apps]:

Database Host Domain [appsdbatraining.com]:

Database Port [1521]:1522

Database SID:TEST

APPS Schema Name [APPS]:

APPS Schema Password:apps

The following context files are available:

[1] TEST_apps (APPL_TOP Context)
[2] TEST_apps (Database Context)

Select the context to retrieve [1]:1

Destination file path [/u02/apps/inst/apps/TEST_apps/appl/admin/TEST_apps.xml]:

Retrieved context file to /u02/apps/inst/apps/TEST_apps/appl/admin/TEST_apps.xml

Log file location: /u02/apps/inst/apps/TEST_apps/appl/admin/RetrieveContext_05130809.log
[applmgrn@apps admin]$ ls
adovars_TEST_apps.env ojspCompile.conf RetrieveContext_05130809.log TEST_apps.xml.bkp
oamextensions.xml ojspCompile.properties TEST_apps.xml
[applmgrn@apps admin]$

11i and R12 Database Tier Context File Creation:

perl adbldxml.pl appsuser=apps appspass=apps template=/u02/ora/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp out=/u02/ora/db/tech_st/11.1.0/appsutil/TEST_apps.xml