Migrating versions

All posts relating to Oracle database administration.

Moderator: Tim...

Migrating versions

Postby adda.road@yahoo.com » Tue May 01, 2012 7:51 pm

Hi Tim,

what are steps to migrate from oracle 10g to 11g.?

can we use patchs?

Thanks in advance.

Rampa.
adda.road@yahoo.com
Senior Member
 
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

Re: Migrating versions

Postby Tim... » Tue May 01, 2012 8:37 pm

Hi.

The process depends on the exact versions you are working with, because some upgrades have specific requirements. The platform is also important.

This article gives a very top level view of the possible approaches. It was written for 11gR1, but the overall approach is similar in 11gR2.

http://www.oracle-base.com/articles/11g ... to-11g.php

Prior to 11.2.0.2, patches were not complete installations, so you would need to upgrade to the base release then patch to the latest patchset. From 11.2.0.2 onwards, patches are full installations, so you can upgrade to the latest patchset directly.

For detailed instructions you need to read the upgrade guide for the version you are upgrading to, and check the platform specific notes relevant to your platform.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Migrating versions

Postby adda.road@yahoo.com » Wed May 02, 2012 8:03 pm

Hi Tim,

Thank You so much for reply.

Rampa.
adda.road@yahoo.com
Senior Member
 
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

Re: Migrating versions

Postby Tim... » Wed May 02, 2012 8:04 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 0 guests

cron