Applications
Upgrade R12.0.4
to R12.1.1 to R12.1.3 steps
Upgrade R12.0.4
to R12.1.1
Below is the overview of what all steps we performed. This is Linux Operating system.
Step:-1
Step:-1
PRESENT SERVER INFO:-
OS: - RHEL5.4 (32bit)
Application: - R12.0.4
Database: - 10g
SID: - VIS
Hard-disk: - 500
RAM: - 6 GB
Down-Time:-48 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
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
Step:-2
Check Apps Version:-
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.0.4
Step:-3
Download Patch:-
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....
- Patch 7461070 (p7461070_R12_LINUX.zip)
2. Patch 7303030
(12.1.1 maintenance pack)
Unzip both Patch:-
7461070
7303030
Step:-4
Apply the AD Minipack
(Required)
Use AutoPatch to
apply R12.AD.B.1 Patch 7461070. Do not merge this patch with any other patch. R12.AD.B.1 must be applied
separately.
Refer to Oracle Applications DBA Update Pack for Release
12.1.1 Readme Note
760167.1 for more information about R12.AD.B.1..
|
Pre-install Tasks
You must shut down all Application tier services before performing the
tasks in this section.Step:-5
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:-6
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:-7
|
|
Instructions for running AD Grants
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.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from this patch directory 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> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>
Windows:
C:\> sqlplus /nolog
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql <APPS schema name>
Step:-8
|
|
Apply patch 7461070
|
adpatch defaults file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt log file=u7461070.log
Patch top=/home/test/patches/7461070
Driver=u7461070.drv
Workers=8
Patch Apply sucessesfully….
Step:-9
Applying the Maintenance Pack Patch 7303030.
Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation
12.1.1 maintenance pack Patch 7303030.
Use AutoPatch to apply Release 12.1.1 Patch 7303030 and follow the instructions in the patch
readme file.
Note: Refer to Note
761570.1 to ensure that all patches for your specific database
release are applied on the environment.
Apply patch 7303030
adpatch defaults file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt log file=u7303030.log
Patch top=/home/test/patches/7303030
Driver=u7303030.drv
Workers=8
Patch Apply sucessesfully….
Step:-10
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:-11
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:-12
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.1
Applications Upgrade R12.1.1 to R12.1.3 steps
Step:-13
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:-14
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:-15
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:-16
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:-17
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:-18
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:-19
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:-20
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:
Post a Comment