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

You may also want to look at SQLPorter.

from realsoftstudio.com

Hope this helps.

Tore Skogly <tore.skogly_at_c2i.net> wrote in message news:<1041728043.494669_at_a217-118-32-43.bluecom.no>...
> John Merkel III wrote:
>
> > 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,
> >
>
> Have the listener been started on your new database?
Received on Sun Jan 05 2003 - 22:25:45 CST