Oracle Switch TP1996-9.2.2.1A Manuale Utente
Appendix A
AUT Maintenance
Before you upgrade your database, you should always make sure you are using the latest version
of the AUT. Changes to the scripts, like averify, may occur after the initial version has been
released. So, to ensure your database is correctly upgraded, always check the Agile Support
website for updates.
of the AUT. Changes to the scripts, like averify, may occur after the initial version has been
released. So, to ensure your database is correctly upgraded, always check the Agile Support
website for updates.
Updating the AUT
If updates are needed to the AUT, you can always find the latest version on the
Agile Support Web
Site (http://www.agile.com/support). Download the AUT.zip file and extract the file contents into the
same directory where you originally extracted the files.
same directory where you originally extracted the files.
Running Averify
Averify performs an integrity check against the Agile database and reports on specific errors.
Averify includes a check for missing indexes and inconsistent data stored in the various database
tables. Averify only reports errors, and does not attempt to fix them or modify your database.
Averify includes a check for missing indexes and inconsistent data stored in the various database
tables. Averify only reports errors, and does not attempt to fix them or modify your database.
Running Averify and using the results to eliminate known errors is a prerequisite for diagnosing
problems. Averify is not comprehensive, however, and finding zero errors does not certify a
database as perfect.
problems. Averify is not comprehensive, however, and finding zero errors does not certify a
database as perfect.
When you download an updated version of AUT, the latest Averify scripts are also included. The
latest Averify scripts are also available separately on the
latest Averify scripts are also available separately on the
Agile Support Web Site
(http://www.agile.com/support). You should run Averify periodically as part of your regular database
maintenance procedures.
maintenance procedures.
To run Averify:
16. Make sure you have downloaded the latest version of AUT from the Agile Support Web Site.
17. Make sure you have backed up your database.
18. Go to the $AUT_HOME\scripts\oracle\utilities\averify directory.
19. Using SQL*Plus from a command line, run the oracle_averify9x.sql script.
SQL> @oracle_averify9x.sql
Important If errors are generated in the <name of file> located in the
$AUT_HOME\scripts\oracle\utilities\averify directory, contact Agile Support.
29
Database Upgrade Guide