JDBC to Oracle 817 - The network adapter could not establish the connection

From: Rick (rickgeorge_at_kingwoodcable.com)
Date: 01/07/04 

Date: 7 Jan 2004 13:51:10 -0800

ok, i have a strange one... I was running 815 on NT. I upgraded this
to 817 and had a load of new problems. Originally, I could connect to
the instance from the server itself, but as other clients would
attempt connections, they would get the ORA 12545 error. If i stopped
and restarted the listeners on the server, a remote client could
connect, but others would fail. If i disconnected the successfully
connected client, then attempted to reconnect, it would fail. Recycle
the listener, and I could repeat this process from a different client.
 In my case, clients are EAServer connection caches, PowerBuilder,
DBArtisan, or SQLPlus. I searched google, found some settings that
seemed to help...such as maximum wait, tns wait, dedicated server.
After changing these settings, i was able to server any clients using
the OCI interface, but now my JDBC connections fail with the "Network
adapter could not establish the connection" error. Same deal, if i
recycle the listener, the first JDBC attempt will work, no others
can...and a disconnect/reconnect will fail too. Its hard to think
this is a TNS/SQLNet/Listener problem since I can connect successfully
once, then not again. I ran the database migration assistant to get
this instance from 815 to 817 and all these problems surfaced. All
was fine before. I installed the 817 image from the oracle
site..which i think is release 3. I'm not using NTS authentication.

Thanks,

Rick

Relevant Pages

  • Re: MsgCommunicator v.2.00: Instant Messenger SDK, now with databases support
    ... expect persistent connections. ... they will wait for the server to pick them up. ... your Clients can stay "off-line" for about 30 minutes before they have to ... requests *simultaneously*. ...
    (borland.public.delphi.thirdpartytools.general)
  • sockets, closing and TIME_WAIT
    ... During heavy load the server can't follow anymore because the sockets ... my server should be able to handle 10 clients connecting ... This gets a free position in the array of connections, ...
    (comp.unix.programmer)
  • Re: TCP/IP redundant connections
    ... The clients have persistent TCP connections to the server, ...
    (freebsd-hackers)
  • Re: Intermittent Network Connections
    ... I've just reconnected the Server LAN nic 1 to the ethernet switch (the same ... Server IP config and Client IP config attached. ... > turn is connected to an ADSL modem out to the internet The clients connect to ... >> Clients can sucessfully log in but periodically loose their connections. ...
    (microsoft.public.windows.server.sbs)
  • Intermittent intra-LAN connectivity
    ... other desktops and their server produces strange ... The clients cannot get files ... Replaced all hubs with switches. ... connections for all interfaces and was rebooted. ...
    (microsoft.public.win2000.networking)