Re: Oracle Apps Upgrade from to R12.1.1

  • From: John Piwowar <jpiwowar@xxxxxxxxx>
  • To: krishna000@xxxxxxxxx
  • Date: Wed, 7 Mar 2012 22:19:35 -0800

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 <krishna000@xxxxxxxxx> 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
> --


Other related posts: