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:-
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
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 :
SQL> SELECT COUNT(*)
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 Steps
1] 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 ~]$ cd /setup/patches/7461070
[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************************************


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