When creating database with control file, It does not require the temp file. It creates its own temp file. When upgrading it was looking for the temp file where it cannot see.
If you have not copied the temp file then its not there. It will not create its own temp file. Had it created its own temp file then it would have known where the tempfile resides and not look for it in some other place.


My database name DB1, when I upgraded it created DB10 file under ORACLE_BASE/admin directory. Can I delete that directory. I guess it stores all updated log information. Is that directory used by 9i database.
What ORACLE_BASE ? Is it Oracle9i BASE or Oracle8i Base ?


Adding to above, Under that directory there are init files created by upgrade. Should I copy 9i init file to the original directory pfile/initfile?? I am getting lil confused after the upgradation what steps should be done.
After migration check for any invalid objects in the database. Validate them.

Make sure that the applications which are using the existing database are running on the new migrated database. If not then you need to make changes in the application to make them run.