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

thanks for your help...

in addition to steps 1-5 below i have now also copied over my tnsnams.ora file and listener.ora file from the 8i DB, editing them and changing the host name since my comuputer name changed when i replaced the HD. when i try to run imp i get exactly the same error message as i reported below. when i try to log on using sql plus i get the following error message:

ORA-12541: TNS:no listener

i may very well not me doing something completely obvious to you, as i'm not a DBA at all. so don't feel like you might insult me if i'm missing something that seems simple to you.

thanks again for all your help,

john

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0301021706.2091d513_at_posting.google.com...
> "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 Sat Jan 04 2003 - 18:54:46 CST