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

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 1 Apr 2003 14:53:34 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7037FB391@lnewton.leeds.lfs.co.uk>

Hi Aad,

When you do 'sqlplus system/manager' you are not 'hitting the network' and you are using Bequeath protocol to access the database. This is quite quick due to being fully contained on the box you are running on.

When you do 'sqlplus system/manager_at_sidname' then Oracle uses the listener and you do 'hit the network' and you also use the TCP protocol.

Now, why does it take 15 seconds - I don't know, but check the sqlnet.ora file and see what the names.directory_path is set to, if you are using TNSNAMES.ORA files then it should look like this :

        NAMES.DIRECTORY_PATH = (TNSNAMES) Anyhting else *could* be the cause of your problem. There might also be a delay with if you ahve anything other than the following :

        SQLNET.AUTHENTICATION_SERVICES= (NONE) again in sqlnet.ora.

Not much help I'm afraid :o(

regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: aad.kramer_at_getronics.com (Aad Kramer) [mailto:aad.kramer_at_getronics.com]
Posted At: Tuesday, April 01, 2003 2:26 PM Posted To: server
Conversation: Slow response when connect through TNSNAMES.ORA to a Oracle 9i versie 2 database.
Subject: Slow response when connect through TNSNAMES.ORA to a Oracle 9i versie 2 database.

Hi,

Database Oracle 9I version 2
OS LINUX Redhat

When I connect to a database on a server with :

<SNIP> Received on Tue Apr 01 2003 - 07:53:34 CST