Oracle Apps Upgrade from to R12.1.1

From: Bala krishna <>
Date: Thu, 8 Mar 2012 05:47:15 +0000
Message-ID: <>

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 ?


Received on Wed Mar 07 2012 - 23:47:15 CST

Original text of this message