Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2003
    Location
    Duesseldorf - Germany - Europe - Earth - Galaxy
    Posts
    18

    Unanswered: Problem with export/import between 9i (source) and 8.1.7 /dest)

    Hi,

    We have to export an oracle db from a 9i system and move it to an 8.1.7 system. Export on 9i works fine but importing it we get the

    IMP-00010: not a valid export file, header failed verification

    when trying to import on 8.1.7. I suspect it's a version mismatch since on another 9i we can import it. I tried to put an entry for the 9i instance in the tnsnames.ora on the 8.1.7 system and I could connect with it and issue sqls vie sql*plus. But exporting the 9i database vie the net*80 results in the error:

    EXP-00056: ORACLE error 12538 encountered
    ORA-12538: TNS:no such protocol adapter

    So I need hints either how to export on 9i in an way that is imported by 8.1.7 oder how to mange exporting th 9i fvia net*80 on the 8.1.7

    I don't think ist that exotic so I hope someone could give a newbie some hints ;-)

    Regards,
    Volker.

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Volker,

    When you connect to the 8.1.7 system from 9i, I suspect you are trying it as "/ as sysdba". Since I am assuming your 9i system is on a different computer from your 8.1.7, there would be no way to authenticate the "/" user in such a way that 8.1.7 would understand.

    Suggest that when you invoke export, use "sys@sid as sysdba" to log in.

    Hope this helps.

    JoeB

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you are doing a FULL export of 9i, you will not be able to put it in an 8i database. The structure has changed !!!!

    If you are looking to pull a particular schema, I would ...

    1. From the 8i machine,
    exp username/password@9i_sid file=xxx user=schemaname
    2. From the 8i machine
    imp username/password@8i_sid file=xxx full=y ignore=y etc ...

    HTH
    Gregg

  4. #4
    Join Date
    Dec 2003
    Location
    Duesseldorf - Germany - Europe - Earth - Galaxy
    Posts
    18
    Gregg,

    thank you. I tried it with exporting only the user's schema on 9i and then importing it on 8i but...

    imp "/" file=dump9i.dmp full=yes ignore=yes

    Import: Release 8.1.7.4.0 - Production on Tue Mar 30 07:24:45 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - Production

    IMP-00010: not a valid export file, header failed verification
    IMP-00000: Import terminated unsuccessfully
    I also tried imp with owner=.... instead of full=y - the same error.

    Any ideas...? clueless,

    Volker.

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by VolkerK
    Gregg,

    thank you. I tried it with exporting only the user's schema on 9i and then importing it on 8i but...



    I also tried imp with owner=.... instead of full=y - the same error.

    Any ideas...? clueless,

    Volker.
    you can't use imp into an 8i Instance using a 9i dmp-File

    use 8i exp to export 9i and then you should be able to imp into 8i...

  6. #6
    Join Date
    Dec 2003
    Location
    Duesseldorf - Germany - Europe - Earth - Galaxy
    Posts
    18
    Hi Osy,

    thanks, but how to? I've copied the im from 8.1.7 to 9i and tried to execute:

    EXP-00056:
    EXP-00000: Export terminated unsuccessfully
    Nothing more. Trying via net80 from 8.1.7 it results in

    EXP-00056: ORACLE error 12538 encountered
    ORA-12538: TNS:no such protocol adapter
    EXP-00000: Export terminated unsuccessfully
    Still clueless,
    Volker.

  7. #7
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by VolkerK
    Hi Osy,

    thanks, but how to? I've copied the im from 8.1.7 to 9i and tried to execute:



    Nothing more. Trying via net80 from 8.1.7 it results in



    Still clueless,
    Volker.
    you didn't mention still using net80 and not the 8i client, which should work.
    And it will not work to copy the imp/exp util into 9i bin directory. You need to run the 8i imp ultility using 8i client
    start you exp from $ORACLE_HOME_8i/bin/exp sys/<pwd>@SID9i file=8formatexp.dmp full=y buffer=16000000 log=yourlog

    then
    start imp from $ORACLE_HOME_8i/bin/imp sys/<pwd>@SID8i file=file=8formatexp.dmp full=y buffer=16000000 log=yourlog fromuser=(<usr1>, <usr2>, ... <usr[n]>) touser=(<usr1>, <usr2>, ... <usr[n]>)
    another option to copy the data is : create a database link for the 9i database on 8i and then
    write a generic script with

    insert into <table> (col1, col2, ... col<n>) select * from <dblinkded_table>;

  8. #8
    Join Date
    Apr 2004
    Posts
    35

    Re: Problem with export/import between 9i (source) and 8.1.7 /dest)

    hello
    create tnsnames "abc" using the service name and system name for 9i system in 8i installed computer and then in oracle 8i system
    run in 8i system
    exp username/password@abc owner=123 compress=n ...
    and then
    in 8i system
    imp owner=123 ...
    i tried just today as is was facing the same probelm.
    this will be ok

    Originally posted by VolkerK
    Hi,

    We have to export an oracle db from a 9i system and move it to an 8.1.7 system. Export on 9i works fine but importing it we get the

    IMP-00010: not a valid export file, header failed verification

    when trying to import on 8.1.7. I suspect it's a version mismatch since on another 9i we can import it. I tried to put an entry for the 9i instance in the tnsnames.ora on the 8.1.7 system and I could connect with it and issue sqls vie sql*plus. But exporting the 9i database vie the net*80 results in the error:

    EXP-00056: ORACLE error 12538 encountered
    ORA-12538: TNS:no such protocol adapter

    So I need hints either how to export on 9i in an way that is imported by 8.1.7 oder how to mange exporting th 9i fvia net*80 on the 8.1.7

    I don't think ist that exotic so I hope someone could give a newbie some hints ;-)

    Regards,
    Volker.

  9. #9
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Could try this out as once I faced the same problem of exporting from a higher version and importing to a lower version of Oracle DB.

    Run the catexp.sql of Oracle 8i on Oracle 9i database.
    Then take the export from 9i and thereafter import it in 8i.

    But if there are any structural changes which is supported by 9i and not by 8i then the problem might get recreated.

    Hope it helps....

    Regards,
    Kaushik

  10. #10
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    3
    Hi friend

    if you still dont have the answer--

    there should be an exp for 8.1.7 in your oracle 9i db server use that exp instead of using 9i exp then that will help you importing into 8.1.7 db
    this is something backward compatability

    if you have any other way please let me know

    Uday

Posting Permissions

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