Re: Upgrading from 10g to 11g on Windows

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 29 Sep 2009 13:08:53 -0700 (PDT)
Message-ID: <60425.95842.qm_at_web38905.mail.mud.yahoo.com>



I don't believe you will be able to use DBUA in this situation (I've not tried, so this is just a guess based on what I know). You will probably have to do a manual upgrade in this case. As already suggested, an expdp/impdp might be a good solution too.

RF

 Robert G. Freeman
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf

  • Original Message ---- From: "Schauss, Peter (IT Solutions)" <peter.schauss_at_ngc.com> To: Oracle L <oracle-l_at_freelists.org> Sent: Tuesday, September 29, 2009 1:46:55 PM Subject: Upgrading from 10g to 11g on Windows

I am getting ready to upgrade some small instances of 10.2.0.3.0 to 11.1.0.6.0 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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 29 2009 - 15:08:53 CDT

Original text of this message