Intermittent TNS-12203 connection error

From: Calvin Cheong <ccheong_at_letterbox.com>
Date: Mon, 16 Nov 1998 09:24:15 GMT
Message-ID: <364fea1e.18546065@news.pacific.net.sg>

Hi

We have a batch job that performs a string of transactions against the database. And this program is guaranteed a working copy. I have also verified that the values in tnsnames.ora and listener.ora are the same.

On some occasions, it would fail 1 of the several SQL*PLUS connections (see the error captured below) in that job. For example, it wouldn't connect on the 2nd SQL*PLUS but succeeded on the 1st and 3rd through to the 6th.

On other days, it would successfully connect to all without problems!

Can anyone out there provide some logical explanation to this connection problem?

Much appreciated.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SQL*Loader: Release 7.3.2.3.2 - Production on Mon Nov 16 12:00:16 1998

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

SQL*Loader-925: Error while logging on to ORACLE (ulmconnect) ORA-12203: TNS:unable to connect to destination

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Product Versions:

OpenVMS 7.1
RDBMS 7.3.2.3.2
SQL*Plus: Release 3.3.2.0.1
LSNRCTL for VMS: Version 2.3.2.1.3 Received on Mon Nov 16 1998 - 03:24:15 CST