August 10, 2010 5 Comments
I’m planning for an Oracle upgrade, 9i to 11gR2. Cross-platform – Sun Solaris to Linux. Different Endian.
It’s just under 1TB so not big these days.
Downtime shouldn’t be too much of an issue. It’s not like it needs to be done in an hour or anything demanding like that. As long as it can be done within a day.
Within the client, there’s no official build for 11g on Solaris, so I think that might rule out solutions like an in situ upgrade to 11g on Solaris followed immediately by the move & conversion to Linux.
Imp/Exp seems to be the recommended approach given all of the above.
There are lots of resources out there to help with an upgrade.
- OTN Upgrade page
- Upgrade forum
- Upgrade Whitepaper
- Real World Experience Whitepaper
- Database Upgrade Guide
- Metalink notes 870814.1, 429825.1, 837570.1
So, no shortage of advice and guidance.
But I’m also interested in hearing some real world experiences.
So, if you’ve been through something similar, please let me know.
Tell me how you did it and how it went.