Upgrading to Oracle Database 10g, concluded - After Upgrading (
Page 4 of 4 )
Following the upgrade, you should double-check the configuration and parameter files related to the database, particularly if the instance name changed in the migration process. These files include
- The tnsnames.ora file
- The listener.ora file
- Programs that may have hard-coded instance names in them
NOTE
You will need to manually reload the modified listener.ora file if you are not using DBUA to perform the upgrade.
You should review your database initialization parameters to make sure deprecated and obsolete parameters have been removed; these should have been identified during the migration process. Be sure to recompile any programs you have written that rely on the database software libraries.
Once the upgrade has completed, perform the functional and performance tests identified before the upgrade began. If there are issues with the database functionality, attempt to identify any parameter settings or missing objects that may be impacting the test results. If the problem cannot be resolved, you may need to revert to the prior release.
