Problem with migration 32-64bit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Problem with migration 32-64bit

  1. #1
    Join Date
    Jul 2007
    Posts
    4

    Question Problem with migration 32-64bit

    I'm trying to migrate from 10.1-32 to 10.2-64.
    IMPDP doesn't want to work. What should I do?

    Import: Release 10.2.0.1.0 - 64bit Production on Monday, 02 July, 2007 21:35:01

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning and Data Mining options
    UDI-00018: Import utility version can not be more recent than the Data Pump server.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    00018, 00000, "Import utility version can not be more recent than the Data Pump server."
    // *Cause: The Import utility is at a higher version than the database
    // version and is thereby incompatible.
    // *Action: Use the same version of Import utility as the database.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2007
    Posts
    4
    No, it's not newer than server. It's newer than dump, created by 10.1

    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for Linux: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    SQL> quit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    [oracle@db1 ~]$ impdp system/svsys@SV full=Y directory=BACKUP dumpfile=EXPDAT01-29062007.DMP logfile=import.log

    Import: Release 10.2.0.1.0 - 64bit Production on Monday, 02 July, 2007 22:44:15

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning and Data Mining options
    UDI-00018: Import utility version can not be more recent than the Data Pump server.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you are using 10.1 impdp?

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Use 10.2 executable Expdp/Impdp to export and import 10.1 db.

  6. #6
    Join Date
    Jul 2007
    Posts
    4
    I am not using. Data pump is 10.2, but dump-file is made bu 10.1

  7. #7
    Join Date
    Jul 2007
    Posts
    4
    do you mean I should copy 10.2-expdp to 10.1-machine and run export?

  8. #8
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Install a separate 10.2 ORA home and use its exe's is a workaround.

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Can u please specify the exact command line u use for import

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