If we lost $CONTEXT_FILE .How to rebulid in oracle apps R12.
=============
Let's create senario
==============
/apps/vision/inst/apps/vision_apps/appl/admin
[applvision@apps admin]$ ls -tlrh
total 120K
-rw-r--r-- 1 applvision applmgr 11K Sep 28 07:43 adovars_vision_apps.env
-rw------- 1 applvision applmgr 7.0K Sep 28 07:44 ojspCompile.properties
-rw------- 1 applvision applmgr 3.3K Sep 28 07:44 ojspCompile.conf
-rw------- 1 applvision applmgr 1010 Sep 28 07:44 oamextensions.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 07:46 vision_apps.xml
[applvision@apps admin]$ mv vision_apps.xml vision_apps.xml_27sep2013
[applvision@apps admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/apps/vision/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /apps/vision/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
Database Host [apps]:
Database Host Domain [innovation.com]:
Database Port [1521]:1526
Database SID:vision
APPS Schema Name [APPS]:apps
APPS Schema Password:apps
The following context files are available:
[1] vision_apps (APPL_TOP Context)
[2] vision_apps (Database Context)
Select the context to retrieve [1]:1
Destination file path [/apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml]:
Retrieved context file to /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
Log file location: /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
[applvision@apps admin]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 08:00 /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
[applvision@apps admin]$ date
Sat Sep 28 08:00:23 IST 2013
[applvision@apps admin]$
++++++++++++++++++++++
To re-build database tier context file follow below syntax.
[dbvision@apps bin]$ perl /db/vision/db/tech_st/11.1.0/appsutil/bin/adbldxml.pl appsuser=apps appspass=apps template=/db/vision/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp out=/db/vision/db/tech_st/11.1.0/appsutil
Thanks for visiting my blog !!!!!!!!!!
=============
Let's create senario
==============
/apps/vision/inst/apps/vision_apps/appl/admin
[applvision@apps admin]$ ls -tlrh
total 120K
-rw-r--r-- 1 applvision applmgr 11K Sep 28 07:43 adovars_vision_apps.env
-rw------- 1 applvision applmgr 7.0K Sep 28 07:44 ojspCompile.properties
-rw------- 1 applvision applmgr 3.3K Sep 28 07:44 ojspCompile.conf
-rw------- 1 applvision applmgr 1010 Sep 28 07:44 oamextensions.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 07:46 vision_apps.xml
[applvision@apps admin]$ mv vision_apps.xml vision_apps.xml_27sep2013
[applvision@apps admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/apps/vision/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /apps/vision/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext
Log file located at /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
Database Host [apps]:
Database Host Domain [innovation.com]:
Database Port [1521]:1526
Database SID:vision
APPS Schema Name [APPS]:apps
APPS Schema Password:apps
The following context files are available:
[1] vision_apps (APPL_TOP Context)
[2] vision_apps (Database Context)
Select the context to retrieve [1]:1
Destination file path [/apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml]:
Retrieved context file to /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
Log file location: /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
[applvision@apps admin]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 08:00 /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
[applvision@apps admin]$ date
Sat Sep 28 08:00:23 IST 2013
[applvision@apps admin]$
++++++++++++++++++++++
To re-build database tier context file follow below syntax.
[dbvision@apps bin]$ perl /db/vision/db/tech_st/11.1.0/appsutil/bin/adbldxml.pl appsuser=apps appspass=apps template=/db/vision/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp out=/db/vision/db/tech_st/11.1.0/appsutil
Lage raho Wasiq Bhai
ReplyDeleteAsak wasiq bhai,
ReplyDeleteMay i know wot is difference between adbldxml.pl and adclonectx.pl ?
Hi abdul,
ReplyDeleteIts nice and useful info.
Hope this may also useful here for DBA.
https://ora-data.blogspot.in/2016/11/how-to-create-or-rebuild-context-file.html
Thanks,
i have r12.1.3 apps backup with db 11gr1 ( it is OEL 5.8)
ReplyDeletei want to clone this APPS + DB backup ON OEL 6 with new hostname
WHEN I RUN
perl adcfgclone.pl dbTier
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
i have downloaded this patch : Patch 9171651: 12.0 RAPIDCLONE CONSOLIDATED FIXES JUL/2010
but in my case
im restoring apps and db backup on oel6 with different hostname.
obviously APPSCONTEXT_NAME.env files wil not work at this point.
plz can you suggest some solution ?