SP-0310: unable to open file ".."

[lyang]

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.

[John Spencer]

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

[lyang]

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.

[davey23uk]

what is you environment set up like

[John Spencer]

It sounds like you are on Windows. You need to start the Oracle Service before you can start the database.

John

[lyang]

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

[hrishy]

Hi

Something wrong with your environment variables.

echo $PATH and see which home appears first 9i or 8i.

regards
Hrishy

[lyang]

It appears 9i when echo $PATH and $ORACLE_HOME.

[bazza]

Why are you changing the sid???!?!?!?!?

Here is the story.

$ORACLE_SID=orcl
...
I did the following

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