Re: cannot connect with JDBC THIN driver to ORACLE 8

Update to the problem.

I discovered that if i stop the following services and start them again, it will work
OraclSerciveORCL
OracleStartORCL
OracleTNSListener80

but once i restart the machine, i start having the same problem all over again, and i have to restart those services again to get it to work.

does anyone know what is the problem? and what is the permanent solution that is better than manually restarting the services?

many thanks
hilz

• Original Message ----- From: "hilz" <hs_74_at_hotmail.com> Newsgroups: comp.databases.oracle Sent: Monday, June 23, 2003 10:17 PM Subject: cannot connect with JDBC THIN driver to ORACLE 8

> 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.
>
>
>
>

"hilz" <hs_74_at_hotmail.com> wrote in message news: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 - 05:58:31 CEST