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



  • 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.

  • 0

#2 plumbum



  • 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 worked on SunSolaris 8
destination: oracle database 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.

first step: upgrade to
second step: upgrade to

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