Oracle Apps Upgrade


Upgrade Apps 11i to R12.1.1 Steps on OEL4.6 

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.

  

Step by step process 11i to R12.1.1


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

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

**************************************************************************


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

*********************************************************************** 

                     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 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 ~]$ 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
  




********************************************************************


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

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



1 comment:

Unknown said...

Hello Sujeet bro, Your blog is really awesome especially for beginners like me., I request you to provide me a doc for EBS upgrade from 12.1.3 to 12.2 .,plz provide it

Thanks,
Nagaraj.

ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE

 Error:- IEX: Scoring Engine Harness Error - ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE (Doc ID 2056754.1) SYMPTOMS:- Yo...