I recently had a request at work to upgrade a 10.2.0.1 database to 10.2.0.4. Now normally this would be a fairly simple request. However, on the server the customers database is running on, the oracle home in question is shared by about 5 different databases. Now I don’t want to upgrade all the databases, just this one customers.
How do I do that? Move that database in question to a new ORACLE_HOME.
This sounds like it would be a difficult task, but its not that hard.
Check out the step after the break.
Continue reading Moving a database to a new ORACLE_HOME