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

"John Merkel III" <merkeliiii_at_earthlink.net> wrote in message news:<Kf_Q9.8320$134.947293_at_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:
>
> 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

John, the 12560 would indicate a ORANET (formerly SQLNET, NET8) error.  Are you sure you successfully completed a full install? Did you configure the Listener? Are the Oracle services running?

Good luck -- Mark -- Received on Thu Jan 02 2003 - 19:06:35 CST