Re: Oracle Apps Upgrade from 18.104.22.168 to R12.1.1
Date: Wed, 7 Mar 2012 22:19:35 -0800
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
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.
On Wed, Mar 7, 2012 at 9:47 PM, Bala krishna <krishna000_at_gmail.com> wrote:
> Hi All,
> We've have upgraded Oracle apps from 22.214.171.124 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 ?