Slow Connection

[Shahine]

Hi..

One of our customers is reporting slow connection to Oracle (some times)?

We are using Delphi-6 Ent with DOA 3.4.6.1 to connect to Oracle-9i using TNS.
The clients have the variable TNS_ADMIN and are pointing to a central network for the TNSNAMES.ORA

Most of the time the connection (Time for OracleSession to connect) takes 4 or 5 seconds.
However occasionally it takes between 70 & 80 seconds to establish connection?

Any idea why?

Ps:

There are 3 separate Oracle-9i databases on the Server. The server is a powerful machine (2+ GB Ram) with only has 10 concurrent users

Many Thanks
Shahine Ghanbarzadeh

 

[Marco Kalter]

Perhaps you can verify if the sqlnet.ora file from the Primary Oracle Home (\network\admin\sqlnet.ora or \net80\admin\sqlnet.ora) contains a line like this:
SQLNET.AUTHENTICATION_SERVICES=(NTS)

If so, change it to a comment line:

# SQLNET.AUTHENTICATION_SERVICES=(NTS)

Now connection time should be improved considerably.

------------------
Marco Kalter
Allround Automations

 

[benthicsoftware]

Hi Marco,

Just a quick question on this. I do it to all my installations and it definitely helps enormously. I've been hesitant to recommend it to all of my customers because I assume that someone must need the NTS setting. Do you have any idea why that setting is the default and who needs it? Thanks for any info!

-Mark Ford
Benthic Software

 

[Shahine]

Thanks I'll give this a go..
Shahine..

Originally posted by mkalter:
Perhaps you can verify if the sqlnet.ora file from the Primary Oracle Home (\network\admin\sqlnet.ora or \net80\admin\sqlnet.ora) contains a line like this:
SQLNET.AUTHENTICATION_SERVICES=(NTS)

If so, change it to a comment line:

# SQLNET.AUTHENTICATION_SERVICES=(NTS)

Now connection time should be improved considerably.

 

[Marco Kalter]

Marc,

NTS authentication is automatically configured by the Oracle Installer, even though it is not appropriate in most situations. Oracle MetaLink note 106328.1 describes the problem and solution.

------------------
Marco Kalter
Allround Automations