Re: migration from oracle 8i to 9i

"Anna C. Dent" <anacdent_at_hotmail.com> wrote in message news:<YdKvb.13271$kl6.4033_at_fed1read03>...
> susmita_ganguly_at_yahoo.com wrote:
> > Hi
> >
> > I am trying to upgrade from oracle 8i to oracle 9i on the same server
> > .I don't know much abt migration .
> >
> > Can anyone help me out.
>
> Go RTFM on dbua

Perform the following steps

1. Check for Vesions and Options
2. Perform COLD Backup
3. Increase SYSTEM rollback segment size and ensure plenty space free in ROLLBACK segments
4. Check o/s level patch and check certification i.e. showrev -p
5. List all INVALID objects before upgrade
6. Ensure SID and ORACLE_HOME set properly.
7. Ensure no user or role as MIGRATE and OUTLN exists ( if migrating from 8.0.6)
8. Check no corruption in sys dictionary. Prepare a script 'ANALYZE ' || object_name || ' valid structure ;' where owner = 'SYS'
9. Stop Replication and ensure all snapshots refreshes complete.
10. Stop Listner
11. Ensure no files need media recovery: v$recover_file
12. Ensure no files are in backup mode: v$backup
13. Resolve any outstanding unresolved distributed transaction: dba_2pc_pending ( dbms_transaction.purge_lost_db_entry('local_trans_id') )
14. Disable all bacth and cronjobs task.
15. Note Down all controlfile location and sysdba users: v$pwfile_users
16. Shutdown DB
17. Backup of init.ora , listener.ora and tnsnames.ora and needs few changes in init.ora file job_queue_process=0 _SYSTEM_TRIG_ENABLED=FALSE unset COMPATIABLE REMOTE_LOGIN_PASSWORDFILE=NONE (if using password file)
18. update oratab entry with new ORACLE_HOME
19. update environment variable
    • ORACLE_HOME
    • PATH
    • ORA_NLS33
    • ORACLE_BASE
    • LD_LIBRARY_PATH
    • ORACLE_PATH
20. Run Upgrade script : cd $ORACLE_HOME/rdbms/admin Sqlplus /as sysdba startup restrict or startup migrate _at_u0801070.sql or u0900010.sql
21. Run _at_utlrp
22. Shutdown immediate
23. Modify Listner.ora with new ORACLE_HOME
24. Enable cronjob and batch
25. Change oratab entry
26. Start the Database