Friday 27 September 2013

Rebuild/Re create context file in oracle apps R12.

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 !!!!!!!!!!

4 comments:

  1. Asak wasiq bhai,

    May i know wot is difference between adbldxml.pl and adclonectx.pl ?

    ReplyDelete
  2. Hi abdul,
    Its 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,

    ReplyDelete
  3. i have r12.1.3 apps backup with db 11gr1 ( it is OEL 5.8)

    i 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 ?

    ReplyDelete