Apps DBA Concepts

Just another WordPress.com weblog

Archive for the ‘AD tools’ Category

How to merge two apps patches.

Posted by vasselva on January 21, 2008

Merging apps patches will be useful when you want to reduce the downtime for patch application

Simple steps to merge two patches.

  1. Download two required apps patches (pR12_xxxxx_Solaris.zip) and (P12_yyyyy_Solaris.zip).
  2. Create one source directory (for e.g. src )
  3. Unzip two apps patches into src directory.
  4. Create one destination directory (for e.g. dest)
  5. Source the Apps env and issue the following command.
    1. Perl <ad_top>/bin/admerge.pl –s src –d dest
  6. Patch is merged and created u_merged.drv . Use this driver file for adpatch application

Posted in AD tools | Leave a Comment »

How do I recover the Applications context file if it is lost or deleted accidentally?

Posted by vasselva on March 29, 2007

A gem is not polished without rubbing, nor a man perfected without trials.
Chinese Proverb

The Applications context file can be retrieved by running the adclonectx.pl script.

To retrieve the Applications tier context file,

  • perl /clone/bin/adclonectx.pl retrieve
  • On being prompted for the context file to be retrieved, select the option of retrieving the Applications tier context file that has been lost and retrieve it to the default location specified by the script.

The above command can be used only when INST_TOP the is still intact. In case the has also been lost accidentally, the Applications tier context file may be retrieved as follows:

  • Execute the following command on the Database tier:
    perl /appsutil/clone/bin/adclonectx.pl retrieve
  • On being prompted for the context file to be retrieved, select the option of retrieving the Applications tier context file that has been lost.
  • While confirming the location for the context file, set it to any existing directory with write permission.
  • Once the context file has been generated in the specified location, move it to the location specified for the context file in the context variable ‘s_contextfile’.

To retrieve the Database tier context file,

  • Execute the following command on the Database tier:
    perl /appsutil/clone/bin/adclonectx.pl retrieve
  • On being prompted for the context file to be retrieved, select the Database tier context file and retrieve it to the default location specified by the script.

Best Practice
Retrieve the context file from database tier . It will be very easy and only few steps needs to be answered

Posted in AD tools | Leave a Comment »