Forgot your password?    
+ Reply to Thread
Results 1 to 6 of 6

Thread: admrgpch - Merge multiple Patches

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    admrgpch - Merge multiple Patches

    ADMRGPCH is a utility to merge two or more patches into a single merged patch.
    This executable is located in AD_TOP/bin

    To run AD Merge Patch with the following arguments

    $ Admrgpch [source directory] [destination directory]

    Source directory - Where patches to merge have been unloaded.

    Destination directory – Where the unified patch will be created.


    AD merge patch creates the merged patch driver files by the name umerged.drv and copies the actual files needed by the merged patches into the destination directory.
    Actions in the merge patch are grouped by product then by patch number.

    eg:-

    $admrgpch /u01/patch/source /u01/patch/destination

    /u01/patch/destination will contain the merged patch files and driver file.

    Log file located in the current directory where we run the admgrpch. The default log file name is admrgpch.log.

    To specify the name of the merged patch drivers, run AD merge patch with
    $ admrgpch -s [source directory] -d [destination directory] -merge_name [name]

  2. #2
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    During Patching you shutdown CM , What happen to running Concurrent Manager request???

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    During patching you need to close all other services also, it means you can not work with your EBS if you are doing patching.

    Occasionally, you may find that requests are stacking up in the concurrent managers with a status of "pending". This can be caused by any of these conditions:

    1. The concurrent managers were brought down while a request was running.
    2. The database was shutdown before shutting down the concurrent managers.
    3. There is a shortage of RAM memory or CPU resources.

    When you get a backlog of pending requests, you can first allocate more processes to the manager that is having the problem in order to allow most of the requests to process, and then make a list of the requests that will not complete so they can be resubmitted, and cancel them.

    If the Concurrent managers were brought down, while an outstanding request was still running in the background. and the request was in a phase of RUNNING and a status of TERMINATING. In which case, Update the FND_CONCURRENT_REQUESTS table as APPLSYS user as follows:
    .
    sql> update fnd_concurrent_requests
    set status_code='X', phase_code='C'
    where status_code='T';
    sql> commit;

    Regards

  4. #4
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    tnx a lot for your reply,

    Like we can hold pending concurrent requests instead of terminating them.So how can we do that?If we put it on hold then i think it would be better instead of terminating??Just asking you...if its possible?? will wait for your valuable reply..
    tnx,
    sai.

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    When shutting down the concurrent manager there may be any FNDLIBR processes still running at the OS level? If so, do a kill -9 on them. If you forget then pending request will start pilling up.

    Regards

  6. #6
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Sai,

    For running concurrent requests, the only option is to terminate them, while bringing down the CM's.Through by killing FNDLIBR OS process or by updating fnd_concurren_requests table for running requests.

    For Pending request, you can put them on hold.Normally when you bring down the CM's the Pending request goes on Inactive phase.So it is always advisable to put the pending requests on hold before bringing down the CM's and after the maintenance when bring up the CM's than release the hold from pending requests.

    Hope this helps.

    Please always start a new thread or update the existing relevant thread.Please maintain the form standard!!!
    Last edited by Amit; 05-08-2012 at 12:38 PM.
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. ADMERGE : What kind of patches we can merge through ADMERGE
    By deepakgupta in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 02-29-2012, 04:13 PM
  2. CPU Patches
    By vineettyagi in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 02-17-2012, 12:28 PM
  3. Multiple SQLs to Diagnose PGA issues at runtime
    By Hemant in forum Database Scripts
    Replies: 0
    Last Post: 11-02-2011, 07:24 PM
  4. Cloning Oracle Applications from Multinode to Single Node - Merge APPL_TOP
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-01-2011, 01:13 PM
  5. Types of Patches
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-01-2011, 10:38 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics