Re: Upgrading from 10g to 11g on Windows

From: Niall Litchfield <>
Date: Tue, 29 Sep 2009 21:40:15 +0100
Message-ID: <>

My approach here would be to install as you describe. clone the prod database using rman and then run dbua on the cloned database. I'd skip the backup step though since your old prod database is the backup in this scenario. when you are done remove the 10.2 software.

On Tue, Sep 29, 2009 at 9:34 PM, John D Parker <> wrote:

> The other thing that I've run into is that the upgrade wants a PRE script
> run on the 10g instance and that PRE script changes the instance. In my
> case, I'm going from 32bit winders to 64bit winders and 10g to 11g. I'm
> going to have to install a temporary copy of 10g 32bit on my 11g 64bit
> machine so that I can run the PRE script. I don't really want to change my
> current production instance by running the PRE script on it. Read the
> upgrade info very carefully. There are just plenty of unexpected gotcha's in
> there waiting.
> John Parker
> ------------------------------
> *From:* "Schauss, Peter (IT Solutions)" <>
> *To:* Oracle L <>
> *Sent:* Tuesday, September 29, 2009 2:46:55 PM
> *Subject:* Upgrading from 10g to 11g on Windows
> I am getting ready to upgrade some small instances of to
> on a new server. My plan is to copy cold backups from the
> old server to the new one where I have already installed 11g. The
> instructions for using DBUA assume that you are upgrading an existing
> server where the Windows services for the instances already exist which
> will not be the case for the approach that I am taking. How do I get
> DBUA to recognize my copied databases?
> Thanks,
> Peter Schauss
> --

Niall Litchfield
Oracle DBA

Received on Tue Sep 29 2009 - 15:40:15 CDT

Original text of this message