HomeOracle Page 4 - Upgrading to Oracle Database 10g, concluded
After Upgrading - Oracle
Want to upgrade to Oracle Database 10g, but not sure how? Fortunately, there are a number of ways to do it. This article, the second of two parts, describes these methods and guides you as to which one to use, depending on your circumstances. It is excerpted from chapter two of the Oracle Database 10g DBA Handbook, written by Kevin Loney and Bob Bryla (McGraw-Hill/Osborne, 2005; ISBN: 0072231459).
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
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.