Modifying the tnsnames.ora file is probably the best thing you can do, but
did I did a work around by adding an entry into the hosts file located in
the win2k system23/etc directory.
I put the name of the box with the ip address listed from
running "ipconfig" at the command prompt.
Hope that helps.
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:qvJ3b.29582$pK2.46513_at_news.indigo.ie...
> the hostname in tnsnames is not set to localhost probably so DNS lookup
> fails since you plugged the cable out.
> "Alain Migeon" <agm_at_dk.rovsing> wrote in message
> news:MPG.19b976d39ff3d58a989682_at_news.cybercity.dk...
> > Hi
> >
> > I have, on a Win2000 machine, an Oracle database, version 8.1.7. On the
> > same machine, I have a server connecting to this database.
> >
> > I start my server which connect at start up to Oracle. Everything is
> > working fine, and then if some network problems occur (I just unplug the
> > network cable to reproduce the error), I got the ORA-12571 error
> > (TNS:packet writer failure), followed by the ORA-03114 (not connected to
> > ORACLE).
> >
> > Since my database and my server are on the same machine, why do I get
> > this error?
> >
> > Thanks in advance.
> >
> > Alain
> >
> >
>
>
Received on Mon Sep 01 2003 - 01:15:39 CDT
