I am doing migrate database form 8.1.7 to 9.2.0, there is an error message 'SP-0310:upable to open file "@u0801070.sql"'. Any suggestion? Thanks.
Printable View
I am doing migrate database form 8.1.7 to 9.2.0, there is an error message 'SP-0310:upable to open file "@u0801070.sql"'. Any suggestion? Thanks.
Unless you started the sqlplus session from $ORACLE_HOME/rdbms/admin (or the Windows equivalent), then you need to specify the complete path to the file.
To save some typing, within sqlplus ? is equivalent to ORACLE_HOME, so you can do:
@?/rdbms/admin/u0801070
HTH
John
John,
I haven't tried the absolute path yet, but restarted the database by using 'shutdown immediate' and 'startup'. then I got the following error message.
ora-24324: service handle not initialized
ora-01041: internal error. hostdef extension doesn't exist
Now I could not start up the database any more.
what is you environment set up like
It sounds like you are on Windows. You need to start the Oracle Service before you can start the database.
John
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
Hi
Something wrong with your environment variables.
echo $PATH and see which home appears first 9i or 8i.
regards
Hrishy
It appears 9i when echo $PATH and $ORACLE_HOME.
Why are you changing the sid???!?!?!?!?
Quote:
Originally Posted by lyang