How I upgrade our Oracle EBS from R12.1.1 to 12.1.3

SkySys - Oracle Applications EBS 12.1.3 Login page

SkySys - Oracle Applications EBS 12.1.3 Login page


To describe the procedure I have followed in upgrading our Oracle EBS Release 12.1.1 to 12.1.3. While the procedure mentioned in this blog are the exact steps I have followed (including the commands issued) the best document to read about the upgrade is Oracle support note 1080973.1.

Our Oracle Server current configuration:-

a. Hardware and host environment:-

> Base server:  Windows 7 Professional 64-bit, CPU = Intel Core i7-2600 @3.40GHz, RAM = 16.0 GB

> VMware platform on top of Windows 7:- VMware Server 2.0.2

> Virtual machine specifications:-

  Operating system type = Red Hat Enterprise Linux 4 (32-bit)

  HDD space allocated = 400GB

  RAM allocated = 8.0 GB

b. Oracle EBS server (current) – Vision instance

 hostname =  (alias “ls1″)

 Installation home = /home/oracle/VIS

 Oracle Database version =

  Applications Release name/version = 12.1.1

Upgrade procedure followed:-

1. I have downloaded following patches and extracted into /home/oracle/R12-Patches directory.


2. Stopped all application tier services.

$ /home/oracle/VIS/inst/apps/VIS_ls1/admin/scripts/ apps/******

I kept the Oracle Enterprise Manage DB console service running as it helped me monitor the database performance, tablespaces health, etc.

3. Switched the instance into maintenance mode.

$cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=4

4. Run adgrants.sql as a pre-requisite for the first patch 9239089

– “adgrants.sql” is a file extracted out of 9239089 patch. Copied this sql script into $ORACLE_HOME/appsutil/admin directory.

$ cd /home/oracle/VIS/db/tech_st/11.1.0/appsutil/admin

$ sqlplus /nolog

SQL> @adgrants.sql apps

—- adgrants.sql executed and database changes committed.

SQL> exit

5. Applied the first patch 9239089.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=/home/oracle/VIS/R12-Patches/9239089 driver=u9239089.drv workers=8

6. Applied the second patch 9239090.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=/home/oracle/VIS/R12-Patches/9239090 driver=u9239090.drv workers=8

The 9239090 patch ran for nearly 12 hours. There was an incident when one of the workers has failed and I have to skip the job (worker) by using “adctl” utility.

7. Applied the next patch 9239095.

$ /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=/home/oracle/VIS/R12-Patches/9239095 driver=u9239095.drv workers=8

Now moved on to the post update steps:-

8. Applied the mandatory post-install patch 981770.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=/home/oracle/VIS/R12-Patches/9817770 driver=u9817770.drv workers=8

9. Applied the second mandatory post-install patch 9966055.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=/home/oracle/VIS/R12-Patches/9966055 driver=u9966055.drv workers=8

10. Updated the DB tier with the EBS 12.1.3 code level

$ cd $APPL_TOP

$ . APPSVIS_ls1.env

> Executed the utility to create the

$ cd $AD_TOP/bin


> As the outcome of the above script the got created into the $INST_TOP/admin/out directory.

> Copied (created in previous step) to $ORACLE_HOME

$ cp $INST_TOP/admin/out/ $ORACLE_HOME

> Unzipped the at $ORACLE_HOME


$ unzip -o

> Executed the autoconfig utilities on Database tier:

$ perl $ORCLE_HOME/appsutil/bin/

$ cd $ORACLE_HOME/appsutil/bin

$ sh

11. Executed the on database tier and then on the applications tier.


$ . VIS_ls1.env        — sourced database environment

$perl appsutil/bin/ dbTier

$ cd $APPL_TOP/appl/scripts

$ . /VIS_ls1.env        — sourced application environment

$ perl $INST_TOP/appl/appsutil/bin/ dbTier

12. Got the environment back to normal from maintenance mode.

$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=DISABLE_MODE workers=4

13. Inquired the Oracle EBS code level to see the upgrade is all well.


$ . VIS_ls1.env

$ sqlplus apps/*****

SQL> select release_name from fnd_product_groups;




13. Restarted the application services.


$ sh apps/*****

We have got our Oracle EBS 12.1.3 ready to play (learn I mean).

Thank you for visiting our blog. Have a great day.

About these ads

4 thoughts on “How I upgrade our Oracle EBS from R12.1.1 to 12.1.3

  1. I have issue at step 10). I could do fine until “$ unzip -o” with “applmgr” account. When I try to execute “$ perl $ORCLE_HOME/appsutil/bin/” I get error and asks me to unset apps env and source database env. Do we have to switch accounts between “applmgr” and “oracle”(database account) here? Any quick response/help is appreciated

  2. Precisely here is the error I get. If you can guide with clear step by step is helpful
    “Incorrect environment file sourced. Unset apps environment and source RDBMS oracle home environment file.”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s