Re: Connection problem ORA 12535 TNS Timeout

Bernd Maierhofer (dato) wrote:

> 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

Looks like a network configuration issue to me. What is the ping (not tnsping) time?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)