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

John Merkel III wrote:

> 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:
>
> 1. installed win2k on the new HD
>
> 2. installed oracle 9i on the new HD
>
> 3. 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

There is not technical problem doing what you are trying to do. It sounds like your 9i Oracle installation is invalid likely related to an environment variable like ORACLE_SID or the entry in TNSNAMES.ORA.

Test out the 9i instance through SQL*Plus.

Daniel Morgan Received on Thu Jan 02 2003 - 14:16:24 CST