8 Replies Latest reply: Dec 2, 2011 11:36 AM by 860606 RSS

    Import data to 9i from 11g export error.

      Dear All,

      My new production server has 11g up running. I like to move data from the 11g to the legacy system of 9i as a backup server. Both servers are Linux. Both 9i and 11g clients are installed on a XP computer. I found the information that I need to use 9i exp on 11g and 9i imp to 9i database. If this is the way, can someone help me to clarify it more? What exactly do I need to do? Thank you in advance for your help! Here is what I did and received an error.

      On the XP Oracle client side:

      Copied 9i's exp.exe to 11g BIN directory. Then execute C:\product\11.2.0\client_1\bin\exp user/passwd@RESRCH STATISTICS=none FILE=AriesExport.dmp TABLES=(DATASRC,DATASET,SUBTASK_PARMS,EXPERIMENTER,CHANNELS,COILS,SPEAKERS,LEDS,TRIAL,TS_DATA)
      It created an error of ORA-12541 no listener. Needless to say, the database is working fine.

      If use the original 11g's exp.exe, the above command runs successfully.

      The 11g tnsnames.ora in C:\product\11.2.0\client_1\network\admin
      RESRCH =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = 1521))