DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Jan 2002
    Posts
    42

    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.

  2. #2
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    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

  3. #3
    Join Date
    Jan 2002
    Posts
    42
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what is you environment set up like

  5. #5
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    It sounds like you are on Windows. You need to start the Oracle Service before you can start the database.

    John

  6. #6
    Join Date
    Jan 2002
    Posts
    42
    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

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Something wrong with your environment variables.

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

    regards
    Hrishy

  8. #8
    Join Date
    Jan 2002
    Posts
    42
    It appears 9i when echo $PATH and $ORACLE_HOME.

  9. #9
    Join Date
    Jul 2002
    Posts
    335
    Why are you changing the sid???!?!?!?!?

    Quote 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width