Posted by John Bell on 01/03/06 12:24

Hi

I am not sure if this will be any help, but may be worth a read!
http://support.microsoft.com/kb/280106/

John

"Hennie7863" <hdenooijer@hotmail.com> wrote in message
news:1136279581.264058.154520@g14g2000cwa.googlegroups.com...
> Hi,
>
> For a customer we have implemented a datawarehouse with a connection to
> Oracle. From the beginning of the project the connection to Oracle
> gives troubles. The next morning is the connection still active and
> when the customer looks in the processes of SQL Server a " Wait type,
> RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
> for a resource, in this case Oracle but doesn't tell me anything about
> what could be the problem.
>
> The customer uses the Oracle driver instead of a microsft oracle
> driver.
>
> What could it be? and how can we tackle this problem? Are there ways to
> look from Oracle point of view? Can we monitor something?
>
> Greetz,
> Hennie
>

[Back to original message]