21 January, 2009

Oracle slow initial connection (default installation on Windows)

Recently, I'm managed to create a few Oracle DBs on various Windows box for development purpose.

As all are aimed for development purpose and no special configuration is planned. However, with default DB configuration on Windows, you will experience very slow initial connection lag time. To solve this problem, you need to disable NTS authentication.

To do this, edit sqlnet.or
SQLNET.AUTHENTICATION_SERVICES=(NONE)

Note that, you should see the original setting is NTS (which is native authentication method on Windows platform).