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