-
SP-0310: unable to open file ".."
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
-
Why are you changing the sid???!?!?!?!?
Originally Posted by lyang
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
-
It appears 9i when echo $PATH and $ORACLE_HOME.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|