Re: ORA-12571 error

In article <0vnukv4f7se2jaj3tmggjfplseqtvs66m4_at_4ax.com>, nospam_at_noway.nohow says...
> On Fri, 29 Aug 2003 15:43:00 +0200, Alain Migeon <agm_at_dk.rovsing>
> wrote:
>
> >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
> >
> I'd guess that you didn't tell the application side (via the
> tnsnames.ora file) that the DB is on the same machine. Configure your
> connection description to use IPC instead of TCP. This will involve
> both your TNSNAMES file (to tell it to use IPC) and your LISTENER.ORA
> file (to tell the listener to be listening for IPC calls as well as
> TCP).
>

Thanks for all answers.

I have a server in C++, but there is also an user interface in Java, using Jdbc. According what I have read, TCP/IP is mandatory for Java. In that case, is modifying the host in the tnsnames.ora file the only solution?
I can also implement a reconnect from my server, but this will mean more work, since I will have to implement a redo of the last request to the database.

Alain Received on Mon Sep 01 2003 - 03:06:07 CDT