How to apply Patch on R12.1.1 Steps



NOTE:-Application Patch Steps depend on patch to patch steps are different. Its general step which is following.........

Step:-1
Download Patch:-
Patch depend on your application version & OS version..
1. 9239089 (AD-Code-Level change Patch B.1 to B.3)

Open Link:-
Open Oracle Support Window
Click on Sign In Link
Open login page
Enter Metalink user/Password
Open New Window
Click on Patch & Update Tab
 Search patch number>
Enter Patch Number>get link>Click on this link
Download start....

Download patch
p9239089_R12.AD.B_R12_LINUX.zip

Unzip the patches
9239089
This is location of patch:-
Patch top=/home/test/patches/9239089

NOTE:-Plz read readme.txt or readme.html file carefully before applying patch and follow these steps which mansions in this file....

NOTE: - Use Auto Patch to apply R12.AD.B.DELTA.3 Patch 9239089, before you complete any of the other steps in this section. Do not merge this patch with any other patch. R12.AD.B.Delta.3 must be applied separately.

Step:-2
Enable maintenance mode:-
Login as Apps user/password:-
[applmgr@gayatri10 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[applmgr@gayatri10 appl]$ . APPSPROD_gayatri10.env
 [applmgr@gayatri10 appl]$ cd $ADMIN_SCRIPTS_HOM
[oracle@ebs602 scripts]$ adadmin

                    Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, US
                       Oracle Applications AD Administration
                                          Version 12.0.0

    NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

 Your default directory is '/oracle/VIS/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?
<Press Enter>

 AD Administration records your AD Administration session in a text file
you specify.  Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.
 
Filename [adadmin.log] : patch1.log <You can change log file name also,hear I change log file name=patch1.log>

 Do you wish to activate this feature [No] ?
<Press Enter>

************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Mon Apr 20 2009 11:00:24

 Please enter the batchsize [1000] :
<Press Enter>

 Is this the correct database [Yes] ?
<Press Enter>

 AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

 Enter the password for your 'SYSTEM' ORACLE schema: 
manager

Enter the ORACLE password of Application Object Library [APPS] :  <Press Enter>
........................................
 Saving product information.
 AD code level : [B.1]

   AD Administration Main Menu
   --------------------------------------------------


   1.    Generate Applications Files menu


   2.    Maintain Applications Files menu


   3.    Compile/Reload Applications Database Entities menu


   4.    Maintain Applications Database Entities menu


   5.    Change Maintenance Mode


   6.    Exit AD Administration


 Enter your choice [6] :
5

 Change Maintenance Mode
   ----------------------------------------
 Maintenance Mode is currently: [Disabled].

Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
 Please select an option:


   1.    Enable Maintenance Mode


   2.    Disable Maintenance Mode


   3.    Return to Main Menu


Enter your choice [3] : 1


1. Enable Maintenance mode

defaults log-file =$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log

Step:-3
Down Application Tier:-
[applmgr@gayatri10 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[applmgr@gayatri10 appl]$ . APPSPROD_gayatri10.env
[applmgr@gayatri10 appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@gayatri10 scripts]$ ./adstpall.sh apps/apps
 Step:-4
Apply Patch 9239089
pre install steps :-
<Plz read readme.txt file & follow all steps>
1. Create $ORACLE_HOME/appsutil/admin on the Database-Tier.

mkdir -p $ORACLE_HOME/appsutil/admin

2. Copy adgrants.sql  from this patch directory to
$ORACLE_HOME/appsutil/admin.

 3. Set the environment to point to ORACLE_HOME on the database-Tier.

4. Use SQL*Plus to run the script:
$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

adpatch defaults file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt log file=u9239089.log

Patch top=/home/test/patches/9239089
Driver=u9239089.drv
Workers=8
Patch Apply sucessesfully….

Step:-5
Disable Maint-Mode:-
[applmgr@gayatri10 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[applmgr@gayatri10 appl]$ . APPSPROD_gayatri10.env
[applmgr@gayatri10 appl]$ cd $ADMIN_SCRIPTS_HOM
[applmgr@gayatri10 appl]$adadmin

menu_option=DISABLE_MAINT_MODE

adadmin defaults log-file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log

Step:-6

Start Application Tier:-
[applmgr@gayatri10 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[applmgr@gayatri10 appl]$ . APPSPROD_gayatri10.env
[applmgr@gayatri10 appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@gayatri10 scripts]$ ./adstrtal.sh apps/apps
Use Application …..................
******************************************END******************************************************

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...