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 -> Slow response when connect through TNSNAMES.ORA to a Oracle 9i versie 2 database.

Slow response when connect through TNSNAMES.ORA to a Oracle 9i versie 2 database.

From: Aad Kramer <aad.kramer_at_getronics.com>
Date: 1 Apr 2003 05:25:46 -0800
Message-ID: <ab47807b.0304010525.777ddd6@posting.google.com> 





Hi,



Database Oracle 9I version 2


OS LINUX Redhat



When I connect to a database on a server with :



sqlplus system/manager : then the connect is fast (no problem).



when I using :



sqlplus system/manager_at_sidname a connect takes about 10 / 15 seconds.



The same problem occurs when using TNSPING : it takes about 15 seconds
to find the sid. PING is in 20 ms.




Checked the /etc/hosts file for read permissions for all users.
Checked tne TNSNAMES.ORA for the servernames.
 



Thanks in advance for your suggestions.



Aad Kramer
Received on Tue Apr 01 2003 - 07:25:46 CST












Original text of this message













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