5903765--> 11i.ATG_PF.H.RUP6
DOC-ID--> 444524.1
PREREQUISTE:
Step 1   Upgrade the RDBMS to Oracle 9iR2/10g or higher (Required)
Step 2    Apply the AD minipack. (Conditionally Required)
          PATCH 6502082=Patch 11i.AD.I.6
Step 3    Run the Technology Stack Validation Utility. (Required)
#  From the location where this patch was unzipped, change directory to fnd/patch/115/bin. 
cd 5903765
# Run the utility as follows: 
./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps 
enable maintainance mode
adpatch driver=u5903765.drv  logfile=5903765.log
check the invalid objects=36524
(wheather patch hanged check tablespace fnd_install_processes)
workers failed 1and4,
bneint.ldt 
bneparamlist.ldt
preinstallation patch=3218526(before this apply 4252319)
                      
docid=287080.1
PATCH=4252319
adpatch driver=u4252319.drv
compile apps schema
Compile flexfield data in AOL tables
Restart Oracle Webserver Middle Tier environments
5903765 (adpatch driver=u5903765.drv  logfile=5903765.log)
FAILED: 
    file ademusr.sql  on worker  1 for product ad  username APPLSYS.
Completed: 
     
     file aftcm049.sql on worker  3 for product
fnd username APPLSYS.
ATTENTION: All workers either have failed or are waiting:
           FAILED: file ademusr.sql
 on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
429498.1(Fails on ademusr.sql )
patch=5989593---(REVOKE ALL FROM PUBLIC" From adgrants.sql as pre-requisite.)
Run the adgrants.sql script as a user that can connect as SYSDBA to grant
privileges to selected SYS objects
and create PL/SQL profiler objects.
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql
   (UNIX) from the patchtop(5989593)/admin directory to
   $ORACLE_HOME/appsutil/admin. Or, copy adgrants_nt.sql (Windows) from
   patchtop(5989593)\admin to %ORACLE_HOME%\appsutil\admin.
3.Set the environment to point to ORACLE_HOME on the database server.
4.
    Use SQL*Plus to run the script:
     UNIX:
       $ sqlplus /nolog
       SQL> connect / as sysdba
       SQL>
PATCH 3865683=RELEASE 11.5.10 PRODUCTS NAME PATCH
Tuesday, July 15, 2008
How To Apply 11i.ATG_PF.H.RUP6
Posted by V.R.Kishore Reddy at 03:35
