If you are not satisfied with the upgrade results, you can choose the Restore option. If you
used DBUA to perform the backup, the restoration will be performed automatically; otherwise,
you will need to perform the restoration manually.
When you exit DBUA after successfully upgrading the database, DBUA removes the old
database??™s entry in the network listener configuration file, inserts an entry for the upgraded
database, and reloads the file.
Performing a Manual Direct Upgrade
In a manual upgrade, you must perform the steps that DBUA performs. The result will be a direct
upgrade of the database in which you are responsible for (and control) each step in the upgrade
process.
You should use the Pre-Upgrade Information Tool to analyze the database prior to its upgrade.
As I mentioned earlier in this chapter, this tool is provided in a SQL script that is installed with the
Oracle Database 11g software; you will need to run it against the database to be upgraded. The
file, named utlu111i.sql, is located in the $ORACLE_HOME/rdbms/admin subdirectory under the
Oracle 11g software home directory. You should run that file in the database to be upgraded as a
SYSDBA-privileged user, spooling the results to a log file. The results will show potential problems
that should be addressed prior to the upgrade.
Chapter 2: Upgrading to Oracle Database 11g 55
If there are no issues to resolve prior to the upgrade, you should shut down the database and
perform an offline backup before continuing with the upgrade process.
Pages:
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148