This content has been marked as final. Show 6 replies
Take a look at the Oracle installation guide and datatype support - a straight across migration will be problematic.
The use of GoldenGate is not certified for:Upgrading E-Business Suite databases from one version to another
Migrating E-Business Suite databases from one operating system platform to another
Oracle GoldenGate doesn't (yet) support the replication of all of the datatypes that are used by the E-Business Suite. That means that attempting to use GoldenGate to migrate or upgrade an entire E-Business Suite database will require a combination of GoldenGate and other manual steps to preserve referential integrity.
Thank you steven for your prompt response.
I was looking for golden gate upgrade for following reasons:
1. Fail safe plan can be implemented easily -- However, if it can not use to replicate all datatypes, we can not use it.
2. Simple to configure, and we can migrate to other servers as well.
3. And most important -- Almost Zero downtime.
If it is hard to implement on EBS for now, is there any Oracle recommended steps to upgrade simple Database ( not EBS ). ? I want to explore all the features of Golden gate.
Tons of information on how to upgrade a database, but there is a huge difference between upgrading in place versus upgrading across databases (typically due to datatype restrictions). Streams cannot be used to upgrade either (datatypes again). One option is to use Data Guard (physical standby, can't use logical because you guessed it, datatype restrictions). Set a restore point, open the database for use during the day (reporting purposes), flashback at night and apply logs that accumulated during the day, repeat forever (or until Oracle figures out a way to get around datatype restrictions).