Jump to content
Sadikhov IT Certification forums
Sign in to follow this  
raj007

Migrating oracle 9i to 11g in AIX 6.1 OS

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×