???
17. Run the catuppst.sql script, located in $ORACLE_HOME/rdbms/admin to perform
upgrade steps that do not require the database to be in UPGRADE mode:
@rdbms/admin/catuppst.sql
18. Run the utlrp.sql script to recompile invalid packages:
@utlrp.sql
19. You can then verify that all packages and classes are valid by using the following SQL:
select count(*) from dba_invalid_objects;
select distinct object_name from dba_invalid_objects;
20. Exit SQL*Plus.
21. Shut down the database and perform an offline backup of the database; then restart the
database. The upgrade is complete.
Chapter 2: Upgrading to Oracle Database 11g 57
NOTE
After the upgrade, you should never start your Oracle 11g database
with the software from an earlier release.
Using Export and Import
Export and Import provide you with an indirect method for the upgrade. You can create an Oracle
11g database alongside your existing database and use Export and Import to move data from the
old database to the new database. When the movement of the data is complete, you will need to
point your applications to connect to the new database instead of the old database. You will also
need to update any configuration files, version-specific scripts, and the networking configuration
files (tnsnames.ora and listener.ora) to point to the new database.
The advantage to using an Export/Import method is that the existing database is unaffected
throughout the upgrade process; however, to ensure that relational integrity remains intact and
no new transactions are left behind in the old database, you can run the old database in restricted
mode for the duration of the export and upgrade.
Pages:
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152