Re: Oracle Apps Upgrade from to R12.1.1

From: John Piwowar <>
Date: Wed, 7 Mar 2012 22:19:35 -0800
Message-ID: <>

Hi Bala,
I don't really have any solutions for your situation, but a few comments:

First: If you skip a documented step for the R12 upgrade without the direction of Oracle Support, you are leaving your system in an unsupportable state. Do *not* do this.

A quick search on Metalink turns up several notes regarding performance of the appdstln.sql script, both for 12.0 upgrades and 12.1 upgrades. One of the notes (1088273.1) states explicitly, "NOTE: These patches and processes must be applied PRIOR to starting your upgrade. If you experience the performance issues after you have already begun, you will probably have to start fresh."

Finally, 2 weeks is a long time to wait for assistance from Oracle on what I assume is a time-critical project. I strongly recommend engaging with the Duty Manager to escalate this issue within Oracle Support. The fact that I was able to find references on on this topic with a very lightweight Metalink
search suggests that you should be able to get help from resources within Oracle to address your problem. If your current support analyst cannot help you, it is part of the Duty Manager's job to help find someone who can.

Good luck!


John Piwowar

On Wed, Mar 7, 2012 at 9:47 PM, Bala krishna <> wrote:

> Hi All,
> We've have upgraded Oracle apps from to R12.1.1 and then to
> R12.1.3 during the upgrade appdstln.sql ran almost 17 hours and took more
> than 150GB of space and in the mean time we've also added 40GB undo
> tablespace too but even then at last it errrored with undo tablespace .
> Looks like the above script is doing very bad and finally we'd to skip that
> sql and continue with the upgrade . I've got few questions can anybody
> answer inase if they'd experienced please.
> We've raised SR with Oracle support but so far we've not got any solution
> yet, rather than asking too many questions and its more than 2 weeks :(
> My Questions:-
> 1. As per our plan we wanted to upgrade from R12.1.1 to 12.1.3 during this
> upgrade appdstln.sql finished sucessfully but it took almost 3 hours during
> that time . Do you still think that i need to re-run this script since i've
> skipped during R12.1.1 upgrade from 11i.
> 2. Since we've already skipped appdstln.sql can we re-run the script after
> the upgrade if yes what is the procedure.
> 3. For next upgrade does any body of you have any suggestions to make the
> script run faster ?
> Thanks
> Bala
> --

Received on Thu Mar 08 2012 - 00:19:35 CST

Original text of this message