Topic: Oracle Programming
Download (208) times
Last Download at Tuesday 01st of May 2012 01:32:00 AM
Methods For Upgrading To Oracle Database 11 G Release 2
The recommended method for upgrading to Oracle Database 11 g Release 2 is to use the Database Upgrade Assistant (DBUA). However, there are circumstances when using the DBUA is not possible and it is more appropriate to use another method.
Depending on the environment, there are several alternatives available when upgrading a database. This section discusses why a particular method would be chosen, lists considerations when using each method, and gives pointers to additional information.
A manual upgrade consists of running SQL scripts and utilities from a command line to do an in- place upgrade of a database to the new Oracle Database 11 g release. Although a manual upgrade gives finer control over the upgrade process, it is more susceptible to error if any of the upgrade steps are not followed or are performed out of order.
After you have installed Oracle Database 11g Release 2 (11.2) and any required patches, you should analyze your database before upgrading it to the new release. This is done by running the Pre-Upgrade Information Tool. This is a required step if you are upgrading manually, otherwise the catupgrd.sql script will terminate with errors.
Source: www.oracle.com
Related PDF Files
Comments for Methods For Upgrading To Oracle Database 11 G Release 2