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

thanks for your help.

so i need to have a tnsnames.ora file before i run the "imp" command? if so, is it ok to copy the old tnsnames.ora file over from 8i to 9i, just changing the computer name where needed?

john

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E149E18.1AAA2C5_at_exesolutions.com...
> 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:49:19 CST