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:-

http://support.oracle.com/

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*******************************