Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the odma default execution will want to start that database before it upgrades the datafiles. On top of that, I would want my test upgrades to mimic the production upgrades as closely as possible.
With that in mind, I would reinstall 8.0.5 under 5.8, and proceed from there. Mike Hand Polaroid Corp. -----Original Message----- Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).