What is your server side sqlnet.ora setting for NAMES.DIRECTORY_PATH?
Net8 used the default configuration:
in %ORACLE_HOME%\network\admin\sqlnet.ora
NAMES.DIRECTORY_PATH = (HOSTNAME,ONAME,TNSNAMES)
The offending entry is "HOSTNAME", where host naming is a new feature of
Net8 which enables users in a TCP/IP environment to resolve Oracle
service names via their existing name resolution service. This name
resolution service might be DNS, NIS, WINS or even /etc/hosts. (Thanks
Metalink for the quote)
Changing NAMES.DIRECTORY_PATH=(TNSNAMES) should fix the problem.
Regards,
Afzal Chaudhry
-----Original Message-----
From: Sekhar_Chinamuthevi [mailto:[Email Address Removed]
Sent: Sunday, December 29, 2002 11:28 PM
To: LazyDBA.com Discussion
Subject: Connectivity To Database is very slow.
Hi Gurus,
I've Oracle 8.1.7.4.1 database on a Windows 2000 server. When connecting
to the database through SQL plus or SQL * Loader from the 2000 server
itself, its taking 5 seconds to establish a connection to the database.
Where the same activity is taking just 1 second when I'm trying to
connect from any other client over a network. The client version is
Oracle 8.1.7. I understood from this that the problem could be not
because of the network but due to some problem from Database server end
itself. I think the problem could be in some network configuration in
the server system itself. But I could not able to understand how to find
out the problem and how to resolve the same.
Your inputs in this regard will help to a great extent any help in this
regard will be greatly appreciated.
Thanks & Regards
Chandra Sekhar
************************************************************************
**
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.
************************************************************************
**
Oracle LazyDBA home page