3 Replies Latest reply: Sep 14, 2012 10:23 AM by Srini Chavali-Oracle RSS

    Yet another 9i to 11g upgrade thread

    959602
      I have :
      2 x Oracle 9.2.0.8 on AIX (5.3)
      1 x Oracle 9.2.0.7 on AIX (5.3)
      1 x Oracle 9.2.0.6 on Solaris (5.8)

      These four databases are going to be moved from 4 different European countries to one country. The target architecture will be 11.2.0.3 on either RH or AIX. Each database is around 500GB. Lots of BLOBs.Yes I know about endian issues if we choose Red Hat Linux.

      According to 419550.1, 733205.1, various searches and cruising around these forums, I have only one option for a 'direct' migration : EXP/IMP

      There is also (and I'm unsure about the validity of this) the solution of having a machine with 10.2.0.5, copying the entire database to this machine (which has the same filesystem layout) and then doing a startup migrate. This is for the 9.2.0.7 and 9.2.0.8 databases. For the 9.2.0.8 databases the same person has proposed a startup migrate but pointing to 11.2.0.3 binaries. Like I said, I didn't know that this was possible.

      Golden Gate has not yet been looked at.

      Appreciate your ideas.