Jump to content


Migrating oracle 9i to 11g in AIX 6.1 OS

migrating oracle 9i to 11g

  • Please log in to reply
1 reply to this topic

#1 raj007

raj007

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 08 November 2011 - 04:45 PM

Hi all,

In my office we have a plane to upgrade the oracle 9i to 11 g version in aix 6.1.
can any one please provide the steps to upgrade the oracle.

We have a netapp storage box all our db's are stored in the storage box . while upgrading the server 9i to 11 g what are the points to be considered in both storage point of view as well as migration. if you have any tutorials please provide me for this.

Regrads,
Karthick
  • 0

#2 plumbum

plumbum

    Newbie

  • Members
  • Pip
  • 16 posts
  • Gender:Male
  • Location:Poland

Posted 05 December 2011 - 10:29 PM

A few weeks ago I have done similar migration;
source: Oracle database 9.2.0.1 worked on SunSolaris 8
destination: oracle database 11.2.0.2.3 worked on Intel x86_64

I you have small database f.e less than 200GB consider to use EXP/IMP Oracle programs (included on each Oracle Database server: see exp help=y as database owner with ORACLE_HOME environment)
In this option remeber that you need an appropriate undo tablespace and undo retention ( if it is used) or rollabck segmets configured on source database

If you database is larger than 200-300GB consider to upgrade database.
f.e.

first step: 9.2.0.1 upgrade to 9.2.0.8
second step: 9.2.0.8 upgrade to 11.2.0.3

In both situation application/users could not to connect to database during migration process
  • 0





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users