In Oracle : Applying the last version of the Oracle AD.I

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Applying the last version of the Oracle AD.I

 

 Applying the last version of the Oracle AD.I

 

 

1. Why is recommended to have applied the last version of the AD.I ?

2. What is the AD.I I use currently ?

3. How Could I install/apply the last AD.I version ?

4. Verify again the current version of the AD.I

 

 

1. Why is recommended to have applied the last version of the AD.I ?

 

This minipack provide you with the last version of the Oracle Applications DBA utilities. Theoretically there are less bugs in the last AD version, so is preferred to use the last AD version.   

2. What is the AD.I I use currently ?

 

col Application_Name format a45
col PATCH_LEVEL format a12
 


SELECT fa.application_name "Application_Name",
               fpi.patch_level           Patch_Level
FROM fnd_application_all_view      fa, 
            fnd_product_installations   fpi
WHERE fa.application_id = fpi.application_id
    AND fpi.patch_level like '%AD.I%' ;

 

The current version of AD.I

 

 

3. How Could I install/apply the last AD.I version ?

 

 

To be sure that the patch is applied successfully, please see the Metalink Note 233044.1

 

For an initial full 11.5.10.2 Oracle Apps version on Oracle Linux Unbreakable (RH kernel) here are the steps I followed:

 

A) Prerequisites 

 

Nothing to do. 

 

B) APPLY the Minipack

 

Apply the last AD.I patch. In my case the last AD.I patch is 6502082 (for the AD.I.6). 

 

C) Post-minipack Steps 

 

  a)  Create $ORACLE_HOME/appsutil/admin on the database server. 
       $ mkdir $ORACLE_HOME/appsutil/admin 

  b) Copy adgrants.sql (UNIX) from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin.  

      (For Windows :adgrants_nt.sql ) 

      

  c) Source the database environment 

     In my case:

     . /APPS_DB/visdb/9.2.0/VIS_db.env

 

  d) Run adgrants.sql   

      [oracle@DB appsutil]$ sqlplus /nolog
      SQL*Plus: Release 9.2.0.6.0 - Production on Sat Apr 19 12:29:34 2008
      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

      SQL> connect / as sysdba
      Connected.
      SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql  APPLSYS

 

   e) Unzip apps.zip under $JAVA_TOP (conditionally required)

       

       [applmgr@apps /]$ cd $JAVA_TOP
       [applmgr@apps java]$ pwd
       /APPS_MI/viscomn/java
       [applmgr@apps java]$ ls | grep apps.zip
       apps.zip.bak

       Because the apps.zip have been already unzipped (if the file wasn't unzipped the file must be there), go on to Step f). 

 

       NOTE: 

       If you are unzipping apps.zip as a post-minipack step, you must apply patch (5161676). This patch includes a driver file 

       (explode.drv) that unzips apps.zip. If you do not apply this patch, the Maintain Snapshot functionality will not work correctly. 

   f) Run AutoConfig

 

      If your system is enabled to use AutoConfig, run AutoConfig to instantiate the templates used by the AD utilities

      After you apply this minipack, AutoPatch automatically runs AutoConfig during each patch session; however you can run the AutoConfig again if you want. 

 

    
4. Verify again the current version of the AD.I

 

The current version of AD.I

 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Applying the last version of the Oracle AD.I

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.