Upgrading to Oracle 10G - A Handy Checklist
Premigration checklist
==============
Disable all batch and cron jobs.
Oracle installation on domain1
Listing down all db files
Take a Backup
Comptability issues at OS and DB level
Avoid running out of Rollback Space during the migration.
List all objects that are not VALID before the upgrade.
Check for Username and Role by name
MIGRATE or OUTLN.
Check for corruption in the dictionary
Ensure no files need media recovery.
Ensure no files are in backup mode.
Stop the listener for the database.
Ensure the users sys and system have 'system' as their default tablespace.
Note down all sysdba users and copy the pwd file to the new oracle home
Check for adequate freespace around 30% on archive log destination file systems. Please monitor the space
during upgrade.
Ensure the NLS_LANG variable is set correctly from quering nls_database_parameters.
Create a SYSAUX tablespace.
Shutdown the database
Change the init.ora file
Create soft link of init$ORACLE_SID.ora file in the new $NEW_ORACLE_HOME
Migration
======
Update the oratab entry, to set the new ORACLE_HOME.
Make sure the enviroment variables point to the new release directories.
Run the upgrade script
Post-upgrade Status Tool
Restart the database.
Run script to recompile invalid pl/sql modules.
Changes in init.ora
Bounce database in restricted mode.
Creating spfile
Modify the listener.ora file.
Post Migration
=========
Check whether the listener is started and running.
Crosscheck oracle profile has all the variables set properly as mentioned in the Migration tab page.
Trigger Backup jobs.
Release the system to application folks and keep a close eye for the database for any issues related
to the connectivity issues of users if any.
Rollback plan
=========
Disable all batch and cron jobs.
Stop the listener
Shutdown the database
Restore the old files viz. listener.ora,oratab,tnsnames.ora in the location $TNS_ADMIN
Restore the old profile of the 'oracle' user i.e. "".login"" file under $HOME location
Restore the old file 'init$ORACLE_SID.ora' in $ORACLE_BASE/admin/$ORACLE_SID/pfile location
Restore the database from backup
Start the listener
Start the database.
Ensure no files need media recovery.
Ensure no files are in backup mode.
Check whether the listener is started and running.
Enable crontab entries.
Release the system to application folks and keep a close eye for the database for any issues related
to the connectivity issues of users if any.
Questions or comments? Feel free to post them here. No login or id required.
