This ensures that if you
have any serious problems with the database upgrade, you can always get back to the state of
your old database as of when you started the upgrade process.
Once you have a backup you can restore if needed, you are ready to proceed with the upgrade
process. The process is detailed and script-based, so you should consult with the Oracle installation
and upgrade documentation for your environment and version. The steps are as follows:
1. Copy configuration files (init.ora, spfile.ora, password file) from their old location to the
new Oracle software home directory. By default, the configuration files are found in the
/dbs subdirectory on Unix platforms and the \database directory on Windows platforms.
2. Remove obsolete and deprecated initialization parameter from the configuration files
identified in the Pre-Upgrade Information Tool. Update any initialization parameters to
at least the minimum values specified in the Pre-Upgrade Information Tool report. Use
full pathnames in the parameter files.
3. If you are upgrading a cluster database, set the CLUSTER_DATABASE initialization parameter
to FALSE. After the upgrade, you must set this initialization parameter back to TRUE.
4. Shut down the instance.
5. If you are using Windows, stop the service associated with the instance and delete the
Oracle service at the command prompt. For Oracle 8.0, use the command
NET STOP OracleServiceName
ORADIM ??“DELETE ??“SID instance_name
Next, create the new Oracle Database 11g service using the ORADIM command, as
shown here.
Pages:
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149