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 -> Re: Listener service_register causing tns timeout issues

Re: Listener service_register causing tns timeout issues

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 31 May 2002 06:26:35 +0200
Message-ID: <mnudfu0gju8ahttnlrhg3sahmd0s2a1ong@4ax.com>


On 30 May 2002 17:18:49 -0700, kevin_at_heide.org (Kevin Heide) wrote:

>I am having a problem with RDBMS 8.1.7.3.2 on a Win2K Server.
>After I restart a the listener, I can connect from a client
>workstation repeatedly until the lines:
> 30-MAY-2002 18:09:30 * service_register * DEVSKIES * 0
> 30-MAY-2002 18:09:30 * service_register * TAA * 0
> 30-MAY-2002 18:09:30 * service_register * WTBREP * 0
>show in the log. Once this automated registration occurs, I can no
>longer connect to the instance receiving the: "ORA-12535:
>TNS:operation timed out" error message. What does the PMON process due
>that would break the ability to connect to these instances?
>
>Kevin Heide

Must be something with your sqlnet setup not with PMON. My crystall ball is wearing out, so could you please post listener.ora, tnsnames.ora, sqlnet. init.ora parameters db_name, db_domain, service_name and any firewall related information. You could of course also trace the connection from the client side with level 16. How to do this is in the docs, and I have posted it many times here.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 30 2002 - 23:26:35 CDT

Original text of this message

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