My current version is Oracle 10g on Window and i want to convert on Oracle 11g on Linux.
What will be the best way to convert it ? can possible to direct convert
or i need to be database migration from window Oracle 10g to Linux Oracle 10g and then covert from Linux Oracle 10g to Linux Oracle 11g.
If the direct conversion is possible then please let me know the way or if u have document then please share it.
I searched lot but i didn't get anything.....
Thanks in advance
What is the expected downtime duration ?
What is the database size ?
For a "small" database with no downtime constraint you could use Data Pump to move data.
For a "large" database with minimum downtime you could use Oracle Streams (with Enterprise Edition) or Golden Gate (separate product: needs new licensing).
You can find detailed migration/upgrade recommendations and scenarios on OTN database upgrade page:
Edited by: P. Forstmann on 22 mars 2013 13:03
thanks alot for your time and help !!!
Our Database is too large and no down time , so we decided we will done this process by Replicate machine. Which is in sync through Goldengate.
Yes we can through Goldengate initial load approach. question is will it good approach because our database will be near to 5-6 TB. Might be it will take lot of time
There is any another approach....
Check the workshop presentation here - http://www.oracle.com/technetwork/products/upgrade/index-088044.html - for various scenarios and options for upgrading large databases with limited downtime.