10. Issue the startup upgrade command.
11. Use the spool command to log the results of the following steps.
12. Create a SYSAUX tablespace via the create tablespace command if you are upgrading
from a release prior to 10.1. You should allocate SYSAUX between 500MB and 5GB
of disk space, depending on the number of user objects. SYSAUX must be created with
the following clauses: online, permanent, read write, extent management local, and
segment space management auto. All those clauses except segment space management
auto are the defaults. See the output from the Pre-Upgrade Information Tool for suggested
sizing of the SYSAUX tablespace. Here??™s an example:
create tablespace SYSAUX
datafile '/u01/oradata/db1/sysaux01.dbf'
size 500m reuse
extent management local
segment space management auto
online;
13. Run the script catupgrd.sql in the 11g environment. This script automatically determines
which upgrade scripts must be run, runs them, and then shuts down the database.
14. Stop spooling (via spool off) and review the spool file for errors. Resolve any problems
identified there. Restart the database at the SQL*Plus prompt using the startup command.
15. Run the utlu111s.sql file to upgrade Oracle components such as Oracle Text, Oracle Ultra
Search, Oracle Application Express, and the Oracle Server itself. You run it as follows:
@utlu101s.sql
16. Oracle will then display the upgrade status of each component. The upgrade elements
should all be listed with a status of ???VALID.
Pages:
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151