Essential Guide

Browse Sections


This content is part of the Essential Guide: Guide to Oracle 12c database features and upgrades
Get started Bring yourself up to speed with our introductory content.

Handling database migrations, such as upgrading to Oracle 12c

IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live.

Oracle Database 12c has been generally available for about nine months now, with interest and adoption increasing, according to Independent Oracle Users Group President Michelle Malcher.

Michelle MalcherMichelle Malcher

Malcher talks in this SearchOracle podcast about some of the decision making that goes into database migrations and upgrading to Oracle Database 12c, from business and technical drivers to ongoing maintenance once the upgrade is complete.

One of the most touted features of Oracle Database 12c has been Multitenant, formerly called Pluggable Database. While that is interesting to many potential users, Malcher talks about some of the other features she and co-workers are exploring at DRW Holdings, a Chicago-based trading organization where she is the database administrator team lead.

"We are also planning upgrades for 12c for security reasons, as well as for some database development features that we'll be able to use," she said. "We were lucky enough to be part of the beta, so we've been planning a few things at a time to see what other new features we can use."

In terms of uptake for database migrations, Malcher said there is usually a "huge uptick" when the first patch set comes out, while others wait for version 2 to come out before upgrading. She added that "each cycle we've seen, even going from 10g to 11g, there has been less and less time" before end users decide to upgrade.

Business and technical challenges exist, however. Malcher said one is being able to simply find time to do testing and finding the downtime to do the database migration. The maintenance window can get harder and harder with today's 24/7 environment.

Listen to this SearchOracle podcast for more.

Mark Fontecchio may be reached at Also check out SearchOracle on Twitter and Facebook.

Dig Deeper on Oracle database installation, upgrades and patches

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.

Developed a series of templates for code migration. This allows for the porting of code as well as both the implementation of performance improvements and features unique to Oracle ensuring additional value is achieved during migration. By looking to build on the powerful functions that exist within Oracle PL/SQL it is often possible to reduce the complexity of code significantly during migration, this makes the on-going support and development effort significantly more cost effective
We use IRI NextForm for DB migrations. Are their special considerations for 12c we need to bear in mind relative to prior upgrades?