Re: Intermittent TNS-12203 connection error

Hello Calvin:

    Your hardware/operating system may have a limit of the number of simultaneous connections. If you exceed the limit users trying to log on will get messages similar to the ones you listed.

Van

Calvin Cheong wrote in message <364fea1e.18546065_at_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 - 20:27:47 CST