Connection to Oracle sometimes hangs

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,
HennieHi

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.googlegr oups.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|||Hi john, Thanx for your answer, but we dont use linked server. Just an
OLEDB connection (via UDL's) with Oracle. Well the customer has
investigated a bit further and told me that a value of 70 characters
is written into a field of 40 characters. When he executes the packages
by hand it will throw an error. When executed with aid of a job it will
continue running. So I think it could be a JOB problem in SQL Server
2000. Any one ideas?