JDBC connection refused

From: Dave Wilson <dlwilson_at_evcom.net>
Date: Tue, 24 Apr 2001 18:19:14 GMT
Message-ID: <CsjF6.24364$u7.11487384_at_e3500-chi1.usenetserver.com>

I have an applet which uses the JDBC thin driver to connect to Solaris servers running Oracle8 and to WinNT notebooks running Personal Oracle 7.3.4. It always works with the Solaris servers, and usually works with Personal Oracle.

But sometimes connecting to a fresh installation of Personal Oracle will generate the error message "Connection Refused: no further information." Using SQL Plus works fine, as does the legacy app, which uses Pro*C. We find that we can sometimes fix the problem by changing from a DHCP address to a static IP address, but this is not really a valid solution.

The guy doing the Personal Oracle installations is doing each one by hand, and is relying on a handwritten set of instructions from the last guy, so there may be some variation there.

We are using the default LISTENER.ora file, and there is no TNSNAMES.ora file installed by default. I am using the host name to connect.

Appended is the LISTENER.ora file for the machine pcu21614. I will be happy to mail out any other files that might help.

I am not an Oracle person, but the local DBAs disavow all knowledge of Personal Oracle. Can anybody point me to a reference that might explain when Oracle uses TCP/IP, and when it uses some mysterious network layer that does not require TCP/IP?

thanks for any help,
Dave Wilson

---

LISTENER.ora

---

################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20

################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= oracle.world)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= ORCL)


        )
        (ADDRESS=


          (COMMUNITY= NMP.world)

          (PROTOCOL= NMP)

          (SERVER= PCU21614)


          (PIPE= ORAPIPE)


        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (Host = pcu21614)

          (PROTOCOL= TCP)


          (Port= 1521)


        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (Host = pcu21614)

          (PROTOCOL= TCP)


          (Port= 1526)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle) Received on Tue Apr 24 2001 - 20:19:14 CEST