HELP: exp/imp migration from oracle 8i to oracle 9i

From: John Merkel III <merkeliiii_at_earthlink.net>
Date: Thu, 02 Jan 2003 17:01:30 GMT
Message-ID: <Kf_Q9.8320$134.947293@newsread1.prod.itd.earthlink.net>

i'm attempting to move my oracle 8i personal edition DB which is on win2k to an oracle 9i personal edition DB which i am running on win2k (i'm swapping out hard drives on the same computer).

here is what i did:

installed win2k on the new HD
installed oracle 9i on the new HD
booted up the old HD and ran

exp system/manager file=nnexpdat30dec02.dmp full=y

4. moved the nnexpdat30dec02.dmp file to the new HD

5. booted up the new HD and ran

imp system/manager file=nnexpdat30dec02.dmp full=y

when i did this i get the following errors:

IMP-00058: ORACLE error 12560 encountered

ORA-12560: TNS:protocol adapter error

IMP-00000: Import terminated unsuccessfully

could this have something to do with my computer name changing when i installed win2k on the new HD? or am i trying to make this a much simpler process than it really is? what do i need to do to move my DB over?

any help would be greatly appreciated.

thank you in advance,

john Received on Thu Jan 02 2003 - 11:01:30 CST