Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12571 error

Re: ORA-12571 error

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 29 Aug 2003 09:17:27 -0500
Message-ID: <0vnukv4f7se2jaj3tmggjfplseqtvs66m4@4ax.com>


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). Received on Fri Aug 29 2003 - 09:17:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US