Intermittent Slow Oracle Net from Windows 7/Vista/2008 machines

Hi.

I have faces some interesting issue that worth a blog post.

After rebooting Windows 2003 Server with installed Oracle Database 9.2 some clients machines(with installed Windows 7) started to work very slowly with Oracle Database. Other clients, with installed Windows XP, worked as usual – fine. There no network hardware issues for Windows 7 machines – both machines were tested for the same network cable: Windows XP works fine, but Windows 7 is very slow…

Oracle sessions were tracing with 10046(level 12) event and it revealed that there are no issues with database – just network…

Listener was rebooted – didn’t helped…

System administrators noticed that Windows 2003 machine was claiming that it was not able to update root certificates, so they decided to provide Internet connection and update root certificates. Updates required server reboot and… vuala… after server rebooted everything was OK from every workstation.

Nobody was able to explain what was THE REASON, but EVERYBODY  WERE HAPPY.

Later, in two days, they required to reboot mentioned server once again, and after reboot Windows 7 workstation started working slowly…

I was there so it was time to see what is happening. Continue reading

Enabling SQL*Net Tracing with Oracle Instant Client

Just a quick note for myself about Enabling SQL*Net Tracing with Oracle Instant Client.
There are absolutely nothing special for Instant Client, except the note that clients starting with version 11.1 use Automatic Diagnostic Repository (ADR) for storing log and trace data, so for tracing clients up to 10.2 we use next parameters in SQLNET.ORA:

TRACE_LEVEL_CLIENT=(OFF | USER | ADMIN | SUPPORT)
TRACE_DIRECTORY_CLIENT=D:\ORACLE\PRODUCT ($ORACLE_HOME/network/trace | %ORACLE_HOME%\network\trace)
TRACE_FILE_CLIENT=client_trace.trc (sqlnet.trc)
TRACE_TIMESTAMP_CLIENT=(ON | true | off | false)
TRACE_UNIQUE_CLIENT=(ON | true | off | false)

TRACE_FILELEN_CLIENT=max size of the client trace files in kilobytes
TRACE_FILENO_CLIENT=1

Starting from Oracle version 11.1 there are two possible destinations for trace and log files: Automatic Diagnostic Repository (ADR) and non-ADR(old pre 11.1-style).
For ADR-destination we specify:

TRACE_LEVEL_CLIENT=(OFF | USER | ADMIN | SUPPORT)
DIAG_ADR_ENABLED=ON
ADR_BASE=D:\ORACLE\LOG

(default for ?nux:  ~/oradiag_username/clients/user_username/host*/trace

for windows %systemdrive%\Documents and Settings\%username%\oracle\oradiag_%username%\diag\clients\user_%username%\host*\trace)
TRACE_TIMESTAMP_CLIENT=(ON | true | off | false)

For non-ADR(old style – pre 11.1) destination we specify:

TRACE_LEVEL_CLIENT=(OFF | USER | ADMIN | SUPPORT)
DIAG_ADR_ENABLED=OFF
TRACE_DIRECTORY_CLIENT=D:\ORACLE\PRODUCT
TRACE_FILE_CLIENT=client_trace.trc (sqlnet.trc)
TRACE_UNIQUE_CLIENT=(ON | true | off | false)
TRACE_TIMESTAMP_CLIENT=(ON | true | off | false)

TRACE_FILELEN_CLIENT=max size of the client trace files in kilobytes
TRACE_FILENO_CLIENT=1

PS: for Oracle Instant Client preferred locations for SQLNET.ORA are:

  • current directory
  • location specified by TNS_ADMIN variable

References:

  • 454927.1 Using and Disabling the Automatic Diagnostic Repository (ADR) with Oracle Net for 11g
  • 219968.1 SQL*Net & Oracle Net Services – Tracing and Logging at a Glance
  • 834822.1 Oracle Net Diagnostics
  • 1076022.1 Examples of Troubleshooting Slow Oracle Net Connections

Failed to read volume information for XXX, err 1005

Hi.

There are some discussions that mentioned error doesn’t allow to install Oracle RAC on Windows platform.

I have faced the same issue last week so I decided to make short post about it.

Excerpt from C:\Windows\Temp\exectask.log:

01/31/11 12:59:16 : (1896) : QueryDosDeviceAll: buffer was filled with 8922 bytes
...
01/31/11 12:59:16 : (1896) : Failed to read volume information for \Device\Harddisk2\Partition1, err 1005
01/31/11 12:59:16 : (1896) : The count = 8
01/31/11 12:59:16 : (1896) : The signature is 0x526f5d4d
01/31/11 12:59:16 : (1896) : Failed to read volume information for \Device\Harddisk3\Partition1, err 1005
01/31/11 12:59:16 : (1896) : The count = 8
01/31/11 12:59:16 : (1896) : The signature is 0xb893c528
01/31/11 12:59:16 : (1896) : Failed to read volume information for \Device\Harddisk4\Partition1, err 1005
01/31/11 12:59:16 : (1896) : The count = 8

Continue reading