cannot connect with JDBC THIN driver to ORACLE 8

From: hilz <hs_74_at_hotmail.com>
Date: Mon, 23 Jun 2003 22:17:34 -0400
Message-ID: <pS2dnf5DKelrL2qjXTWcpw_at_speakeasy.net>


Hi all,
I have installed oracle on 2 machines (HOST_A and HOST_B). The installation was the typical default installation, with the preconfigured standard database that comes with the installation.

I started by trying to connect to each of the servers using a small java program, using the JDBC THIN driver(TCP/IP connection). When i try to connect to HOST_A, i run the java program on HOST_A, and when i try to connect to HOST_B, i run the program on HOST_B. (i.e. i am trying local connections and not over the network).

the weird thing is that the connection works on HOST_A but not on HOST_B, even though the two installations are identical, and the java program is identical.
the java call "DriverManager.getConnection(...)" just freezes. it does not thorw an exception.

but in the listener.log i get this message:

23-JUN-03 21:37:30 * 12532
TNS-12532: TNS:invalid argument
 TNS-12560: TNS:protocol adapter error
  TNS-00502: Invalid argument
   32-bit Windows Error: 22: Invalid argument

can anyone tell me what could be wrong or help me solving this problem?

here is the end of the file listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = HOST_B)
(SID_NAME = ORCL)

    )
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)

    )
  )

and in the java program, i have the following:

        try{
            DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());

            String url = "jdbc:oracle:thin:_at_HOST_B:1521:orcl";

            Connection conn = DriverManager.getConnection(
                url,
                "scott",
                "tiger"); //this call just freezes, without thorwing any
exceptions.

Any help is appreciated.

Hilz. Received on Tue Jun 24 2003 - 04:17:34 CEST

Original text of this message