Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at http://searchoracle.techtarget.com/answer/Migrating-Oracle9i-database-from-Solaris-to-AIX) but the article was from 10-09-2006. Is the solution provided still stands true? If yes, are there any tools to assist the migration? Also, how much downtime shall we expect for the above database sizes. An approximate downtime based on prior experience will be very helpful for our planning. Thanks, Nikhil

Answer Wiki

For migration of databases to be hasslefree without the need to recreate all the nitty gritty stuff like indexes, constraints, etc, my personal opinion would be to use the exp/imp utilities for Oracle 9i. Based on my experience with a couple of P690 machines running AIX 5.2, a 25 GB dump file could easily take me 4 hrs just to import (even with a LARGE POOL size specified). Given the sheer size of your databases, I think the dump files would be exceedingly large as well resulting in the import probably taking a couple of days to complete.

I do have newer machines with VIO architecture in place running AIX 6.1 with Oracle 9i but the import of the same 25 GB dump file was only slightly faster. For your info.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 1 &nbspReply

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

I have vmware installed and in it solaris two copy i want to do remote login if i ping it is showing alive second system and tried to do remote login like rlogin it shows "no utmpx entry, try to login from lower level shell" can you pls solve this problem so that i can do remote login"

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy