Yes, I was part of the EAP program for OATM. I manage 5 Production Implementations of Apps 11.5.9 and have done OATM on all of them. The migration was pretty painless and has made management of the databases a much simpler task! I had the added bonus that we had not yet gone live, so had very little data to contend with. Timing will depend on your current DB size and server performance. Ours was very quick! (about 2 hours if I recall - we did this in Nov/Dec 2003)
If you have any specific questions I am happy to answer them.
Regards,
Paul
*********** ORIGINAL MESSAGE ***********
On 6/10/2004 at 3:12 PM Kauffroth Seth wrote:
Brief Description:
This process provides a practical example of converting an 11i (11.5.9)
production Oracle Applications database on Unix filesystem to RAW devices
with the new Oracle Applications Tablespace Model (OATM). This procedure is
intended for an Applications 11i environment that is undergoing, or is
planned to undergo a single instance to RAC conversion. It can also be
utilized in any standard Oracle Applications 11i environment that will
utilize RAW devices, and meets the pre-requisites outlined in the current
OATM utility release available on MetaLink specific to any Applications
pre-requisite patches, or RDBMS patchset requirements.
The purpose of this document is to identify, and determine the steps and
requirements necessary to install the Oracle Applications Tablespace Model
(OATM) utility, and convert the existing Applications tablespace model,
consisting of 382 application tablespaces to the new model utilizing 9
application tablespaces to RAW devices from UFS. No considerations are made
for site specific, custom extensions to Applications as these are
implementation specific and can not be covered in generic documentation
The procedure outlined in this document is intended to be followed when
working in either a Linux, or Unix OS environment. No platform specific Unix
issues are addressed, as these vary significantly among different OS?, and
are beyond the scope of this document.
This is not a method to allow the transfer of database files to disparate
OSplatforms (e.g. Sun to Linux).
Has anyone done this yet? I have a friend that is going into this. Any
comments? Suggestions? Ideas? Do I tell that he in for it? LOL...
Thanks guys....
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page