Windows 7 Connection Problems

Also my Idea,

- on the win7 clients we ran all updates coming from the standard windows update
- yesterday I downloaded the latest instanclient (sqlplus 64bit) and got the same problems

Is SP1 for 7 already downloadable on msn ?

its available for technet and MSDN subscribers right now.  Not that it's the fix, but worth a shot.  Have you contacted Oracle for support on the matter yet?

Installed SP1 for Win7, same effect.
I did not contact Oracle yet...

The Behaviour is still the same, we also get trouble sometimes opening files on a fileshare (windows) which takes very long, but always sometimes. Only this test making a sqlplus connection several times is reproducable. Sometimes the First connect takes about 20 seconds, somtimes the fifth connect takes about 20 seconds, all the other connects are connected in less than 100ms

Any new Ideas ?

Good Hint, checked it and set it to the second option (Enable File sharing for devices that use 40- or 56 bit encryption)

Setting this on the client and rebooting win7 has no effect. Timeouts occur when connecting to the oracle
database via sqlplus after the third or the forth connect. Well not really Timeouts occur the connection to the database
is about 1 minute, compared to milliseconds.

The Oracle Database is virtualized on a ESXi and runs under CentOS.

Maybe here are my settings in the sqlnet.ora on the client side :

AUTOMATIC_IPC = OFF
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
# The following parameters were set by TOAD
NAMES.DIRECTORY_PATH=(LDAP, TNSNAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES=(NTS)
SQLNET.EXPIRE_TIME=0
TRACE_FILELEN_CLIENT=100
TRACE_FILENO_CLIENT=3
TRACE_LEVEL_CLIENT=OFF
TRACE_TIMESTAMP_CLIENT=ON
TRACE_UNIQUE_CLIENT=ON
USE_DEDICATED_SERVER=OFF

Select allOpen in new window

And the tnsnames.ora entry :

XXXX.WORLD=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.71)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = YYYYY)
    )
  )  

Select allOpen in new window

 

To start searching in an other direction. But !!! The Problem only occurs on Win7, under Vista or XP when we use the same Oracle Client (instantclient) we do not have connection timeouts after the third or forth connect.

Regards
Hansjörg

well discoverd something else.

The Problem is not connecting to the database, the Problem is starting sqlplus, even when not directly connecting to the database

sqlplus /nolog

Select allOpen in new window

has the same efffekt as

sqlplus /nolog connect.sql

Select allOpen in new window

connect.sql
connect user/pass@db
connect user/pass@db1

Select allOpen in new window

forget last comment, sqlplus /nolog is fast, problem only occurs when connecting.

Sorry

Sorry Merete, hints about instantclient do not help... but
maybe a firewall problem ... we installed a new firewall...

We use an Zywall USG200

I'm the one who should say sorry for offering googles, no need to apologise hgraesslin1  :P
Hope it's the firewall. Often is that simple.
That'd be sweet

problem is solved.

thanks to all.

Excellent to hear . Thank you Hansjoerg
kind regards
Merete