Oracle Scratchpad

April 29, 2011

Upgrades

Filed under: Non-technical,Oracle,Upgrades — Jonathan Lewis @ 6:06 pm BST Apr 29,2011

Here’s a link to a truly ambitious document on Metalink (if you’re allowed to log on):

Doc ID 421191.1: Complete checklist for manual upgrades of Oracle databases from any version to any version on any platform

(Actually it only starts at v6 – but I don’t think there are many systems still running v5 and earlier).

6 Comments »

  1. Should the need arise, V5 upgrades require reloading the data. EXP/IMP should work, but it may be faster to use sqlplus copy via sqlnet. If you opt for sqlplus copy, be sure to set the session’s long to at least as long as the longest long you wish to copy. Likely you’re get better results connect from V6 to V5 and pulling the data into the V6 database. That will get you to v6 and you can follow Oracle’s advice from there.

    Comment by Mark W. Farnham — April 29, 2011 @ 8:11 pm BST Apr 29,2011 | Reply

  2. I haven’t seen one running 6 too. The oldest version I have seen is 7. Something to do with being little young, I think :D

    Comment by Amardeep Sidhu — April 30, 2011 @ 4:24 am BST Apr 30,2011 | Reply

    • Amardeep,

      I don’t think I’ve seen a v5 in production for at least 10 years. It was running under Xenix, supporting an application written in Forms 2.0.
      I was called in to see if I could do anything to port it to a newer machine because “the hard drive has started to make funny noises”.

      Comment by Jonathan Lewis — May 7, 2011 @ 7:54 am BST May 7,2011 | Reply

      • Interesting !

        So what did you do ? :)

        Thanks

        Comment by Amardeep Sidhu — May 9, 2011 @ 4:57 am BST May 9,2011 | Reply

        • Amardeep,

          The documenation for the system was very good, and the whole setup had clearly been prepared by someone who knew what they were doing, so I suggested they go back to the company that had originally created the system for them and get them involved.

          (The amount and type of work meant that I wasn’t the right person for the job – it would have been a bit like getting a brain surgeon to man the first-aid post at an open-air concert … and it’s always possible the brain surgeon might have forgotten how to deal with a nose-bleed. ;)

          Comment by Jonathan Lewis — May 9, 2011 @ 1:24 pm BST May 9,2011

        • The documenation for the system was very good, and the whole setup had clearly been prepared by someone who knew what they were doing

          Rare stuff ! Documentation is the last thing on the agenda, generally.

          and it’s always possible the brain surgeon might have forgotten how to deal with a nose-bleed.

          Hehe ;)

          Comment by Amardeep Sidhu — May 12, 2011 @ 3:55 am BST May 12,2011


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 3,508 other followers