ORA-12535: TNS:operation timed out on a win2000 Oracle instance
Markus Driller
i have a Oracle 8.1.5 instance on a WIN2000 PC.
I can connect me to this database with sqlplus
as long i stay on the PC (means i started the sqlplus
on the same machine).
When i try to connect from an other (unix-)system
i get after a while (ca. 90 sec.) the error:
ORA-12535: TNS:operation timed out
tnsping works fine (answer comes back in one second)
There are no firewalls or other "strange" things between
the database and the failing client (on an other PC,
also win2000, Oracle 8.1.5 everything works fine).
Below you see the log with debug of the listener.
I have also a trace on level SUPPORT but this is more
than 1000 lines for just 1 or 2 TNSPINGs and one SQLPLUS
connect. Due to this volume i decided not to attach it to
this initial mail.
Does any one have some advice or experiences ?
Please advice.
Best regards,
Markus....@web.de
======================================================================
TNSLSNR for 32-bit Windows: Version 8.1.5.0.0 - Production on
19-APR-01 09:07:26
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Die System-Parameterdatei ist D:\Oracle81\network\admin\listener.ora
Log-Meldungen wurden geschrieben in:
D:\Oracle81\network\log\listener.log
Listen auf: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=driller-nb)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
CODE
19-APR-01 09:07:28 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=mdriller))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135286784))
* status * 0
19-APR-01 09:08:04 * service_register * MDR50 * 0
19-APR-01 09:08:11 * trc_level * 0
19-APR-01 09:08:16 * trc_level * 0
---------------- BEGIN TNSLSNR DEBUG ---------------------
*** ENDPOINT #1 **
Name:
Address: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=driller-nb)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
Presentation: ttc
Session: NS
Info = <none>
Display: <none>
Load: 0
Handler ID = 80FFE377148D-41F8-AAC2-09A8BD4BE682
Oracle SID = <none>
Flags:
---------------------------------------------------
** INSTANCE #1 **
INSTANCE_NAME: MDR50
SERVICE_NAMEs: MDR50
INSTANCE LOAD: 0
INSTANCE ID: 4CC2FCDA6819-40D2-839D-F1628CC0BCA2
FLAGS: LOCAL
VERSION: 81500
NUM. HANDLERS: 2
Handler Matrix: (NS):
tcp nmp spx raw ipc beq lu62 tcps ANY
ttc 0 0 0 0 0 0 0 0 0
giop 0 0 0 0 0 0 0 0 0
http 0 0 0 0 0 0 0 0 0
ro 0 0 0 0 0 0 0 0 0
ANY 0 0 0 0 0 0 0 0 2
Handler Matrix: (RAW):
tcp nmp spx raw ipc beq lu62 tcps ANY
ttc 0 0 0 0 0 0 0 0 0
giop 0 0 0 0 0 0 0 0 0
http 0 0 0 0 0 0 0 0 0
ro 0 0 0 0 0 0 0 0 0
ANY 0 0 0 0 0 0 0 0 0
SERVICE HANDLERS:
---------------------------------------------------
Name: DEDICATED
Address: (ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARGV0=oracleMDR50)(ARGS='(LOCAL=NO)'))
Presentation: <none>
Session: <none>
Info = LOCAL SERVER
Display: DEDICATED SERVER
Load: 0
Handler ID = 83CB008C17A3-4E48-94DA-2765A62AAD7E
Oracle SID = <none>
Flags: BEQUEATH
---------------------------------------------------
Name: DEDICATED
Address: (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleMDR50)(ARGS='(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))'))
Presentation: <none>
Session: NS
Info = LOCAL SERVER
Display: DEDICATED SERVER
Load: 0
Handler ID = D9E0EC298D16-40FA-935F-7B989D139666
Oracle SID = MDR50
Flags: BEQUEATH CONNECTED DYNAMIC
---------------------------------------------------
** INSTANCE #2 **
INSTANCE_NAME: PLSExtProc
SERVICE_NAMEs: PLSExtProc
INSTANCE LOAD: 0
INSTANCE ID: 000000000000-0000-0000-000000000000
FLAGS: LOCAL
NUM. HANDLERS: 1
Handler Matrix: (NS):
tcp nmp spx raw ipc beq lu62 tcps ANY
ttc 0 0 0 0 0 0 0 0 0
giop 0 0 0 0 0 0 0 0 0
http 0 0 0 0 0 0 0 0 0
ro 0 0 0 0 0 0 0 0 0
ANY 0 0 0 0 0 0 0 0 1
Handler Matrix: (RAW):
tcp nmp spx raw ipc beq lu62 tcps ANY
ttc 0 0 0 0 0 0 0 0 0
giop 0 0 0 0 0 0 0 0 0
http 0 0 0 0 0 0 0 0 0
ro 0 0 0 0 0 0 0 0 0
ANY 0 0 0 0 0 0 0 0 0
SERVICE HANDLERS:
---------------------------------------------------
Name: DEDICATED
Address: (ADDRESS=(PROTOCOL=beq)(PROGRAM=extproc)(ENVS=)(ARGV0=extprocPLSExtProc)(ARGS='(LOCAL=NO)'))
Presentation: <none>
Session: <none>
Info = LOCAL SERVER
Display: DEDICATED SERVER
Load: 0
Handler ID = 56D4DAD11082-4097-992C-AF7F8067D858
Oracle SID = <none>
Flags: BEQUEATH
---------------------------------------------------
---------------- END TNSLSNR DEBUG ---------------------
19-APR-01 09:08:28 * debug * 0
19-APR-01 09:08:41 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=mdriller))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135286784))
* status * 0
19-APR-01 09:09:57 * ping * 0
19-APR-01 09:10:16 *
(CONNECT_DATA=(SID=MDR50)(CID=(PROGRAM=)(HOST=slarti)(USER=mdriller)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.34)(PORT=55678)) * establish
* MDR50 * 0
19-APR-01 09:14:39 * trc_level * 0
19-APR-01 09:14:58 * trc_level * 0
19-APR-01 09:15:06 * trc_level * 0
19-APR-01 09:16:16 * trc_level * 0
19-APR-01 09:16:20 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=mdriller))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135286784))
* status * 0
19-APR-01 09:16:33 * trc_level * 0
19-APR-01 09:17:09 * ping * 0
19-APR-01 09:17:51 *
(CONNECT_DATA=(SID=MDR50)(CID=(PROGRAM=)(HOST=slarti)(USER=mdriller)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.34)(PORT=55695)) * establish
* MDR50 * 0
19-APR-01 09:18:06 * MDR50 *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.34)(PORT=55695)) *
service_update * MDR50 * 0
19-APR-01 09:23:33 *
(CONNECT_DATA=(SID=MDR50)(CID=(PROGRAM=)(HOST=deep-thought)(USER=mdriller)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.22)(PORT=42006)) * establish
* MDR50 * 0
19-APR-01 09:28:09 * MDR50 *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.22)(PORT=42006)) *
service_update * MDR50 * 0
19-APR-01 09:28:25 * ping * 0
Sybrand Bakker
1 this may well be a lousy network, and you need to troubleshoot on
the network level (preferably from the unix-side)
2 8.1.5 has never been certified on win2k
3 It also has been desupported. Please upgrade to 8.1.7 asap, as 8.1.6
will be desupported end of October.
Hth,
Sybrand Bakker, Senior Oracle DBA