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:-
http://support.oracle.com/
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:- 
http://support.oracle.com/
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:- 
http://support.oracle.com/
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.

25 April 2014 at 15:01

Post a Comment

Subscribe to: Posts (Atom)

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...