R12 Upgrade
Upgrade R12.1.1
to R12.1.3 Steps on Linux Server.
Upgrade R12.0.4
to R12.1.1 Steps on Linux Server.
Upgrade R12.1.1
to R12.1.3 Steps.
**************************************************************************
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
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_HOM
[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*******************************
Upgrade R12.0.4 to R12.1.1
Upgrade
R12.0.4 to R12.1.1 Steps on Linux Server
Below is the overview of what all steps we performed. This is Linux Operating system.
PRESENT SERVER INFO:-
Below is the overview of what all steps we performed. This is Linux Operating system.
PRESENT SERVER INFO:-
OS: - RHEL5.4
(32bit)
Application: -
R12.0.4
Database: - 10g
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
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.0.4
Please check the invalid objects after and before each step.
Applying
Patches can create invalid objects. To get a quick count of the number of
existing invalids
(if any), use the following select statement :
(if any), use the following select statement :
SQL> SELECT
COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID';
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID';
Database
Upgrade : 10.2.0.3 to 10.2.0.4
A] Applying 10204 patchset 3 on existing oracle home.
1] Set the inventory in /etc/oraInst.loc .
2] unzip 6810189 patch with owner of database.
3] cd Disk1 >> ./runInstaller
4] Source the oracle home path which needs to be upgraded.
>> Post Patches [5868257 , 5386204] on upgraded home. [ using opatch]
B] Upgrade Steps
1] Login as database user. [ and sqlplus "/as sysdba"]
2] startup upgrade.
3] cd $OH/rdbms/admin
@utlu102i.sql
4] @catupgrd.sql
5] Run utlrp.sql for compiling invalid objects.
6] Check dba_registry for status [ must be VALID for all Components ]
7] Shutdown immediate.
8] Startup.
C] Post Steps1] Run adgrants.sql [$ORACLE_HOME/appsutil/admin ]
sqlplus “/as sysdba” @adgrants.sql applsys
2] Run adstats.sql [ database should be restrict mode ]
Applications Upgrade : 12.0.4 to 12.1.1
Prereq :>> Check for Invalid objects
>> Bring down the Application.
>> Enable Maintenance Mode.
A] Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 4 (10.1.3.4):1] Apply patches : 7237313, 7359933 + opatches [ review from document
mentioned below]
B] Upgrade Oracle E-Business Suite Release 12 JDK to Java 6.0 latest update.
Download Java SE Development Kit 6u13 (jdk-6u13-linux-i586-rpm.bin)
from http://java.sun.com/javase/downloads/index.jsp
C] Upgrade OracleAS 10g Release (10.1.2) for Forms and Reports to
Patchset 3 (10.1.2.3)
1] Apply patch 5983622
2] Post Patches [opatch ] reviewed from Metalink note-id mentioned below.
3] Apply Interop patch 7120543 on 10.1.2.3 Home
D] Apply the AD Minipack : 7461070
A] Applying 10204 patchset 3 on existing oracle home.
1] Set the inventory in /etc/oraInst.loc .
2] unzip 6810189 patch with owner of database.
3] cd Disk1 >> ./runInstaller
4] Source the oracle home path which needs to be upgraded.
>> Post Patches [5868257 , 5386204] on upgraded home. [ using opatch]
B] Upgrade Steps
1] Login as database user. [ and sqlplus "/as sysdba"]
2] startup upgrade.
3] cd $OH/rdbms/admin
@utlu102i.sql
4] @catupgrd.sql
5] Run utlrp.sql for compiling invalid objects.
6] Check dba_registry for status [ must be VALID for all Components ]
7] Shutdown immediate.
8] Startup.
C] Post Steps1] Run adgrants.sql [$ORACLE_HOME/appsutil/admin ]
sqlplus “/as sysdba” @adgrants.sql applsys
2] Run adstats.sql [ database should be restrict mode ]
Applications Upgrade : 12.0.4 to 12.1.1
Prereq :>> Check for Invalid objects
>> Bring down the Application.
>> Enable Maintenance Mode.
A] Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 4 (10.1.3.4):1] Apply patches : 7237313, 7359933 + opatches [ review from document
mentioned below]
B] Upgrade Oracle E-Business Suite Release 12 JDK to Java 6.0 latest update.
Download Java SE Development Kit 6u13 (jdk-6u13-linux-i586-rpm.bin)
from http://java.sun.com/javase/downloads/index.jsp
C] Upgrade OracleAS 10g Release (10.1.2) for Forms and Reports to
Patchset 3 (10.1.2.3)
1] Apply patch 5983622
2] Post Patches [opatch ] reviewed from Metalink note-id mentioned below.
3] Apply Interop patch 7120543 on 10.1.2.3 Home
D] Apply the AD Minipack : 7461070
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.
|
|
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>
|
|
Apply patch
[applmgr@gayatri10 ~]$ adpatch
Driver=u7461070.drv
Workers=8
adpatch defaults
file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt
log file=u7461070.log
Patch Apply sucessesfull….
|
E] Apply EBS
Maintenance Pack : 7303030
[applmgr@gayatri10
~]$ cd /setup/patches/7303030
[applmgr@gayatri10
~]$ adpatch
Driver=u7303030.drv
Workers=8
adpatch defaults
file=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt
log file=u7303030.log
Patch Apply sucessesfull….
F] 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
G] 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
I] 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
Follow Post steps from 752619.1
********************************END************************************
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
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....
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
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************************************
Recently I have made complete iteration from fresh PROD 11i
instance to R12.1.1 with
database 11.2.0.2
I have used VMware for this iteration, the following step
involved to achieve this upgrade
from 11i to R12.1.1
OS Version:- OEL 4.6
Physical Memory:- 3GB
Application:- 11i CU2
Database:- 9.2.0.6
Physical Memory:- 3GB
Application:- 11i CU2
Database:- 9.2.0.6
My VMware installation has been running on P5 processor with 4GB memory under
Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled
procedure prior to this step.
The following steps performed successfully to complete this
hectic upgrade from
11i instance to R12.1.1
• Upgrade 9.2.0.6 to 10.2.0.4
– Patches applied before 10g upgrade are 5478710, 4676589,
4653225
– Changed some of the OS kernel parameters
– Created new oracle home directory
– Installed 10gR1 (software only)
– Installed 10gR1 companion CD
– Installed 10g patch set 3 (10.2.0.4)
• Configuration section for 10g
– Created nls/data/9idata
– Run the script cr9idata.pl
– Copied environment file from 9i home to 10g home and made
changes to reflect the
directory structure of 10g home
– Copied TNS_ADMIN directory from 9i to 10 home and made
changes according to new home
– Copies admin directory from 9i to 10g home and make necessary
changes
– Shutdown 9i database and listener
– Startup 10g listener
– Upgraded 9i to 10g using dbua from 10g home
• Shutdown database and listener
• Create temporary tablespace
• Apply RDBMS Patches
• Fix Korean Lexers
• Run Adgrants.sql
• Grant create procedure privilege on CTXSYS
• Implement and run Autoconfig
• Gather statistics for SYS schema
• Recreate grants and synonym for apps
• Restart application server process
• Preparing for the Upgrade R12.1.1
– Apply AD.I.6
– Apply TUMS utility
– Run AD preparation scripts
Backup database and applications
• Startup 11i Instance
• Check for Invalid Objects etc...
• Create R12 application user
• Create R12 Base folder
• OS Kernel setting etc
• (Refer Metalink: 761564.1 - Oracle E-Business
Suite Installation and Upgrade
Notes R12.1.1 for Linux x86)
• Installation of R12.1.1 applications
• Enable maintenance mode in R12
• Apply AD 12.1.1 upgrade driver (7461070)
• Source the R12 Applications environment file
• Run the Patch Application Assistant
• Run the adgrants.sql
• Apply patch
• Re-Create grants and Synonyms
• Compile APPS schema
• Modify tablespace
• Run the American English upgrade patch driver 6678700
• Review patch history and timing
• Install R12.1.1 again for configuration purpose
• Startup / shutdown applications and database
• Try with autoconfig in both tiers
• Restart services
•
Upgrade 10.2.0.4 to
11.2.0.2
• Patches applied before 11gR2 upgrades are 9062910, 8919489,
9868229, 10024524
• Autoconfig latest version with 9852070 and 9738085
• OS kernel parameters for 11gR2
•
Created new oracle home directory
Installed 11gR2 (software only)
• Installed 11g Examples CD
• Configuration section for 11gR2
• Created nls/data/9idata
• Run the script cr9idata.pl
• Copied environment file from 10g home to 11g home and made
changes to reflect the
directory structure of 11g home
• Copied TNS_ADMIN directory from 10g to 11g home and made
changes according to
new home
• Copies admin directory from 10g to 11g home and make
necessary changes
• Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223
• Shutdown 10g database and listener
• Startup 11g listener
• Run DBUA
• Perform post-install instructions
• Run adgrants.sql
• Grant create procedure privilege on CTXSYS
• Set CTXSYS parameter
• Validate Workflow ruleset
• Implement and run AutoConfig in the new Oracle home on the
database server node.
• Gather statistics for SYS schema
• Re-create grants and synonyms
• Restart Applications server processes
• Synchronize Workflow views
***************************************END********************************************
No comments:
Post a Comment