- Copy datafiles to another mountpoint.
- Copy init.ora file to $ORACLE_HOME with user oratest or oraprod
- Generate the cloning script with RESETLOGS option and the new database name.
- Made new entry into /etc/oratab with the new database name.
- clone the database
- alter database open resetlogs
- add temp file into temp tablespace
- from oracle 10g home bin directory run dbua
- Preserve current db settings.
- To check the status of the upgrade run the following query:
select comp_name, status, version from dba_registry;
- Check all the components. Compare to the original database components and make sure that all options that are ON are upgraded accordingly.