What is the recommended procedure for upgrading a database from Oracle 11.2.0.1 to Oracle 11.2.0.3
What is the recommended procedure for upgrading a database from Oracle 11.2.0.1 to Oracle 11.2.0.3? The Oracle 11g Patch Set 2 release notes recommend performing an Out-of-place upgrade by installing the Oracle 11.2.0.3 software in a new Oracle home directory and then migrating the data from database in the old Oracle home directory to the database in the new Oracle home directory. Does that mean you should use the Export Data Pump and Import Data Pump utilities to migrate the data or are using the Database Upgrade Assistant or upgrading the database manually still considered viable alternatives?
/