5 Replies Latest reply: Sep 2, 2013 8:04 AM by David de Vega RSS

    export/import from 9.2.0.1 to 11.2.0.2 64bit and IMP-00009 error

    David de Vega

      Hi.

       

      I want to export/import two schemas from my old 9i database to a new 11gR2.

      I did this several times, but this time I'm facing an error that is making me crazy. I hope some one can tell me what I'm missing

       

      The scenario.
      Old machine: RedHat 8 with Oracle DB 9.2.0.1.

      New machine: RHEL 5.7 64bit with Oracle DB 11.2.0.2 64 bit.

       

      So, in the old machine, I export the users with a parameter file as following:

      /home/oracle/exptmp/exp_parameters.par:

      file=/home/oracle/exptmp/NESE_20130829.dmp
      owner=nese
      compress=n
      grants=y
      indexes=y
      log=exp_NESE_20130829.log
      rows=y
      statistics=none
      
      
      

       

      And then.

      $ cd /home/oracle/exptmp/
      $ exp system/*******@resesdb parfile=exp_parameters.par
      
      Export: Release 9.2.0.1.0 - Production on Vie Ago 30 12:07:07 2013
      
      Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
      
      Conectado a: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
      With the Partitioning and Oracle Data Mining options
      JServer Release 9.2.0.1.0 - Production
      Exportación realizada en el juego de caracteres WE8ISO8859P1 y el juego de caracteres NCHAR AL16UTF16
      
      Exportando los usuarios especificados ...
      [...]
      La exportación ha terminado correctamente y sin advertencias.
      
      Export: Release 9.2.0.1.0 - Production on Vie Ago 30 13:08:18 2013
      
      Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
      $
      

       

       

      I copy with SCP the dump file (scp, since it transfer files only in binary mode. I've also tried with SFTP but had the same result)

       

      $ scp NESE_20130829.dmp oracle@***.***.***.78:/home/oracle/imptmp/
      oracle@***.***.***.78's password:
      NESE_20130829.dmp  100% |*******************************************************************************************************|
      
      
      

       

      In new machine:

      "NESE" user and necessary tablespaces/datafiles were already created.

       

      $ ls -la /home/oracle/imptmp/NESE_20130829.dmp
      -rwxr-xr-x 1 oracle oinstall 6196510720 ago 30 14:07 /home/oracle/imptmp/NESE_20130829.dmp
      
      
      

       

      I use a parameter file for import.

      /home/oracle/imptmp/imp_parameters.par

      file=/home/oracle/imptmp/NESE_20130829.dmp
      fromuser=nese
      touser=nese
      commit=y
      grants=y
      ignore=y
      indexes=y
      log=import_nese_20130829.log
      rows=y
      
      
      

       

      But when I perform the import, then:

      $ cd /home/oracle/imptmp/
      $ imp system/*******@seresdb file=imp_parameters.par
      
      
      Import: Release 11.2.0.2.0 - Production on Vie Ago 30 14:13:45 2013
      
      
      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
      
      
      Conectado a: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      
      
      IMP-00009: abnormal end of export file
      IMP-00000: Import terminated unsuccessfully
      $
      
      
      

       

      And that's all. I don't know what else to do.

      In MOS there's barely information about this error, except if you had transfer the file through FTP in ascii mode.

       

      There's something I'm missing?

      Any idea?

       

      Regards