Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12535: TNS:operation timed out on a win2000 Oracle instance

ORA-12535: TNS:operation timed out on a win2000 Oracle instance

From: Markus Driller <drschorsch_at_yahoo.de>
Date: 14 Aug 2001 03:30:51 -0700
Message-ID: <32850cc4.0108140230.11e56fd7@posting.google.com>


Hi,
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.Driller_at_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 ---------------------

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
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
Received on Tue Aug 14 2001 - 05:30:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US