Here is the story.

I created a database instance running on 8.1.7 on HP server. Followed the document to upgrade to 9.2.0.1. Our environmentsetting is

$ORACLE_HOME=/.../9.2.0.1
$ORACLE_SID=orcl
...
I did the following

$ Export $ORACLE_HOME=/../8.1.7
$ Export $PATH=$ORACLE_HOME/bin:$PATH
$ Export $ORACLE_SID=newdb

sqlplus /nolog
SQL> connect /as sysdba
SQL> shutdown immediate
quit

$ CP datafile datafile.bak

$ Export $ORACLE_HOME=/../9.2.0.1
$ Export $PATH=$ORACLE_HOME/bin:$PATH
$ Export $ORACLE_SID=newdb

echo each variable, they are on the new release directories.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> connect /as sydba
SQL> startup migrate
run u0801070.sql and got error message ''SP-0310:upable to open file ...'
Whenever I tried to shutdown and startup database and goet the error messages since then.

ora-24324: service handle not initialized
ora-01041: internal error. hostdef extension doesn't exist