Re: SQL*Net Connection

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 06 Nov 1998 20:28:30 GMT
Message-ID: <910384005.19318.0.spot.d4ee154e@news.demon.nl>

In article <01be07ee$87c1f9c0$1047ea9e_at_P014635.logica.co.uk>, "James" <mckayjanospam_at_logica.com> wrote:
>Are there any SQL*Net parameters I can tweak which will speed up connection
>time?
>

Usually connection problems are a result from a sqlnet.ora that is fine for the server and not for the client.
sqlnet.ora is located in oracle_home\network\admin

There is a line normally reading
automatic_ipc = ON

for clients it should be OFF

Then there is a line
names.directory_path = (ONAMES, TNSNAMES)

If you didn't configure Oracle Names, make sure you either delete ONAMES, or reverse the sequence of TNSNAMES and ONAMES. Otherwise it will try to find an Oracle Names server which doesn't exist. If you want to see what the heck it is doing, change TRACE_LEVEL_CLIENT from OFF into 16, and it will dump every call and every attempt it makes to connect.

Hth,

Sybrand Bakker, ORACLE DBA Received on Fri Nov 06 1998 - 14:28:30 CST