this is actually what i need to do.
i currently have a database running on 8.1.6 software. this morning i installed 8.1.7 software into a different directory. i now need to make a copy of the 8.1.6 database but make it run the 8.1.7 software. i plan to shutdown 8.1.6 database. copy all datafiles/logfiles/... to new location. i then plan to recreate the control files with the new database name. i have done this several times successfully but never attempted to uprade at the same time. all i have to do is chance the $ORACLE_HOME and $ORACLE_SID variables prior to doing this?? ...that seems to easy.
this is all being done on hp-ux11 (probably unnecessary info)
The way I would do it is:
1. clone the 8.1.6 database (you have the steps)
2. startup the cloned database with 8.1.6 and shutdown normal
3. set your environment variables for 8.1.7
4. migrate the cloned database to 8.1.7 using the migration assistant (odma on solaris).
Click Here to Expand Forum to Full Width