Upgrade R12.1.1 to R12.1.3 Steps

Step:-1 

Present Server Info:-

OS: - RHEL5.4 (32bit)
Application: - R12.1.1
Database: - 11g
SID: - VIS
Hard-disk: - 500
RAM: - 6 GB
Down-Time:-24 Hours
Server status:- up & Running
How to check Server info :-( Linux)
Check Os Version:-
[root@sujeet ~]# cat /proc/version
RHEL5.4
[root@sujeet ~]# getconf LONG_BIT
32
Check Hard-disk & Free Space:-
[root@sujeet ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3             222G   99G  113G  47% /
/dev/sda1              99M   12M   83M  12% /boot
tmpfs                 995M   12K  995M   1% /dev/shm
Check Physical Memory :-(swap)
[root@sujeet ~]$ grep MemTotal /proc/meminfo
MemTotal:      3036792 kB
[root@sujeet ~]#   grep SwapTotal /proc/meminfo
SwapTotal:     12192956 kB
   
Check Apps Version:-
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.1 
Step:-2
Download Patch:-
1. 9239089 (AD-Code-Level change Patch B.1 to B.3)
2. 9239090 (Upgrade main Patch R12.1.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 all the patches
p9239090_R12_LINUX_1of6.zip
p9239090_R12_LINUX_2of6.zip
p9239090_R12_LINUX_3of6.zip
p9239090_R12_LINUX_4of6.zip
p9239090_R12_LINUX_5of6.zip
p9239090_R12_LINUX_6of6.zip
p9239089_R12.AD.B_R12_LINUX.zip
Unzip the patches
9239090
9239089
Step:-3
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.
 Enable maintenance mode:-
[applmgr@gayatri10 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[applmgr@gayatri10 appl]$ . APPSPROD_gayatri10.env
[applmgr@gayatri10 appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@gayatri10 appl]$ adadmin
menu option=ENABLE_MAINT_MODE
defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log
Step:-4
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:-5
Apply Patch 9239089
pre install 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:-6
Apply patch 9239090
Prereq:-
Patch - R12.AD.B.delta.3 (9239089) - already applied
Patch top=/setup/patches/9239090
­­­
[applmgr@gayatri10 ~]$ cd /setup/patches/9239090
[applmgr@gayatri10 ~]$ adpatch
Driver=u9239090.drv
Workers=8
adpatch defaults file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt
log file=u9239090.log
Patch Apply sucessesfull….
Step:-7
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 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log
Step:-8
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
Step:-9
 Login as APPS user:-

[applmgr@gayatri10 scripts]$ sqlplus
Enter User id :apps/apps 

SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)
****************************************END*******************************

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...