Connection problem ORA 12535 TNS Timeout

From: Bernd Maierhofer \(dato\) <bernd.maierhofer_at_dato.at>
Date: Wed, 25 Feb 2004 17:46:58 GMT
Message-ID: <mc5%b.76818$174.71933@news.chello.at>

Hi and thanks for reading. My configuration is as follows:

Oracle 8.i 8.1.5 Client and Server
Server installed in a Win2K Professional VMWare Box, a database is up and running, connecting locally (loopback) works ok Client is installed on a Win2k machine

TNSPing can reach the database, times are about 9000 msec, sometimes 3000 msec

Connecting from the client fails, the sql.log on the server says: Fatal NI connect error 12160, connecting to:  (LOCAL=NO)   VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.1.5.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
  Time: 25-FEB-04 18:35:04
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: -1
    TNS-4294967Message -1 not found; product=NETWORK; facility=TNS

    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

The listener says:
Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))(PROTOCOL_STACK
=(PRESENTATION=TTC)(SESSION=NS)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-FEB-04 18:03:51 * service_register * BF * 0
25-FEB-04 18:03:51 * service_register * BF * 0

25-FEB-04 18:05:11 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUS.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3340)) * establish * bf * 0
25-FEB-04 18:09:01 * ping * 0
25-FEB-04 18:11:05 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * establish * bf * 0
25-FEB-04 18:13:54 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * service_update * BF
* 0
25-FEB-04 18:13:54 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * service_update * BF
* 0
25-FEB-04 18:15:36 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * establish * bf * 0
25-FEB-04 18:23:51 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * service_update * BF
* 0
25-FEB-04 18:23:51 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * service_update * BF
* 0
25-FEB-04 18:24:04 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(GLOBAL_NAME=bf)(CID=(PROGR
AM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=ORACLE)(USER=Administrat or))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.19)(PORT=1221)) * establish * bf * 0
25-FEB-04 18:24:34 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3369)) * establish * bf * 0

I already tried to increase the connection_timeout, but this does not help.

Thanks for any idea.
Bernd Received on Wed Feb 25 2004 - 11:46:58 CST