Home » RDBMS Server » Enterprise Manager » Oracle Migration
Oracle Migration [message #68184] Wed, 15 January 2003 04:26 Go to next message
Stuart Macpherson
Messages: 6
Registered: November 2002
Junior Member
We currently have an Oracle data warehouse running on Solaris 2.6 on an Sun E10K.

I have been tasked with upgrading the warehouse to run on Solaris 2.8 with the lastest stable version of Oracle 9i.

We a reduced test system which will be used to test the process.

Can you advise me on version compatiblities to achieve this in as few steps as possible.


Stuart Macpherson
Operational DBA
Re: Oracle Migration [message #68185 is a reply to message #68184] Wed, 15 January 2003 06:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
from you cannot do a direct upgrade to 9i.
you have to goto 8.0.6 or 8i.
easiest is to go 8i and then to 9i.
as migration from is concerned,
i am almost doing it in a weekly basis.!!(to create 8i database COPIES in different machines for different purposes of application (lawson suite) upgrade.
You can choose any method u want (exp/import etc)
1. copy and recreate the in a new machine   (test Machine).
   do an OS cold copy of oracle software binaries
   AND database.
2. in TEST bring the instance up
   test whether this CLONE is working properly.
3. install 8i in a new home.
5. use ODMA (oracle datamigration assistent) to migrate to 8i.
6. before migration make sure you have added 30% more space in system tablespace in 8.0.5 databases.
7. the listener entries are automatically relocated 
   ( it will ask for your option).
   its upto u, to choose it.(i never do that).
8. bring the 8i instance up, check for any ISSUES.
   client connectivity etc.
   look for INVALID OBJECTS(if any) and recompile them.
9. do a migration for 9i.
10. READ the migration manuals . IT WILL GIVE U a lot of  information.
[b] 8.0.5 to 8i is not that complicated AS IT SEEMS IN ABOVE STEPS.[/b]

Re: Oracle Migration [message #68660 is a reply to message #68185] Fri, 28 May 2004 13:53 Go to previous messageGo to next message
Siva prakash
Messages: 1
Registered: May 2004
Junior Member
Hi , coudl you email me teh detail steps to migrate oracle from 8.1.6 to . source and target machine are same . I am mainly concerened about the environment variables that need to be set before calling ODMA tool .

appreciate if you could share step by step commands .

have a niec day .
Re: Oracle Migration [message #68722 is a reply to message #68185] Thu, 29 July 2004 19:20 Go to previous messageGo to next message
Tech Broker
Messages: 1
Registered: July 2004
Junior Member
Hi. I would like to request if you can email to me the step by step procedures in migrating from Oracle 8 to 8i without using the ODMA. The DB's are located on separate boxes. OS of 8 is NT and 8i is Win2K.
Thanks in advance.
Re: Oracle Migration [message #68765 is a reply to message #68660] Thu, 02 September 2004 10:07 Go to previous message
Messages: 10
Registered: September 1999
Junior Member
Please see these links

Previous Topic: management server error ora 12638
Next Topic: How do we find & replace a certain value in the database without even knowing th
Goto Forum:

Current Time: Mon May 23 01:13:25 CDT 2022