Results 1 to 3 of 3

Thread: Oracle Upgrade

  1. #1
    Join Date
    Sep 2016

    Unanswered: Oracle Upgrade


    I am in the planning process of upgrading an existing windows 2003 server with oracle on it. We are going to stand up a new windows 2012 server to house the upgraded database.

    This is my simplified initial plan

    Install on the windows 2012 server.
    Backup and Restore the existing database to the new server.
    Go through the upgrade process on the new server to get to 12c.

    Is this the best way to go about an upgrade like this? Is it possible to restore a database directly to 12c? Any suggestions at all would be greatly appreciated.


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    You can't upgrade directly from 9 to 12 - you'll need to do an intermediate upgrade first e.g. from 9 to 11.2 then from 11.2 to 12.

    Upgrades can be messy in the sense that they leave behind old folders/files that are no longer needed. I would be tempted, if possible, to do the upgrades on your existing server, install 12c software on your new windows 2012 server & import your 12c database from the old server.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    How big is the data on the 9i server? If not very large, you could do a consistant expdp of the 9i database and then use impdp to load it into the new 12C database without any upgrading. Also unless you plan to run multiple databases in the new 12C database, make the 12C database without CDB (multitenant container databases). It's a nice idea but worthless and over complicated if your running one production database on the server.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts