cannot connect with JDBC THIN driver to ORACLE 8
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(neworacle.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 anyexceptions.
Any help is appreciated.
Hilz. Received on Tue Jun 24 2003 - 04:17:34 CEST