Tuesday, July 15, 2008

How To Apply 11i.ATG_PF.H.RUP6

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