How To Apply ADI-6 Patch

APPLY ADI-6 PATCH:


Download patch 6502082


Open read me 233044.1


Check for pre requisites:


Before apply patch down the apps server and enable maintenance mode


----To check weather maintenance mode enabled


select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;



Before apply patch check for system requirements:


 Perl executable



You must have the Perl executable (5.004 minimum; 5.005 perferred) in your PATH

before you apply this minipack. You should have already installed Perl as part of

your iAS ORACLE_HOME. See http://www.cpan.org for information on obtaining Perl.



 FNDLOAD executable



Ensure all application tier server nodes contain the FNDLOAD executable in the

$FND_TOP/bin directory


Unzip apps.zip under $JAVA_TOP on all application tier nodes, if you have not done so already.



Convert to Multiple Organizations



Oracle Applications strongly recommends that you convert to Multi-Org as soon as

possible so that you will be prepared for improvements to performance across the

E-Business Suite as well as support for Multi-Org Access Control.


see Release 11i Use of Multiple Organizations in Oracle Applications (OracleMetaLink Document 210193.1). related doc284046 and 2451368




Apply the Minipack:


Adpatch driver=.drv logfile=.log



Check for invalid objects before applying patch and check after apply patch by using following command




--To check the Invalid Objects


SELECT count(1) FROM dba_objects WHERE status='INVALID';


$FND_TOP /patch/115/sql/afoppool.sql (for compile queue objects)



--To Recompile Invalid Objects



EXEC SYS.UTL_RECOMP.RECOMP_PARALLEL(8);



Post-minipack Steps:


Step 1: Grant privileges and create PL/SQL profiler objects



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 $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from %APPL_TOP%\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> @$ORACLE_HOME/appsutil/admin/adgrants.sql



Windows:


     C:\> sqlplus /nolog

     SQL> connect / as sysdba

     SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql




Step 2: Unzip apps.zip under $JAVA_TOP (conditionally required)



If you have already unzipped apps.zip, go on to Step 3.


Verify whether apps.zip has been unzipped. If the file exists in your $JAVA_TOP directory, it has not been unzipped. If it doesn't exist in $JAVA_TOP, it has already been unzipped.


Step 3: Run AutoConfig