Upgrade from 10g to 11g [message #531013] |
Fri, 11 November 2011 14:55 |
sant_new
Messages: 165 Registered: June 2008
|
Senior Member |
|
|
Hi all,
I'm planning on upgrading our 10.2.0.4 database to 11.2.0.1 on the same server. Would like to hear the best efficient method to do so from the experts.. My first option is to use datapump method, so I can take a backup and uninstall 10g on the server, Install 11g and import the data. But as I was reading through the documents on the upgrade, I think it is best to use DBUA instead. I'm planning to follow this document to upgrade using DBUA. http://debaatobiee.wordpress.com/2009/10/17/step-by-step-upgrading-oracle-10g-to-oracle-11g/
Few doubts on this..
1. Since I will be upgrading the existing 10g database, I suppose I need not uninstall 10g prior to the upgrade. I read that DBUA will shutdown the database during the upgrade. Currently we have Oracle 10g software in c:\oracle\product\10.2.0\db_1 and the data files are in different disk drives and also in c:\oracle\oradata folder. So will DBUA move the physical datafiles to the new location?
2. Do I need to stop 10g listener prior to running DBUA?
3. Will I be able to uninstall 10g after the upgrade?
Please help me... Any help is appreciated. Thanks a lot
|
|
|
|
|
|
|
|